Snowflake Data Operations Engineer – Amick Brown, LLC – Raleigh, NC

Job title: Snowflake Data Operations Engineer Company: Amick Brown, LLC Job description: Amick Brown is seeking an experienced Data Operations Engineer - Snowflake for our direct client. Location: Raleigh, NC Duration: 4 Months. Job Description Snowflake engineer should be able to: • Design, develop and implement scalable batch/real-time data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse and Data Lake • Design and implement data model changes that align with warehouse dimensional modeling standards. • Proficient in Data Lake, Data Warehouse Concepts, and Dimensional Data Model. • Responsible for maintenance and support of all database environments, design and develop data pipelines, workflow, and ETL solutions in both on-prem and cloud-based environments. • Design and develop SQL stored procedures, functions, views, and triggers • Design, code, test, document, and troubleshoot deliverables • Collaborate with others to test and resolve issues with deliverables • Maintain awareness of and ensure adherence to the standards regarding privacy. • Create and maintain Design documents, Source to Target mappings, unit test cases, and data seeding. • Ability to perform Data Analysis and Data Quality tests and create audits for the ETLs. • Perform Continuous Integration and deployment using Azure DevOps and Git Technical Skills / Knowledge • Has demonstrated proficiency in designing and developing Azure Data Factory Pipelines. (2 Years) • Strong Experience designing and implementing Data warehouses. • Experience working with Microsoft BI stack (SSIS/SSRS/SSAS) and Microsoft SQL Server. (5 Years) • Must have Experience with at least one Columnar MPP Cloud data warehouse (Snowflake /Azure Synapse / Redshift) (2+ years) • Working knowledge of managing data in the Data Lake. • Knowledge in ETL tools like Fivetran, Airflow and DBT. • Experience with Git and Azure DevOps. • Solid understanding of programming SQL objects (procedures, triggers, views, functions) in SQL Server. Experience optimizing SQL queries is a plus. • Advanced understanding of T-SQL, indexes, stored procedures, triggers, functions, views, etc. • Must be detail-oriented. Must work under limited supervision. Must demonstrate good analytical skills as it relates to data identification and mapping and excellent oral communication skills. • Must be flexible and able to multi-task and be able to work within deadlines; must be team-oriented, but also be able to work independently. • Healthcare experience is a plus. Independence/ Accountability • Requires minimal daily supervision • Receives detailed instruction on new assignments and determines next steps with guidance • Regularly reviews goals and objectives with the supervisor • Demonstrates competence in relevant job responsibilities which allows for an increasing level of independence • Ability to manage and prioritize multiple tasks • Ability to work under pressure and meet deadlines • Problem Solving: • Makes logical suggestions of likely causes of problems and independently suggests solutions • Excellent organizational skills are required to prioritize responsibilities, thus completing work in a timely fashion • Outstanding ability to multiplex tasks as required • Attention to detail and concern for impact is essential • Communication Skills: • Must work well with others • Effectively communicates with others by giving and receiving feedback • Communicates ideas and information clearly Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California. Regular full-time employees are eligible for the following Amick Brown provided benefits: • Health • Vision • Dental • 401k with company match • Paid time off • Sick Leave • Short-Term Disability • Life Insurance • Wellness & Discount Programs Expected salary: Location: Raleigh, NC Job date: Sun, 14 Aug 2022 05:34:17 GMT Apply for the job now! Apply tot his job