Lead DBT Data Modeling Engineer

DBT SME - We’re seeking a Lead Analytics Engineer to help design, model, and scale a modern data environment for a global software organization. The company manages large volumes of data across multiple business units, and this role will play a key part in organizing and maturing that landscape as part of a multi-year strategic roadmap. Business Stakeholder Engagement • Gather and document complex business requirements. • Translate business needs into scalable, maintainable data products. • Serve as a trusted data partner across multiple departments. Data Modeling & Transformation • Design and implement robust, reusable data models within the warehouse. • Develop and maintain SQL transformations in dbt. • Optimize existing models and queries for performance, cost-efficiency, and maintainability. Qualifications • Bachelor’s degree in Economics, Mathematics, Computer Science, or related field. • 10+ years of experience in an Analytics Engineering role. • Expert in SQL and dbt with demonstrated modeling experience (Vault, 3NF, Dimensional). • Hands-on experience with BigQuery or other cloud data warehouses. • Proficiency in Python and Docker. • Experience with Airflow (Composer), Git, and CI/CD pipelines. • Strong attention to detail and communication skills; able to interact with both technical and business stakeholders. Technical Environment • Primary Data Warehouse: BigQuery • Nice to Have: Snowflake, Redshift • Orchestration: Airflow (GCP Composer) • Languages: Expert-level SQL / dbt; strong Python required • Other Tools: GCP or AWS, Fivetran, Apache Beam, Looker or Preset, Docker • Modeling Techniques: Vault 2.0, 3NF, Dimensional Modeling, etc. • Version Control: Git / CI-CD