Note: The job is a remote job and is open to candidates in USA. CTG delivers IT and business solutions that enhance clients' digital agility. The Data Engineer will design and maintain automated data pipelines, a Google BigQuery repository, and data layers supporting comparison tools and dashboards, while partnering with software engineers on data contracts and APIs.
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
Skills
- 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
- Hands-on experience with Google BigQuery (GBQ) or an equivalent cloud data warehouse (e.g., Snowflake, Redshift) ... 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
- 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)
Company Overview
Company H1B Sponsorship