Senior Analytics Engineer at Impact

Your Role

We’re looking for an experienced Senior Analytics Engineer to play a pivotal role in establishing a robust data analytics competency at Impact. As our business expands, we increasingly rely on sophisticated data products and insights to drive data-driven decision-making.

In this role, you'll take the lead in designing and implementing efficient data workflows to move, transform, aggregate, and enrich data from various sources into a centralised data warehouse and data marts. You will work closely with data analysts, data scientists, and other stakeholders to ensure the seamless integration and optimization of our data infrastructure. Our ideal candidate will have a strong technical background in data engineering, a deep understanding of data analytics, and the ability to effectively collaborate across teams to deliver impactful solutions.

What You'll Do:

• Design and maintain scalable data models that meet business requirements, ensuring best practices in schema design. Collaborate with analysts, and stakeholders to translate data needs into effective models.
• Write, optimise, and maintain complex SQL queries to support data transformation and analysis. Ensure the performance and scalability of SQL code and conduct code reviews to maintain best practices.
• Implement and manage dbt projects, developing and maintaining models, tests, and documentation to ensure data accuracy and consistency. Continuously improve dbt workflows to enhance efficiency.
• Establish and enforce data quality standards and governance policies. Monitor data pipelines for accuracy and completeness, and implement validation procedures to resolve data issues.
• Collaborate effectively with cross-functional teams, communicating technical concepts clearly to non-technical stakeholders. Provide mentorship to junior team members, fostering continuous learning and improvement.
• Identify and address performance bottlenecks in data processing and querying. Implement optimization techniques to enhance database performance, and continuously monitor and tune operations for efficiency.

What You Have:

• Proven experience in developing enterprise-level data marts to drive business reporting and analytics
• Expertise in relational database management systems, data modelling, and schema design
• Strong SQL development and Python programming skills
• Excellent analytical, problem-solving, written, and verbal communication skills
• 5+ years of experience in data pipeline development and data warehousing with big data technologies (e.g. Apache Spark, Google DataFlow, SingleStore, Impala, Kudu, BigQuery)
• Knowledge of data integration patterns, data load patterns, and software development best practices
• Proficient in version control tools
• Familiarity our tech stack: Databricks, dbt, Google Cloud Platform, and BigQuery is advantageous
• Experience with workflow management tools (e.g., Airflow, Luigi, Oozie) is beneficial
• Bachelor's or Master's degree in Computer Science, Data Science, or related field is advantageous
• Ability to collaborate effectively in a team environment with internal stakeholders is a must
• Good leadership and workload management skills are advantageous