Wave is a company dedicated to making Africa the first cashless continent by providing accessible financial services. As a Senior Analytics Engineer, you will focus on structuring and optimizing data to enhance product offerings for millions of users across multiple countries.
Responsibilities:
- Leading dimensional design to structure Wave’s analytics data in ways that are helpful for human and AI end users
- Building out facts, dimensions and One Big Tables (OBTs) as appropriate for a focus area at Wave
- Standardizing metric creation and usage
- Building out ways to make it easy to add context for LLMs to data models
- Managing our extensive snowflake estate with a strong analytical mindset
- Finding patterns that are repeated frequently and optimizing them
- Building tools to identify and turn off stale/unused models
- Evaluating the impact of an optimization on costs and performance
- Building tools to improve the analytics development experience
- Creating helpful dbt macros
- CI/CD checks that catch possibly exploding joins
- Reducing the pain of iterating on metric design
- Be responsible for the design, build and health of all of our ETL pipelines
- Champion best practice across data
- Be a key partner in the road map of the data platform team
Requirements:
- 5+ years as an analytics or data engineer. Software engineering experience that's focused on data platforms also counts
- 3+ years of involved experience with Snowflake. This should ideally include experience with performance optimization
- Experience with dimensional modeling. Ideally you would have built two or more dimensional marts
- Strong python, sql and dbt experience
- Familiarity with managing an orchestration platform like dagster or airflow
- Are proficient in SQL and Python
- Are a self-starter that excels at exploring problems and collaborating closely with operations teams to drive growth through data
- Have excellent focus, prioritizing your research and work using an iterative approach (you know when a project is good enough to stop, and you rarely get lost in details)
- Are able to compellingly present your findings to technical and non-technical audiences and make proactive recommendations based on data
- You excel at choosing the right complexity of analysis for any given business problem, from simple SQL queries to complex experimentation