Talent.com
Data Warehouse Architect (DBT, Enterprise Data Modeling)
Data Warehouse Architect (DBT, Enterprise Data Modeling)Flywire • Boston, MA, United States
Data Warehouse Architect (DBT, Enterprise Data Modeling)

Data Warehouse Architect (DBT, Enterprise Data Modeling)

Flywire • Boston, MA, United States
7 days ago
Job type
  • Full-time
Job description

Overview

Job Description

The Opportunity :

We, at Flywire, are seeking a Data Warehouse Architect to join our Data Analytics team and further scale our data driven company.

In this role, you will bridge the gap between Data Engineering and Analytics to enable our end users to make the most of our data. You will handle data from all areas of the company and modeling that data using data modeling techniques, and succeed through the following 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.
  • Qualifications

  • 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
  • Experience with dbt-Elementary or Great Expectations is preferred
  • Experience with dbt-Osmosis or Great Expectations is preferred
  • Ability to communicate and follow up with internal stakeholders in a timely manner and excellent attention to detail.
  • Experience with BI Tools (Looker or Preset) is a plus
  • Technologies We Use

  • GCP / AWS
  • Fivetran / Apache Beam ->
  • BigQuery ->

    dbt ->

    Looker / Preset

  • Airflow (GCP Composer)
  • Flink and Apache Beam
  • What We Offer

  • 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!)
  • Submit today and get started!

    We are excited to get to know you! Throughout our process you can expect to meet with different FlyMates including the Hiring Manager, Peers on the team, the VP of the department, and a skills assessment. Your Talent Acquisition Partner will walk you through the steps and be your “go-to” person for any questions.

    Flywire is an equal opportunity employer. With over 40 nationalities across 12 different offices, and diversity and inclusion at the core of our people agenda, we believe our FlyMates are our greatest asset, and we’re excited to watch our unique culture evolve with each new hire.

    #LI-Hybrid

    #J-18808-Ljbffr

    Create a job alert for this search

    Enterprise Architect • Boston, MA, United States

    Related jobs
    VP Data Solutions Architect - Alpha Platform Lead

    VP Data Solutions Architect - Alpha Platform Lead

    State Street • Burlington, MA, United States
    Full-time
    A leading financial services company in Burlington seeks a Data Solutions Architect to lead client implementations and provide thought leadership throughout the data solutions process.The ideal can...Show more
    Last updated: 1 day ago • Promoted
    Enterprise Data Architect

    Enterprise Data Architect

    Constant Contact • Boston, MA, United States
    Full-time
    At Constant Contact, we are seriously awesome people who take ownership and make an impact by operating with the mindset, integrity and courage of a small business owner. There’s something so profou...Show more
    Last updated: 19 days ago • Promoted
    M-78-Data Architect 144227.

    M-78-Data Architect 144227.

    FHR • Cambridge, MA, US
    Temporary
    Data Architect (Job ID : 144227).Location : Hybrid – Augusta, ME (Onsite once per month; candidates in New England preferred). Travel : Client does not cover travel expensesOur direct client in A...Show more
    Last updated: 30+ days ago • Promoted
    Data Architect

    Data Architect

    Clarus Technology • Boston, MA, United States
    Full-time
    Clarus is a pioneering pet health technology company on a mission to transform the future of pet healthcare.We are dynamic entrepreneurs improving pet health by providing trusted and transparent in...Show more
    Last updated: 4 days ago • Promoted
    Sr Data Architect - Boston, MA

    Sr Data Architect - Boston, MA

    TechniPros • Boston, MA, United States
    Temporary
    Quick Apply
    Role : Sr Data Architect Location : Boston, MA Hybrid Domain : Investments Long term contract Looking for W2 Candidates only.No C2C < / p...Show more
    Last updated: 3 days ago
    Data Warehouse Architect : dbt & Enterprise Modeling

    Data Warehouse Architect : dbt & Enterprise Modeling

    Flywire • Boston, MA, United States
    Full-time
    A global payments software company located in Boston is seeking an experienced Data Warehouse Architect to join their Data Analytics team. The ideal candidate will bridge the gap between Data Engine...Show more
    Last updated: 3 days ago • Promoted
    Data Architect - Snowflake / Epic Integration

    Data Architect - Snowflake / Epic Integration

    Compunnel, Inc. • Boston, MA, United States
    Full-time
    Data Architect - Snowflake / Epic Integration.The client has recently migrated their on-premises data infrastructure to Snowflake and is facing strain across legacy and new systems, particularly in...Show more
    Last updated: 5 days ago • Promoted
    Data Architect

    Data Architect

    Fynetra • Boston, MA, United States
    Full-time
    Ready to transform data infrastructure in a fast-paced, evolving environment? This role offers the chance to design and implement modern data solutions using cutting-edge technology.Partnering with...Show more
    Last updated: 30+ days ago • Promoted
    Data Platform Architect (hybrid)

    Data Platform Architect (hybrid)

    Johnson Controls • Westford, Massachusetts, USA
    Full-time
    At Johnson Controls we transform the environments where people live work learn and play.From optimizing building performance to improving safety and enhancing comfort we drive the outcomes that mat...Show more
    Last updated: 3 hours ago • Promoted • New!
    Director I, IT Data Enterprise Architecture

    Director I, IT Data Enterprise Architecture

    Peapod Digital Labs • Quincy, MA, United States
    Full-time
    USA-MA-Quincy-1385 Hancock Street.Data Functional Architecture (5158793).Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U. Food Lion, Giant Food, The GIANT Com...Show more
    Last updated: 11 hours ago • Promoted • New!
    Data Architect

    Data Architect

    Quantiphi • Boston, MA, United States
    Full-time
    AI-First Digital Engineering Company, Seeking Top Talent in North America in Technical and Sales Roles.About Quantiphi : Quantiphi is an award-winning Applied AI and Big Data software and services c...Show more
    Last updated: 30+ days ago • Promoted
    AI-Enabled Solution Architect - Data Modernization, GenAI & Business Impact

    AI-Enabled Solution Architect - Data Modernization, GenAI & Business Impact

    Cervello Inc • Boston, MA, US
    Full-time
    Position : AI-Enabled Solution Architect – Data Modernization, GenAI & Business Impact .AI-native data and analytics solutions. This role is central to our transformation team as we em...Show more
    Last updated: 30+ days ago • Promoted
    AI-Enabled Solution Architect – Data Modernization, GenAI & Business Impact

    AI-Enabled Solution Architect – Data Modernization, GenAI & Business Impact

    Cervello Inc • Boston, MA, US
    Full-time
    Quick Apply
    AI-Enabled Solution Architect – Data Modernization, GenAI & Business Impact We are seeking a visionary AI-Enabled Solution Architect to help lead the regional design and delivery of...Show more
    Last updated: 30+ days ago
    Data Architect

    Data Architect

    Suffolk Construction • Boston, MA, United States
    Full-time
    Suffolk is a national enterprise that builds, innovates and invests.Suffolk is an end‑to‑end business that provides value throughout the entire project lifecycle by leveraging its core construction...Show more
    Last updated: 16 days ago • Promoted
    Enterprise Data Architect (Boston)

    Enterprise Data Architect (Boston)

    Applegreen (US) Welcome Centers • Boston, MA, United States
    Full-time
    We are seeking an experienced and strategic.In this role, you will be responsible for designing, implementing, and maintaining our enterprise data architecture to support business objectives, ensur...Show more
    Last updated: 10 days ago • Promoted
    Azure Data Architect

    Azure Data Architect

    Trinity Technology Solutions LLC • Boston, MA, United States
    Full-time +1
    Technical Recruiter at Trinity IT Solution.In this role, you will be the Lead on designing, implementing, and managing data architecture and cloud-based solutions with Microsoft Azure.Developing an...Show more
    Last updated: 4 days ago • Promoted
    Data Architect

    Data Architect

    Novocure Inc • Boston, MA, United States
    Full-time
    JOB SUMMARY : We are seeking an experienced and innovative Data Architect to lead the design, development, and optimization of our enterprise data architecture. This individual will play a critical r...Show more
    Last updated: 30+ days ago • Promoted
    Data Architect

    Data Architect

    Human Agency • Boston, MA, United States
    Full-time
    We're scaling rapidly and have a growing pipeline of opportunities that demand exceptional talent across disciplines.Our mission is to bring on individuals, from creative producers to technical exp...Show more
    Last updated: 17 days ago • Promoted