Role Overview:
Analytic Engineer with a Data Engineering background to help provision, structure, and lead our BI-focused sub-squad. This role sits at the intersection of data engineering, analytics, and business intelligence. You will design and implement data models, optimize data pipelines, and collaborate with BI developers to ensure that dashboards and self-service tools are backed by high-quality, well-structured data.
Key Responsibilities:
- Design and implement scalable data models to support BI and analytics.
- Develop and optimize Data pipelines using dbt or Dataform, Apache Airflow, Apache Spark, BigQuery, and SQL-based transformations.
- Collaborate with BI Developers to ensure dashboards are powered by performant datasets.
- Implement and maintain Data validation processes to improve pipeline accuracy.
- Implement Data governance policy across various projects.
- Work closely with Data Engineers to ensure data infrastructure efficiency.
- Mentor the Junior Analytic Engineer and provide technical leadership for the sub-squad.
Required Skills & Experience:
- Strong proficiency in SQL.
- Strong understanding of SQL and performance tuning.
- Experience in Python for data transformations.
- Hands-on experience with data pipeline tools (Airflow, Apache Spark) is a plus.
- Data modeling expertise using dbt, LookML, or dataform.
- Understanding of data validation frameworks (Great Expectations, BigQuery Validators).
- Knowledge of open table format such as Apache Iceberg would be advantage.
- Knowledge of GCP ecosystem will be advantageous.
Soft Skills:
- Strong project management and execution skills.
- Ability to translate business requirements into scalable data solutions.
- Excellent communication skills to collaborate across teams.
Preferred Qualifications:
- 3+ years of experience in data modeling, transformations, and analytics engineering.
- Prior experience in BI tool integrations (Looker, Power BI, Tableau).
