Google Cloud Platform Data Engineer

Другое

• (ID: 2026-2740)
• Company Informatics is a bioscience and information technology company advancing translational research through biomedical informatics, data science, artificial intelligence, and intelligent automation. We partner with research centers, healthcare organizations, and government agencies around the globe to transform complex data into actionable insights that accelerate scientific discovery and improve decision-making. Our multidisciplinary teams of experts in biomedical science, software engineering, data engineering, AI, automation, and program management develop innovative technologies, modernize data ecosystems, and create scalable solutions that enable the next generation of research and healthcare innovation.
•  
• Role Overview
• We are seeking an experienced GCP Data Engineer to own the technical pipeline infrastructure for a Finance Transformation program. The successful candidate will design and implement the shared pipeline architecture that underpins the program's data product delivery, building the Workday and Oracle Finance connectors and owning the unified data model, lineage graph, and real time event capture infrastructure.
• This is a senior, hands on engineering role requiring deep expertise in GCP pipeline services, Workday and Oracle API extraction, and data lineage architecture. The candidate will establish the GCP native pipeline pattern used by both domain connectors, pair with each domain analyst on their source specific extraction builds, and ensure the unified data model in Cloud SQL serves all three reporting lenses -- Function, Supervisory Organization, and Job Family -- from a single join layer.
• The successful candidate will combine engineering rigor with practical delivery focus, able to move between architectural design and production build, and provide clear technical guidance to domain analysts who own the domain specific extraction logic.
• Key Responsibilities
• Design and implement the shared GCP native pipeline architecture, establishing the Cloud Dataflow and Cloud Composer pattern that both HR and Finance connectors follow, with pipeline health monitoring, alerting, and audit trail via Cloud Monitoring and Cloud Logging.
• Build the Workday connector using RaaS for bulk extraction and REST APIs for real time lifecycle event capture, and configure Firebase Realtime Database to reflect classification and cost changes within minutes of each lifecycle event.
• Build the Oracle Finance connector using REST APIs with SOAP fallback, applying basis tagging at ingestion so the same pipeline serves statutory, management, Lloyd's, and regulatory reporting without rerunning the extract.
• Pair with each domain analyst on their source specific extraction builds, providing GCP architectural guidance while the analyst owns domain specific field mapping, validation, and sign off.
• Design and maintain the Cloud SQL unified data model, including the HR to Finance mapping table and the join layer that serves all three reporting lenses -- Function, Supervisory Organization, and Job Family -- from a single data model.
• Implement the lineage graph in Cloud SQL, publish definitions and lineage via REST API to downstream components, and configure Firebase to stream audit events continuously, logging every access, change, and approval.
• Ensure the data model supports DirectQuery from Power BI Embedded and that all pipeline solutions comply with client governance, security, and segregation of duties requirements.
• Required Qualifications
• 5+ years of GCP engineering experience, with deep expertise in Cloud Dataflow, Cloud Composer, and Cloud SQL, including designing and operating production data pipelines in these services.
• Demonstrable experience extracting data from Workday using RaaS bulk export and REST APIs for real time event capture, with an understanding of Workday supervisory org and worker classification data structures.
• Demonstrable experience extracting data from Oracle Fusion Cloud using REST APIs, with SOAP API awareness as a fallback pattern.
• Experience designing relational data models in Cloud SQL that serve multiple reporting lenses from a single join layer.
• Strong understanding of data lineage implementation -- specifically building lineage graphs in a relational store and surfacing them via REST API to downstream applications.
• Strong troubleshooting, root cause analysis, and production support skills.
• Excellent communication skills and ability to guide domain SMEs on technical architecture decisions.
• Required Technical Skills
• Cloud Dataflow, Cloud Composer, Cloud SQL, Cloud Run, Firebase Realtime Database, Cloud Monitoring, and Cloud Logging
• Workday RaaS and REST APIs; Oracle Fusion Cloud REST APIs with SOAP fallback
• Unified data model design across HR and Finance systems, lineage graph implementation with REST API publishing, and basis tagging at ingestion
• DirectQuery semantic layer design, Power BI Embedded integration, and Informatica
• Preferred Qualifications
• GCP Professional Data Engineer certification or equivalent demonstrated experience.
• Exposure to Power BI Embedded and DirectQuery configuration.
• Familiarity with Informatica and experience designing migration paths to GCP native tooling without breaking existing data models.
• Insurance or financial services background with familiarity with multibasis reporting requirements.
• Experience delivering GCP data infrastructure in consulting or professional services environments.
• Deep technical expertise in GCP pipeline services, data architecture, and lineage design, with the ability to design shared infrastructure that serves multiple parallel domain workstreams.
• Ability to lead distributed technical workstreams, mentor domain analysts, and communicate architectural decisions clearly to both technical and governance stakeholders.
• Strong attention to data quality, lineage integrity, and pipeline observability, with the ability to work independently and drive technical outcomes.
• Success Criteria
• Establish and document the shared GCP native pipeline architecture before domain connector builds begin.
• Deliver both the Workday and Oracle connectors on schedule, producing validated, lineage stamped data to Cloud SQL.
• Implement a unified data model supporting all three reporting lenses from a single join layer.
• Stand up the lineage graph, enabling any dashboard metric to be traced to its originating source record.
• Configure Firebase real time event capture with continuous audit event streaming.
• Enable domain SMEs to build their source specific extraction logic confidently within the established pipeline pattern.
• Ensure the data model supports DirectQuery from Power BI Embedded across all certified data products.
• The diversity of Company’s employees is a tremendous asset. We are firmly committed to providing equal opportunity in all aspects of employment and will not tolerate any illegal discrimination or harassment-based age, race, gender, religion, national origin, disability, marital status, covered veteran status, sexual orientation, status with respect to public assistance, and other characteristics protected under state, federal, or local law and to deter those who aid, abet, or induce discrimination or coerce others to discriminate.
• Accessibility: If you need an accommodation as part of the employment process, please contact careers@
• Disclaimer: The above is meant to illustrate the general nature of work and level of effort being performed by individual’s assigned to this position or job. This is not restricted as a complete list of all skills, responsibilities, duties, and/or assignments required. Individuals may be required to perform duties outside of their position, job or responsibilities as needed.