The professional will design, build, and operate automated data pipelines to extract information from Oracle Health systems for ingestion into the Google Cloud Platform. This role involves developing and optimizing data repositories within BigQuery to support analytics and public health initiatives. The individual will write supporting code for ingestion and orchestration while ensuring the reliability and cost efficiency of the data flow. As the primary technical owner, the person will manage the end-to-end lifecycle of these pipelines. The work focuses on maintaining data governance and accessibility for the Commonwealth of Virginia.

The role requires senior-level experience in data engineering or data warehouse architecture. Candidates must possess deep hands-on expertise with Google Cloud Platform, specifically BigQuery and GCP Cloud Functions. Advanced proficiency in Python is necessary for automation and data engineering tasks. Additionally, the position requires experience with relational source systems, such as Oracle, and the ability to manage large-scale data pipelines independently.