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
2 days ago
Job type
  • Full-time
Job description

Company Description

Are you ready to trade your job for a journey? Become a FlyMate!

Passion, excitement & global collaboration are all core to what it means to be a FlyMate. At Flywire, we're on a mission to deliver the world's most important and complex payments. We use our Flywire Advantage - the combination of our next-gen payments platform, proprietary payment network and vertical specific software, to help our clients get paid, and help their customers pay with ease - no matter where they are in the world.

What more do we need to truly be unstoppable? Perhaps, that is you!

Who we are :

Flywire is a global payments enablement and software company, founded more than a decade ago to solve high-stakes, high-value payments in higher education. We've since scaled into new regions and industry verticals and expanded our product offerings to deliver meaningful value to our clients around the world.

Today we support more than 4,600 clients across the global education, healthcare, travel & B2B industries, with diverse payment methods across 240 countries & territories and more than 140 currencies.

With over 1,200 global FlyMates, representing more than 40 nationalities, and in 12 offices world-wide, we're looking for FlyMates to join the next stage of our journey as we continue to grow.

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

    Here's What We're Looking For :

  • 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
  • Additional Information

    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

    Create a job alert for this search

    Enterprise Architect • Boston, MA, United States

    Related jobs
    Data Architect

    Data Architect

    Profitero • Boston, MA, US
    Full-time
    Boston (3 days a week in the Boston office at 40 Water Street).We are seeking a highly skilled and experienced.This role is critical in shaping the future of our enterprise data landscape, focusing...Show more
    Last updated: 30+ days ago • Promoted
    Data Architect

    Data Architect

    Akaasa Technologies • Lincoln, RI, United States
    Full-time
    Quick Apply
    Top Skills : • Snowflake • Data Architecture • Medallion / Data Lake architecture • AWS <...Show more
    Last updated: 2 days ago
    Big data Architect / Practice Architect - Boston, MA / Phoenix, AZ

    Big data Architect / Practice Architect - Boston, MA / Phoenix, AZ

    Staffing LLC • Boston, MA, United States
    Full-time
    Job Title : Big Data Architect / Practice Architect.Location : Boston, MA / Phoenix, AZ.Visa Status : GC / USC / TN / L2-EAD / GC-EAD / (H1B Transfer Will Work for Phoenix, AZ) Job Description : .Job ID and oth...Show more
    Last updated: 2 days ago • Promoted
    Data Architect – HR Data & Analytics

    Data Architect – HR Data & Analytics

    Invovia • Boston, MA, United States
    Full-time
    The Data Architect will play a key role in designing and implementing the enterprise HR data architecture to support KKR’s global HR analytics, KPIs, and reporting initiatives.This role involves tr...Show more
    Last updated: 3 days ago • Promoted
    Sr Data Engineering Architect, Manager

    Sr Data Engineering Architect, Manager

    Avanade • Boston, MA, United States
    Full-time
    Sr Data Engineering Architect, Manager.Our Data & AI team focuses on helping clients transform their business with the latest AI and data technologies. This role involves leading solution architectu...Show more
    Last updated: 2 days ago • Promoted
    Scientific Data Architect - Boston

    Scientific Data Architect - Boston

    TetraScience • Boston, MA, US
    Full-time
    TetraScience is the Scientific Data and AI company.We are catalyzing the Scientific AI revolution by designing and industrializing AI-native scientific data sets, which we bring to life in a growin...Show more
    Last updated: 30+ days ago • Promoted
    Data Architect

    Data Architect

    Connvertex Technologies Inc. • Lincoln, RI, United States
    Full-time
    Quick Apply
    Client Name : Kforce End Client Name : Athletic retail brand Job Title : Data Architect ...Show more
    Last updated: 2 days ago
    Data Architect

    Data Architect

    Novocure Inc • Boston, MA, United States
    Full-time
    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 role in aligni...Show more
    Last updated: 27 days ago • Promoted
    Data Architect

    Data Architect

    CLPS Global • Boston, MA, United States
    Full-time
    We are looking for a Data Architect to support our team in Boston, MA.This role offers the opportunity to work on meaningful projects, collaborate with talented colleagues, and contribute to the su...Show more
    Last updated: 3 days ago • Promoted
    DW Architect / Developer - MSFT - OnPrem and Azure Data Warehouse / Fabric

    DW Architect / Developer - MSFT - OnPrem and Azure Data Warehouse / Fabric

    UniFirst • Wilmington, MA, United States
    Full-time
    DW Architect / Developer - MSFT - OnPrem and Azure Data Warehouse / Fabric.This is a hybrid role with 50% on-site requirement in Wilmington, MA. We are seeking a highly skilled.DW Architect / Develope...Show more
    Last updated: 30+ 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
    M-78-Data Architect 144227.

    M-78-Data Architect 144227.

    FHR • Boston, 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

    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: 12 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
    Technical Architect - Databricks

    Technical Architect - Databricks

    Galent • Boston, MA, United States
    Full-time
    Technical Architect - Databricks.We have an immediate opening for a Technical Architect - Databricks with a leading IT Service Consulting company in Massachusetts. Hybrid in Boston, MA (2-3 days per...Show more
    Last updated: 11 days ago • Promoted
    Data Architect

    Data Architect

    Info Way Solutions • Boston, MA, United States
    Full-time
    Information Technology Technical Recruiter at Info way Solutions.Design and implement ingestion and transformation pipelines (DataStage / Snowflake / SQL Server / Aurora / MySQL), and build Java / Python‑bac...Show more
    Last updated: 5 days ago • Promoted
    Data Architect

    Data Architect

    Expert Technology Services • Lincoln, RI, United States
    Full-time
    Quick Apply
    Please Note : As of July 22, 2021, our team will require that all candidate submissions include a LinkedIn profile.Please do not submit any candidates that do not have a LinkedIn.KFORCE URGENT REQUI...Show more
    Last updated: 2 days ago
    Data Architect HR Data & Analytics

    Data Architect HR Data & Analytics

    Info Dinamica Inc • Boston, MA, United States
    Full-time
    Data Architect HR Data & Analytics.The Data Architect will play a key role in designing and implementing the enterprise HR data architecture to support KKR’s global HR analytics, KPIs, and reportin...Show more
    Last updated: 12 days ago • Promoted