Senior Analytics Engineer

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, delivering high-stakes, high-value payments across the global education, healthcare, travel and B2B industries.

Today, we’ve digitized payments for more than 4,500+ global clients in more than 140 currencies across 240 countries and territories around the world.  And, we’re just getting started!

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 an Analytics Engineer to join our Data Analytics team and further scale our data driven company.

As a Sr. Analytics Engineer, 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
• 5+ years of experience in an Analytics Engineering role
• Strong proficiency in SQL
• Strong proficiency with dbt
• Strong in with Modeling techniques: 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 wil