Lead Analytics Engineer

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 Lead 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 EngagementGather 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 & TransformationDesign 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 & OrchestrationBuild 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 & GovernanceImplement 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 AnalyticsCurate 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.