Senior Analytics Engineer

closed
Flywire Logo

Flywire

πŸ“Remote - Spain

Summary

Join Flywire as a Sr. Analytics Engineer and bridge the gap between Data Engineering and Analytics. You will gather and document complex business requirements, translating business needs into technical concepts and becoming a subject matter expert. Responsibilities include designing and implementing data models, developing SQL transformations, building data pipelines, implementing data quality checks, and enabling self-service analytics. You will work with various technologies including cloud data warehouses, dbt, Airflow, and BI tools. Flywire offers competitive compensation, stock options, a global induction program, wellbeing programs, and talent development opportunities.

Requirements

  • 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
  • Ability to communicate and follow up with internal stakeholders in a timely manner and excellent attention to detail

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

Preferred Qualifications

  • Experience with dbt-Elementary or Great Expectations is preferred
  • Experience with dbt-Osmosis or Great Expectations is preferred
  • Experience with BI Tools (Looker or Preset) is a plus

Benefits

  • Competitive compensation, including Restricted Stock Units
  • Employee Stock Purchase Plan (ESPP)
  • Flying Start - Our immersive Global Induction Program (Meet our Execs & Global Teams)
  • Wellbeing Programs (Mental Health, Wellness, Yoga/Pilates/HIIT Classes) with Global FlyMates
  • 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!)
This job is filled or no longer available

Similar Remote Jobs