Principal Data Platform Engineer [Hybrid]
EDF power solutions6 days ago
San Diego, CA, USAStaff+
Base Salary
$121k - $201k/yr
Responsibilities
- Design and implement cloud-native data integrations using APIs and AWS services including S3, Glue, and Lambda to load data into Snowflake.
- Build and maintain dbt transformation models, dimensional models, data marts, and business logic.
- Manage Snowflake platform infrastructure, including environment setup, performance optimization, cost management, security configuration, and access controls.
- Lead cross-functional collaboration with business stakeholders, product management, analytics, governance, architecture, and data engineering teams.
- Implement data quality testing, monitoring, alerting, validation, lineage, metadata management, and data classification practices.
- Translate data architecture and business requirements into scalable production-grade solutions and communicate progress, risks, and trade-offs to leadership.
- Optimize data models for visualization and reporting in partnership with Reporting Engineers.
- Conduct architecture and code reviews, drive technical incident root-cause analysis, and mentor junior engineers.
- Document data models, lineage, and technical architecture to support data governance initiatives.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related technical field.
- 8+ years of experience in data engineering or data platform roles delivering production-grade data platforms and leading technical teams.
- High proficiency with AWS cloud computing environments and associated data services, with deep experience in cloud data warehouses; Snowflake is strongly preferred.
- Expert-level Python and dbt experience for scripting, data processing, transformations, data modeling, and documentation.
- Mastery of SQL, including complex queries, optimization, database design, dimensional modeling, star schemas, and data warehouse design patterns.
- Advanced knowledge of change data capture, slowly changing dimensions, and incremental loading patterns.
- Proficiency with Git, modern CI/CD practices, and infrastructure as code tools such as Terraform, CDK, CloudFormation, or Ansible.
- Preferred experience with Airflow, Dagster, or Prefect; SAP S/4HANA, SAP HANA, or enterprise ERP environments; and Agile/Scrum frameworks.
- Ability to lead technical design discussions, defend architecture proposals, communicate with technical and non-technical stakeholders, and mentor engineers.
Benefits
- Annual bonus program eligibility.
- Low-cost health and wellness coverage for employees and eligible dependents.
- 401(k) plan with a generous matching contribution.
- Paid time off programs, including paid parental leave after one year of service.
- Learning, career development, and advancement opportunities.
- Mentorship and buddy programs.
- Hybrid schedule based in San Diego, CA, with three days per week in the office, typically Tuesday through Thursday.
- The role includes occasional vendor or internal customer site visits and conferences or meetings.