The Opportunity:
We are seeking a Lead Analytics Engineer 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.
- Strong ability to understand business concepts and needs and translate into technical designs and solutions
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 :
Heres What Were Looking For:
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
Experience with dbt-Elementary dbt-Osmosis or Great Expectations is preferred
Experience in developing metadata-driven data quality and business rule frameworks
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
- Employee 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 media
- Dynamic & Global Team (we have been collaborating virtually for years!)
- Wellbeing Programs (Mental Health Wellness Yoga/Pilates/HIIT Classes) with Global FlyMates
- Competitive time off including FlyBetter Days to volunteer in your community 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 different FlyMates including the Hiring Manager and other Flymates. Your Talent Acquisition Partner will walk you through the steps and be your go-to person for 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 were excited to watch our unique culture evolve with each new hire.
The US base salary range for this full-time position is $170000-$200000 plus benefits. Our salary ranges are determined by role position level and location. The range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range individual pay is determined by work location and several other factors including job-related skills experience relevant education and training.
#LI-Hybrid
Remote Work :
No
Employment Type :
Full-time
The Opportunity:We are seeking a Lead Analytics Engineer 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 Opportunity:
We are seeking a Lead Analytics Engineer 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.
- Strong ability to understand business concepts and needs and translate into technical designs and solutions
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 :
Heres What Were Looking For:
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
Experience with dbt-Elementary dbt-Osmosis or Great Expectations is preferred
Experience in developing metadata-driven data quality and business rule frameworks
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
- Employee 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 media
- Dynamic & Global Team (we have been collaborating virtually for years!)
- Wellbeing Programs (Mental Health Wellness Yoga/Pilates/HIIT Classes) with Global FlyMates
- Competitive time off including FlyBetter Days to volunteer in your community 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 different FlyMates including the Hiring Manager and other Flymates. Your Talent Acquisition Partner will walk you through the steps and be your go-to person for 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 were excited to watch our unique culture evolve with each new hire.
The US base salary range for this full-time position is $170000-$200000 plus benefits. Our salary ranges are determined by role position level and location. The range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range individual pay is determined by work location and several other factors including job-related skills experience relevant education and training.
#LI-Hybrid
Remote Work :
No
Employment Type :
Full-time
View more
View less