Job description

Job summary: Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced. Location: Telecommute Job type: Contract to Perm Salary: $49 - $59 per hour Work hours: Education: Bachelors Responsibilities Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced. Efficiently communicate with ETL architect while understanding the requirements and business process knowledge to transform data for end users. Assist in the overall architecture of the ETL design and proactively provide inputs in designing, implementing, and automating the ETL flows. Investigate and mine data to identify potential issues within ETL pipelines, notify end-users, and propose adequate solutions. Develop ETL pipelines and data flows in and out of the data warehouse using Azure Data Factory and Snowflake. Design idempotent ETL processes so interrupted, incomplete, or failed runs can be rerun without errors using ADF dataflows and pipelines. Work in Snowflake virtual warehouses and automate data pipelines using Snowpipe for tedious ETL problems. Capture changes in data dimensions and maintain versions using stream sets in Snowflake and schedule them using tasks. Optimize every step of data movement, not only source and travel but also when data is at rest for accelerated responses. Build a highly efficient orchestrator that schedules jobs, executes workflows, performs data quality checks, and coordinates task dependencies. Test ETL system code, data design, and pipelines; conduct root‑cause analysis on all processes and resolve production issues; perform routine database and pipeline tests. Document implementations, test cases, and build deployment documents needed for CI/CD. Required skills 5+ years of data engineering experience focused on data warehousing. 2+ years creating pipelines in Azure Data Factory (ADF). 3+ years creating stored procedures with Oracle PL/SQL, SQL Server T‑SQL, or Snowflake SQL. Experience 5+ years of data engineering experience focused on data warehousing. 2+ years 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. 3+ years creating stored procedures with Oracle PL/SQL, SQL Server T‑SQL, or Snowflake SQL. 2+ years experience with GitHub, SVN, or similar source control systems. 2+ years of processing structured and unstructured data. Experience with HL7 and FHIR standards and processing files in these formats. 3+ years analyzing project requirements and developing detailed ETL specifications. Excellent problem‑solving and analytical skills; ability to troubleshoot and optimize data pipelines. Ability to adapt to evolving technologies and changing business requirements. Bachelor’s or advanced degree in Information Technology, Computer Science, Mathematics/Statistics, Analytics, or Business. Team Structure 1 Data Manager 1 Data Modeller 1 Data Engineering Lead 4 Data Engineers Business Analyst QA Testers DBA Qualifications 5+ years of data engineering experience focused on data warehousing. 2+ years creating pipelines in Azure Data Factory (ADF). 3+ years creating stored procedures with Oracle PL/SQL, SQL Server T‑SQL, or Snowflake SQL. Equal Opportunity Employer Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact . Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short‑term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. #J-18808-Ljbffr

Requirements