Key skills
PythonSQLPowerShellETLData WarehousingBIBusiness IntelligenceSnowflakeSparkAWSSQL ServerRESTfulCommunication
About this role
CALL US NOW for immediate consideration! Click Apply on Web or Apply Now to view our recruiter s contact info and reach out today, we d love to speak with you!
===
** We will NOT accept 3rd Party (C2C) Contractors **
===
JOB DETAILS:
Position:Snowflake Data Engineer
JOB REF#:44376 - 65518
Duration:12 Months (Contract)
Location:HYBRID - Nashville, TN 37243
Pay Rate:$65.00 (W2) or Incorporated $72.00 (Not accepting C2C or 1099 candidates)
HYBRID: Must be able to work ONSITE once a month for meetings (LOCAL CANDIDATES ONLY)
HOURS: MON-FRI 8am-4:30pm (CST)
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.
Responsibilities include:
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
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.
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).
Support development and administration of TDH Snowflake Platform (SPARK)
Support development and administration of onboarding activities with the TDH Snowflake Platform (SPARK)
Assist with development and execution of Quality Assurance protocols, including data integrity and security
Support business intelligence design and implementation
REQUIRED SKILLS/EXPERIENCE:
Demonstrated experience in public health and/or health data analysis
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.
Must have experience developing and maintaining scripting languages such as Python and PowerShell.
Solid understanding of computer science fundamentals and experience with the utilization and development of RESTful APIs, both custom and existing.
3+ years of experience in data warehouse design, development, modeling, support, and operations, specifically utilizing Snowflake
5+ years of experience working with SQL Server (2012 or later) and Structured Query Language (SQL)
Experience with data integration tools and technologies, such as Microsoft SSIS, and strong understanding of RDBMS concepts and methodologies
Strong knowledge of data modeling and ETL (Extract, Transform, Load) processes
Excellent problem-solving and analytical skills. Effective communication and teamwork skills
EDUCATION: Bachelor s degree in Public Health, Computer Science, or a related field preferred; equivalent combination of relevant technical certifications and professional experience will be considered
TECHNICAL SKILLS:
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.
Excellent problem-solving and analytical skills.
Effective communication and teamwork skills.
Business Intelligence Development, Application Program Interface (API) development.
Experience manipulating, customizing, and automating using scripting languages Python/PowerShell.
DESIRED SKILLS:
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
Development experience within Cloud Platforms
==
==
Calance Consultant Benefits Offerings:
- EPO/PPO Medical Plans
- HMO/PPO Dental programs
- Vision - VSP (Vision Plan Summary)
- 401K Retirement vesting program (VOYA)
- Paid Bi-Weekly/Direct Deposit
- Flex Spending Plan
- Voluntary Life, AD&D, STD or LTD plans
===
** We will NOT accept 3rd Party (C2C) Contractors **
===
JOB DETAILS:
Position:Snowflake Data Engineer
JOB REF#:44376 - 65518
Duration:12 Months (Contract)
Location:HYBRID - Nashville, TN 37243
Pay Rate:$65.00 (W2) or Incorporated $72.00 (Not accepting C2C or 1099 candidates)
HYBRID: Must be able to work ONSITE once a month for meetings (LOCAL CANDIDATES ONLY)
HOURS: MON-FRI 8am-4:30pm (CST)
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.
Responsibilities include:
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
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.
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).
Support development and administration of TDH Snowflake Platform (SPARK)
Support development and administration of onboarding activities with the TDH Snowflake Platform (SPARK)
Assist with development and execution of Quality Assurance protocols, including data integrity and security
Support business intelligence design and implementation
REQUIRED SKILLS/EXPERIENCE:
Demonstrated experience in public health and/or health data analysis
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.
Must have experience developing and maintaining scripting languages such as Python and PowerShell.
Solid understanding of computer science fundamentals and experience with the utilization and development of RESTful APIs, both custom and existing.
3+ years of experience in data warehouse design, development, modeling, support, and operations, specifically utilizing Snowflake
5+ years of experience working with SQL Server (2012 or later) and Structured Query Language (SQL)
Experience with data integration tools and technologies, such as Microsoft SSIS, and strong understanding of RDBMS concepts and methodologies
Strong knowledge of data modeling and ETL (Extract, Transform, Load) processes
Excellent problem-solving and analytical skills. Effective communication and teamwork skills
EDUCATION: Bachelor s degree in Public Health, Computer Science, or a related field preferred; equivalent combination of relevant technical certifications and professional experience will be considered
TECHNICAL SKILLS:
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.
Excellent problem-solving and analytical skills.
Effective communication and teamwork skills.
Business Intelligence Development, Application Program Interface (API) development.
Experience manipulating, customizing, and automating using scripting languages Python/PowerShell.
DESIRED SKILLS:
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
Development experience within Cloud Platforms
==
==
Calance Consultant Benefits Offerings:
- EPO/PPO Medical Plans
- HMO/PPO Dental programs
- Vision - VSP (Vision Plan Summary)
- 401K Retirement vesting program (VOYA)
- Paid Bi-Weekly/Direct Deposit
- Flex Spending Plan
- Voluntary Life, AD&D, STD or LTD plans