Data Engineer

Story Behind the Need

• The goal is to develop more robust ETL processes to support reporting and dashboarding needs. Currently, the data ecosystem includes a mix of tables and queries in Teradata (labspace), reports in Excel, and dashboards in Power BI. However, there is no unified pipeline to manage and automate the flow of data across these platforms. The plan is to implement a pipeline using a combination of Control-M (for enterprise scheduling), SSIS, and potentially other ETL tools. While the surrounding team has strong expertise in Teradata, Excel, and Power BI, there is limited experience with Control-M and SSIS. The work environment is highly collaborative and fully remote, which supports cross-functional coordination and knowledge sharing.

Key points:

• Objective: Build a more reliable and automated ETL pipeline.
• Current tools: Teradata (tables and queries), Excel (reports), Power BI (dashboards).
• Target tools: Control-M, SSIS, and other ETL applications.
• Team strengths: Teradata, Excel, Power BI.
• Team gaps: Limited experience with Control-M and SSIS.
• Work environment: Collaborative and fully remote.
• No additional hiring needs at this time.

Typical Day in the Role

• The team holds daily standups to review current project workloads, discuss any issues, and share updates on what each member is working on. The projects typically involve evaluating and improving various components of the ETL pipeline. For example, if a report currently exists in Excel and is generated from a SQL query, the team assesses what steps are needed to automate parts of the SQL output or the Excel report itself. They also explore opportunities to transition such reports into Power BI dashboards and consider what that migration would entail. In cases where a full process already exists-from SQL to Power BI-the team looks for ways to enhance efficiency and determine which tools could support those improvements. This role is unique in that it is not solely focused on ETL development; instead, it requires a broader understanding of reporting workflows and a commitment to completing projects on time and to the best of each team member's ability.
• Performance expectations will be to complete the projects on time.

Candidate Requirements

• Required: Bachelors in Math, engineering, stats, comp sci, etc. Preferred: Masters
• Years of experience required: 1-3 years.
• Disqualifiers: Resume not matching the intended job titles/requirements.
• Additional qualities to look for: Healthcare experience, managed care experience preferred (not required)

• 1 Knowledge in SSIS, Control-M other ETL applications
• 2 Knowledge in SQL
• 3 Power BI

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.