Lead Analytics Engineer

Flywire is a global payments enablement and software company on a mission to deliver complex payments across various industries. They are seeking a Lead Analytics Engineer to bridge the gap between Data Engineering and Analytics, enabling end users to leverage data effectively while managing data pipelines, modeling, and ensuring data quality.

Responsibilities:

• 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
• Strong ability to understand business concepts and needs and translate into technical designs and solutions
• 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
• 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
• 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
• 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

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 and data modeling tools
• Expert modeling skills: Vault 2.0, 3NF, Dimensional Modeling, etc
• Advanced experience with cloud data warehouses (BigQuery, Snowflake, Redshift, or Databricks) and designing scalable models
• Experience with git and CI/CD deployments
• Ability to communicate and follow up with internal stakeholders in a timely manner and excellent attention to detail
• Experience with dbt-Elementary, dbt-Osmosis, or Great Expectations
• Experience in developing metadata-driven data quality and business rule frameworks
• Experience with BI Tools (Looker or Preset)