Senior Data Engineer

About the role

The company is expanding its data engineering capacity to keep pace with growth in its product portfolio and analytical demand. The Senior Data Engineer builds and maintains models, pipelines, and platform components that make company data trustworthy and usable, taking workstreams from investigation through design, implementation, and support.

Key responsibilities

• Design and build dimensional and analytical models in dbt on a cloud data warehouse across core domains and new business lines.
• Develop and maintain ingestion and orchestration pipelines using dbt Core, Snowflake SQL, and Python, ensuring reliable scheduled execution.
• Profile source data from transactional systems and third‑party integrations to determine grain, keys, and business meaning, documenting assumptions.
• Implement data quality tests, monitoring, and alerting to catch anomalies before they affect reports or customer‑facing outputs.
• Diagnose production data issues across ingestion, transformation, and source layers, documenting root causes for the team.
• Participate in design and code reviews with engineers across regions, providing and receiving substantive technical feedback.
• Partner with analysts and stakeholders to clarify requirements and validate results.

Required profile

• 5+ years in data engineering, including 3+ years building analytical models in a cloud data warehouse.
• Advanced SQL skills, preferably with Snowflake.
• Production experience with dbt, including model layering, testing, documentation, and incremental strategies.
• Proficiency in Python for pipeline development and orchestration with Airflow or equivalent.
• Ability to investigate undocumented source systems and map data to business processes.
• Familiarity with dimensional modeling and trade‑offs between normalized, wide, and aggregate structures.

Required skills

• dbt
• Snowflake
• SQL
• Python
• Airflow (or equivalent orchestration)
• Git and CI/CD pipelines
• Dimensional modeling
• BI tools (Tableau, Looker, Power BI, or similar)