Technical Lead - Operational Data Governance & Modernization | Onsite - Delaware

Photon•Wilmington, DE

11h•$56,000 - $196,000•Onsite

About The Position

We are seeking a Technical Lead for Operational Data Governance & Modernization to own the delivery of relational and canonical data models, and the organization's master data management (MDM) strategy. This role involves setting standards for advanced SQL usage and appropriate NoSQL patterns, defining schema-first data contract design, and driving the rollout of a data catalog with PII classification and data-regulation compliance. You will also own the delivery of the Snowflake/enterprise data warehouse, data pipelines, data change detection (CDC), and data validation/quality testing frameworks. A key aspect is owning "contract as code" governance, including data schema management via CI/CD and Git-based data governance. You will select and stand up appropriate AWS data services, manage the day-to-day delivery of an offshore team, and report delivery status, risks, and blockers to engineering leadership.

Requirements

8+ years in data engineering, with 3+ years as a tech lead owning end-to-end delivery (not a pure design/review architect role).
Proven track record of shipping data platforms on committed timelines, including hands-on troubleshooting under delivery pressure.
Deep expertise in relational and canonical data modeling and MDM design.
Expert-level SQL and solid understanding of when NoSQL patterns are appropriate.
Proven experience designing schema-first data contracts (JSON Schema/Avro/Protobuf).
Experience architecting data catalog tooling and PII classification/data regulation compliance (critical given financial-services context).
Strong hands-on architecture experience with Snowflake or an equivalent enterprise data warehouse.
Proven design of data pipelines between operational data stores and the warehouse.
Experience architecting change-data-capture and data validation/quality frameworks.
Demonstrated experience implementing "contract as code" — schema management via CI/CD, Git-based governance.
Solid knowledge of relevant AWS data services (e.g., RDS, Redshift, Glue, DMS, Lake Formation).
Financial-services or similarly regulated-industry data governance experience is strongly preferred.
Strong stakeholder communication; able to directly manage day-to-day delivery of an offshore team (standups, unblocking, sprint accountability).

Nice To Haves

Experience with specific data catalog tools (e.g., Collibra, Alation, AWS Glue Data Catalog).
Exposure to multiple warehouse platforms beyond Snowflake.
Experience building data-quality frameworks with tools like Great Expectations or dbt tests.
Relevant certifications (Snowflake SnowPro, AWS Data Analytics Specialty).

Responsibilities

Own delivery of relational and canonical data models and the organization's MDM strategy.
Set standards for advanced SQL usage and appropriate use of NoSQL patterns where relational modeling doesn't fit.
Define schema-first data contract design using JSON Schema/Avro/Protobuf.
Drive rollout of the data catalog and enforce PII classification and data-regulation compliance across pipelines.
Own delivery of the Snowflake/enterprise data warehouse and data pipelines between ODS and warehouse.
Drive delivery of data change detection (CDC) and the data validation/quality testing framework.
Own "contract as code" governance: data schema management via CI/CD and Git-based data governance.
Select and stand up appropriate AWS data services for the platform.
Run day-to-day delivery of the offshore team: sprint commitments, code/design review, real-time unblocking, and hands-on work on critical-path pipelines.
Report delivery status, risks, and blockers to engineering leadership.