Sr. Data Engineer
100% Telecommute
Hours: work in the CT time zone from Monday to Friday with some flexibility.
Project:
Client is currently seeking a hands-on Senior Data Engineer to support our CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Engineer will work with large healthcare datasets and will translate client's business requirements into enterprise systems, applications, or process designs for large complex health data solutions. The role will drive and support initiatives for the CT EDW as well as participate in the wider EDW groups areas of data usage and governance, information management, privacy and security, SOA, data analytics and visualization and information modeling.
Requirements:
• 5+ years of Data engineering experience with a focus on Data Warehousing
• 3+ years of experience creating working with Azure Data Factory (ADF) and Databricks
• 5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools.
• 5+ years of experience with Relational Databases, such as Oracle, Snowflake, SQL Server, etc.
• 5+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL
• 3+ years of experience with Azure DevOps, GitHub, SVN, or similar source control systems
• 2+ years of experience processing structured and un-structured data.
• Experience with HL7 and FHIR standards, and processing files in these formats.
• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements.
• Excellent problem-solving and analytical skills, with the ability to troubleshoot and optimize data pipelines.
• Ability to adapt to evolving technologies and changing business requirements.
• Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business
Preferred skills:
• 3+ years of batch or PowerShell scripting
• 3+ years of experience with Python scripting.
• 3+ years of data modeling experience in a data warehouse environment
• Experience or familiarity with Spark and Azure Data Fabric.
• Experience designing and building APIs in Snowflake and ADF (e.g. REST, RPC)
• Experience with State Medicaid / Medicare / Healthcare applications
• Azure certifications related to data engineering or data analytics.
Ideal background
Strong technical experience in ADF and Snowflake
Top skills needed:
5+ years of Data engineering experience with a focus on Data Warehousing
3+ years of experience creating pipelines in Azure Data Factory (ADF)
5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools.
5+ years of experience with Relational Databases, such as Oracle, Snowflake, SQL Server, etc.
What experience will set candidates apart from one another?
Strong technical experience in ADF and Snowflake
Required Skills : ADF - building out data pipelines Snowflake - as a Target SQL
Basic Qualification :
Additional Skills :
100% remote
Background Check : Yes
Drug Screen : Yes
Notes :
Selling points for candidate :100% remote
Project Verification Info :The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA: Blanket Approval Received Client Letter: Will Provide
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :
Master Job Title :
Branch Code :