Job Description:
Sr. Analytics Engineer – (Data Modeling, Data Engineering/Transformation, GCP, BigQuery, DBT)
We are searching for an experienced Analytics Engineer to help construct a contextualized view of our data. These data assets will be used across business & data analytics teams and will become the core repository for their data needs. As an Analytics Engineer, you will sit at the intersection of these groups and will be responsible for delivering trusted, robust and valuable data assets. In addition you will maintain and incorporate changes over time as the business needs change. We are looking for an individual who cares about organizing data into reusable and maintainable components and can bring their energy to helping us grow this function.
The day to day:
- Work closely with business stakeholders in Product, Sales, Marketing, Finance & Customer Experience to design valuable data models
- Develop, deliver and maintain dbt code to advance our Unified Analytics Model as the trusted source for valuable data
- Create and maintain system, data and architectural documentation related to data assets (ERDs) maintained by Analytics Engineering
- Be an advocate for maintaining high quality and highly maintainable data assets through best practices and standards
- Lead and challenge other team members to be better at their craft. Drive improvements in code quality and development across the team
- Review code contributions to the Unified Analytics Model, educating on best practices and hygiene that lead to healthy data models
- Identify & develop process improvements that result in an improved Analytics Engineering practice
- Write test cases that ensure continued high-quality data is surfaced and protected from changes
- Manage & improve our CI/CD practice to automate the delivery of high quality code
- Be the outward face of the team to drive best practice and collaboration with other data
- teams
Your skills and expertise:
- Genuine passion about technology and solving problems with new tools & techniques
- Can challenge the status quo and be forward thinking towards building for the future
- Have an advanced understanding of how to organize & normalize data (data modeling) through data build tool (dbt)
- Automation mindset through testing & tooling resulting in high confidence delivery
- Advanced SQL skills - clean, readable, high quality code
- Advanced SQL debugging skills and query performance optimisation
- Advanced experience working with git
- Experience working with one of the major cloud data warehouses (GCloud, Azure, AWS)
- BigQuery preferrable
- Experience working within an Agile team, delivering iterative value every sprint
- Ability to work effectively with a remote team across multiple time zones
- Driven and self motivated with excellent organizational skills
- Excellent communication skills, both written and verbal
- Ability to understand, document and convert business requirements into data models
- Previous experience in an engineering focused role
- Mentorship of junior developers in all areas to develop a stronger team
- 8+ years software engineering experience
- 2+ years working on delivering data assets
- 1+ year working with dbt is beneficial