Data Warehouse Architect (DBT, Enterprise Data Modeling)
About the position
Responsibilities
• Business Stakeholder Engagement
• Gather and document complex business requirements translating business needs into technical concepts. • Become a subject matter expert to support all business segments in defining data products. • Data Modeling & Transformation
• Design and implement robust, scalable, and reusable data models using best practice modeling techniques (Conceptual, Logical, Physical) within the data warehouse. • Develop and maintain complex SQL transformations to clean, aggregate, and enrich data, turning it into analysis-ready datasets leveraging dbt.
• Optimize existing data models and queries for performance, cost-efficiency, and maintainability. • Data Pipeline & Orchestration
• Build and maintain reliable data pipelines in collaboration with data engineering to move data from source systems and then transform it into curated datasets
• Utilize orchestration tools (e.g., Airflow) to schedule, monitor, and manage data transformation workflows. • Manage and support our dbt environment and workflows
• Data Quality & Governance
• Implement data quality checks and validation processes to ensure the reliability and accuracy of data.
• Define and enforce data governance best practices, including data definitions, lineage, and access controls. • Enabling Data Democratization and Self-Service Analytics
• Curate and prepare datasets specifically designed for consumption by data analysts, business users, and data scientists. • Develop and maintain semantic layers that provide a consistent and easy-to-understand view of key metrics and dimensions. Requirements
• Bachelor Degree in Economics, Mathematics, or Computer Science
• 10+ years of experience in an Analytics Engineering role
• Strong proficiency in SQL
• Strong proficiency with dbt
• Expert modeling skills: Vault 2.0, 3NF, Dimensional Modeling, etc.
• Experience with cloud data warehouses (BigQuery, Snowflake, Redshift, Databricks)
• Experience with git and CI/CD deployments
• Experience with Python and Docker
• Ability to communicate and follow up with internal stakeholders in a timely manner and excellent attention to detail. Nice-to-haves
• Experience with dbt-Elementary or Great Expectations is preferred
• Experience with dbt-Osmosis or Great Expectations is preferred
• Experience with BI Tools (Looker or Preset) is a plus
Benefits
• Competitive compensation, including Restricted Stock Units
• Employee Stock Purchase Plan (ESPP)
• Flying Start -
Our immersive Global Induction Program (Meet our Execs & Global Teams)
• Work with brilliant people that will keep you on your toes, learn more about their journeys by checking out #InsideFlywire on social media
• Dynamic & Global Team (we have been collaborating virtually for years!)
• Wellbeing Programs (Mental Health, Wellness, Yoga/Pilates/HIIT Classes) with Global FlyMates
• Be a meaningful part in our success - every FlyMate makes an impact
• Competitive time off including FlyBetter Days to volunteer in a cause you believe in and Digital Disconnect Days!
• Great Talent & Development Programs (Managers Taking Flight – for new or aspiring managers!)Apply Now
Apply Now
Responsibilities
• Business Stakeholder Engagement
• Gather and document complex business requirements translating business needs into technical concepts. • Become a subject matter expert to support all business segments in defining data products. • Data Modeling & Transformation
• Design and implement robust, scalable, and reusable data models using best practice modeling techniques (Conceptual, Logical, Physical) within the data warehouse. • Develop and maintain complex SQL transformations to clean, aggregate, and enrich data, turning it into analysis-ready datasets leveraging dbt.
• Optimize existing data models and queries for performance, cost-efficiency, and maintainability. • Data Pipeline & Orchestration
• Build and maintain reliable data pipelines in collaboration with data engineering to move data from source systems and then transform it into curated datasets
• Utilize orchestration tools (e.g., Airflow) to schedule, monitor, and manage data transformation workflows. • Manage and support our dbt environment and workflows
• Data Quality & Governance
• Implement data quality checks and validation processes to ensure the reliability and accuracy of data.
• Define and enforce data governance best practices, including data definitions, lineage, and access controls. • Enabling Data Democratization and Self-Service Analytics
• Curate and prepare datasets specifically designed for consumption by data analysts, business users, and data scientists. • Develop and maintain semantic layers that provide a consistent and easy-to-understand view of key metrics and dimensions. Requirements
• Bachelor Degree in Economics, Mathematics, or Computer Science
• 10+ years of experience in an Analytics Engineering role
• Strong proficiency in SQL
• Strong proficiency with dbt
• Expert modeling skills: Vault 2.0, 3NF, Dimensional Modeling, etc.
• Experience with cloud data warehouses (BigQuery, Snowflake, Redshift, Databricks)
• Experience with git and CI/CD deployments
• Experience with Python and Docker
• Ability to communicate and follow up with internal stakeholders in a timely manner and excellent attention to detail. Nice-to-haves
• Experience with dbt-Elementary or Great Expectations is preferred
• Experience with dbt-Osmosis or Great Expectations is preferred
• Experience with BI Tools (Looker or Preset) is a plus
Benefits
• Competitive compensation, including Restricted Stock Units
• Employee Stock Purchase Plan (ESPP)
• Flying Start -
Our immersive Global Induction Program (Meet our Execs & Global Teams)
• Work with brilliant people that will keep you on your toes, learn more about their journeys by checking out #InsideFlywire on social media
• Dynamic & Global Team (we have been collaborating virtually for years!)
• Wellbeing Programs (Mental Health, Wellness, Yoga/Pilates/HIIT Classes) with Global FlyMates
• Be a meaningful part in our success - every FlyMate makes an impact
• Competitive time off including FlyBetter Days to volunteer in a cause you believe in and Digital Disconnect Days!
• Great Talent & Development Programs (Managers Taking Flight – for new or aspiring managers!)Apply Now
Apply Now