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 datasetsUtilize orchestration tools (e.g., Airflow) to schedule, monitor, and manage data transformation workflows.Manage and support our dbt environment and workflowsData 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 Science10+ years of experience in an Analytics Engineering roleStrong proficiency in SQLStrong proficiency with dbtExpert modeling skills : Vault 2.0, 3NF, Dimensional Modeling, etc.Experience with cloud data warehouses (BigQuery, Snowflake, Redshift, Databricks)Experience with git and CI / CD deploymentsExperience with Python and DockerExperience with dbt-Elementary or Great Expectations is preferredExperience with dbt-Osmosis or Great Expectations is preferredAbility 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 plusTechnologies We Use
GCP / AWSFivetran / Apache Beam ->BigQuery ->
dbt ->
Looker / Preset
Airflow (GCP Composer)Flink and Apache BeamWhat We Offer
Competitive compensation, including Restricted Stock UnitsEmployee 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 mediaDynamic & Global Team (we have been collaborating virtually for years!)Wellbeing Programs (Mental Health, Wellness, Yoga / Pilates / HIIT Classes) with Global FlyMatesBe a meaningful part in our success - every FlyMate makes an impactCompetitive 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