Preferred Education:
• Preferred Bachelor’s degree in public health and/or Bachelor’s degree in computer science or related fields
Required experience:
• Significant experience in public health or in the analysis of health data
• Direct experience in warehouse design, development, modeling, support, and operations utilizing Snowflake (3+ years)
• Experience in Structured Query Language (SQL) Server 2012 or later (5+ years)
• Experience and conceptual understanding of data integration tools and technologies such as Microsoft SSIS and RDBMS concepts and methods
• Strong understanding of data modeling and ETL processes
• Development experience working within Cloud Platform (AWS)
• Development experience working within the Snowflake Platform
• Stored procedure development and optimization, SQL Server Integration Services (SSIS) development, and complex query development utilizing multiple large data sources using SQL 2012 or later
• Strong understanding of data modeling and ETL processes
• Business Intelligence Development, Application Program Interface (API) development
• Experience manipulating, customizing, and automating using scripting languages Python/PowerShell
Preferred experience:
• Experience with Snowflake
• Experience in SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), Application Program Interface (API) development, SQL Server Analysis Services (SSAS), working knowledge of Database design and implementation, and Healthcare Informatics preferred
• Development experience within Cloud Platforms is preferred
Job Overview:
• The Snowflake Data Engineer will be responsible for designing, implementing, and optimizing data solutions using the states Snowflake data platform (SPARK). The position will work closely with cross-functional teams to ensure data integrity, security, and performance. This role requires a deep understanding of data warehousing, ETL processes, the Snowflake platform, and SQL.
• The Snowflake Data Engineer will be responsible for developing system requirements, assisting with the ascertainment of newly identified data sources with the primary directive of onboarding those data sources into the SPARK platform. This will require the position to work closely with data stewards and internal partners to better understand their current and future needs, expected outcomes and uses of their data within the Snowflake data platform (SPARK).
• As part of the onboarding activities this position will be responsible for development of ingestion processes, mapping, validation, and transformation of partner data, in conjunction with ensuring data quality, automating data pipelines, accurately mapping data fields from disparate sources, and troubleshooting ingestion errors for seamless system adoption
• A qualified candidate must have experience working within an AWS environment utilizing the Snowflake platform for developing high-quality database solutions and possess in depth knowledge of database design and optimization. A candidate must have experience developing and maintaining scripting languages such as Python and PowerShell.
• This position requires a solid understanding of computer science fundamentals and experience with the utilization and development of RESTful APIs, both custom and existing.
Job Responsibilities:
• Support development and administration of client’s Snowflake Platform (SPARK)
• Support development and administration of onboarding activities with the client’s Snowflake Platform (SPARK)
• Assist with development and execution of Quality Assurance protocols, including data integrity and security
• Support business intelligence design and implementation
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
You are customer service oriented. No matter whether it was the Recruiter or someone in Human Resources/Payroll, you were responsive. That to me is key!
Tonya, Consultant
The interactions that I have had with your representatives have always been prompt and very professional. I am very pleased and impressed with your company and services.
Sioe, Consultant
It was great working for Rose International. Everyone was extremely helpful.
Rosann, Consultant
Your team at Rose International is always very helpful and responsive.
Barbara, Consultant
My on-boarding with Rose was outstanding. The packets of information, the process, and great attention to detail each person gave me allowed me to get started quickly.I appreciated each person's friendly and helpful attitude.
Diana, Consultant
EMPLOYEE COMMENTS