Data Engineer

Overview

Remote
On Site
USD50 - USD62
Contract - W2

Skills

Data Engineer

Job Details

job summary:

Project:



  • This individual will be using a mapping document to write the ETL process to load the PI data mart.
  • They will be testing the load process.
  • They will be create a balancing routine to be executed after each data load.
  • They will work closely with data analytics and QA testes to ensure that the data is loaded correctly.
  • As a part of the ETL process there will be procedures for summarizing data.
  • They will be responsible for creating the ADF pipeline to move data from SQL Server to Snowflake and from Snowflake to SQL Server.









location: Minneapolis, Minnesota

job type: Contract

salary: $49.50 - 61.75 per hour

work hours: 8am to 5pm

education: No Degree Required



responsibilities:

Responsibilities:



  • Lead the development and management of ETL processes for Program Integrity data marts in Snowflake and SQL Server.
  • Design, build, and maintain data pipelines using Azure Data Factory (ADF) to support ETL operations and Peer Group Profiling procedures and outputs.
  • Implement and manage DevOps practices to ensure efficient data loading and workload balancing within the Program Integrity data mart.
  • Collaborate with cross-functional teams to ensure seamless data integration and consistent data flow across platforms.
  • Monitor, optimize, and troubleshoot data pipelines and workflows to maintain performance and reliability.
  • Independently identify and resolve complex technical issues to maintain operational efficiency.
  • Communicate effectively and foster collaboration across teams to support project execution and alignment.
  • Apply advanced analytical skills and attention to detail to uphold data accuracy and quality in all deliverables.
  • Lead cloud-based project delivery, ensuring adherence to timelines, scope, and performance benchmarks.
  • Ensure data security and compliance with relevant industry standards and regulatory requirements.








qualifications:

TOP 3 REQUIREMENTS:



  • Over 5 years of hands-on expertise in cloud-based data engineering and data warehousing, with a strong emphasis on building scalable and efficient data solutions.
  • More than 2 years of focused experience in Snowflake, including the design, development, and maintenance of automated data ingestion workflows using Snowflake SQL procedures and Python scripting.
  • Practical experience with Azure data tools such as Azure Data Factory (ADF), SQL Server, and Blob Storage, alongside Snowflake.


Additional Requirements:



  • Skilled in managing various data formats (CSV, JSON, VARIANT) and executing data loading/exporting tasks using SnowSQL, with orchestration via ADF.
  • Proficient in using data science and analytics tools like Snowpark, Apache Spark, pandas, NumPy, and Scikit-learn for complex data processing and modeling.
  • Strong experience with Python and other scripting languages for data manipulation and automation.
  • Proven ability to develop cloud-native ETL processes and data pipelines using modern technologies on Azure and Snowflake.
  • Demonstrated excellence in analytical thinking and independent problem-solving.
  • Strong interpersonal skills with a track record of effective communication and teamwork.
  • Consistent success in delivering projects within cloud environments, meeting performance and quality standards.
  • Working knowledge of medical claims processing systems, including familiarity with core functionalities, workflows, and data structures used in healthcare claims management.





skills: Preferred:



  • Certification in Azure or Snowflake
  • Experience with data modeling and database design
  • Knowledge of data governance and data quality best practices
  • Familiarity with other cloud platforms (e.g., AWS, Google Cloud)




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.



Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.