Photon Logo

Photon

Lead Data Engineer | Onsite - Delaware

Posted 6 Days Ago
Be an Early Applicant
In-Office or Remote
Hiring Remotely in United States
56K-196K Annually
Senior level
In-Office or Remote
Hiring Remotely in United States
56K-196K Annually
Senior level
Lead delivery of enterprise data governance, MDM, and modern data-platform components including Snowflake, CDC pipelines, schema-first contracts (JSON Schema/Avro/Protobuf), data catalog and PII classification, CI/CD schema management, AWS data services, and day-to-day leadership of an offshore delivery team.
The summary above was generated by AI

Key Responsibilities 

  • Own delivery of relational and canonical data models and the organization's MDM (master data management) 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. 

Must-Have Qualifications 

  • 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-Have Qualifications 

  • 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). 

Compensation, Benefits and Duration

Minimum Compensation: USD 56,000
Maximum Compensation: USD 196,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full-time employees.
This position is not available for independent contractors
No applications will be considered if received more than 120 days after the date of this post

Similar Jobs

5 Days Ago
Remote or Hybrid
United States
190K-240K Annually
Senior level
190K-240K Annually
Senior level
Big Data • Cloud • Productivity • Software • Database • Analytics • Automation
As a Senior Data Engineer at Jellyfish, you'll build and maintain data pipelines, optimize orchestration, automate CI/CD processes, and enhance data integration while ensuring high performance and reliability.
Top Skills: AirflowBigQueryDagsterDatabricksDbtPrefectPysparkPythonRedisSnowflakeSQLTerraform
15 Days Ago
Remote
USA
170K-190K Annually
Senior level
170K-190K Annually
Senior level
Fintech • Payments • Financial Services
Lead Data Engineer responsible for defining architecture, engineering standards, and best practices for the enterprise data platform, collaborating with distributed teams for modernization and scalability.
Top Skills: AirflowAurora PostgresqlAWSKafkaRedshiftSQL Server
15 Days Ago
Remote
USA
Senior level
Senior level
Automotive • Healthtech • Financial Services
The Senior Data Engineer will design and build scalable data platforms, implement data pipelines, and improve data operations using Azure and various modern tools.
Top Skills: .Net Core.Net FrameworkAirflowAzure Cloud ServicesAzure Data Lake Storage Gen2Azure Devops PipelinesAzure SynapseC#CloudFormationDbtPower BIPythonSnowflakeSQLTerraform

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account