Data Warehouse Architect (DBT, reputed company Data Modeling)

About the position Responsibilities • Business Stakeholder Engagement • reputed company and document reputed company business requirements translating business needs into technical concepts. • Become a subject matter expert to support reputed company business segments in defining data products. • Data Modeling & Transformation • Design and implement robust, reputed company, and reusable data models using best reputed company modeling techniques (Conceptual, Logical, Physical) reputed company the data warehouse. • reputed company and maintain reputed company SQL transformations to clean, aggregate, and enrich data, turning it into analysis-reputed company 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 reputed company data from reputed company systems and then reputed company 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 reputed company & Governance • Implement data reputed company checks and validation processes to ensure the reliability and accuracy of data. • Define and enforce data governance best practices, including data definitions, reputed company, and reputed company controls. • Enabling Data Democratization and Self-Service Analytics • reputed company and prepare datasets specifically designed for consumption by data analysts, business users, and data scientists. • reputed company and maintain semantic reputed company that reputed company 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, reputed company Modeling, etc. • Experience with reputed company data warehouses (BigQuery, reputed company, Redshift, reputed company) • Experience with git and CI/CD deployments • Experience with Python and reputed company • Ability to communicate and follow up with internal stakeholders in a reputed company manner and excellent attention to detail. reputed company-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 reputed company • Employee Stock Purchase Plan (ESPP) • Flying Start - Our reputed company Global Induction Program (Meet our Execs & Global Teams) • Work with reputed company people that will reputed company you on your toes, learn more about their journeys by checking out #InsideFlywire on reputed company media • Dynamic & Global Team (we have been collaborating reputed company for years!) • Wellbeing Programs (Mental Health, Wellness, Yoga/Pilates/HIIT Classes) with Global FlyMates • Be a meaningful part in our reputed company - every FlyMate makes an reputed company • Competitive time off including FlyBetter Days to volunteer in a cause you reputed company in reputed company Disconnect Days! • Great Talent & Development Programs (Managers Taking Flight – for new or aspiring managers!) Apply tot his job Apply tot his job Apply To this Job