Data Engineer

Key Responsibilities

• Design and build automated data pipelines that ingest and reconcile data from LTC, Compass, Data Factory, DLMP exports, and future Beaker exports.
• Build and maintain the Google BigQuery (GBQ) data repository that hosts the crosswalk and comparison datasets.
• Develop the automated comparison/visualization data layer used for the Test Classification Dashboard and Executive Impact Dashboard.
• Support ongoing refinement of the crosswalk repository's data pipelines as DLMP source data changes over time.
• Partner with the Software Engineer(s) to define data contracts/APIs that power the client-facing tools.

Required Skills & Experience

• 4+ years of experience as a data engineer or similar role.
• Hands-on experience with Google BigQuery (GBQ) or an equivalent cloud data warehouse (e.g., Snowflake, Redshift) required or strongly preferred.
• Strong SQL and ETL/pipeline development experience across multiple source systems.
• Experience with API integrations and scheduled/automated data exports.
• Experience designing data models that support downstream dashboards and applications.

Preferred Skills & Experience

• Experience with Google Cloud Data Fusion or similar ELT/ETL no-code pipeline tooling.
• Healthcare, laboratory, or life sciences industry experience.
• Experience supporting agentic AI or AI-assisted query tools (a future-state opportunity for this program).

Primary Deliverables

• Automated data pipelines from all required source systems
• GBQ-hosted comparison/crosswalk repository
• Data layer supporting the Test Classification Dashboard and Executive Impact Dashboard

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.