Analytics Engineer (Data Platform)
Summary
Builds and maintains the company’s data warehouse, pipelines, and BI systems to extract insights for e-commerce decision-making, using BigQuery, Looker, and cloud infrastructure.
Job Description
About the Role
We are a young, dynamic, hyper growth company looking for smart, creative, hard-working people with integrity to join us!
Responsibilities
- This position reports to the Data Platform Engineering Manager
- Work closely with stakeholders, Data Engineers and BI Analysts to turn data into critical information and knowledge that can be used to make sound business decisions.
- Responsible for the full life-cycle development, implementation, production support, and performance tuning of the Enterprise Data Warehouse, Data Marts, and Business Intelligence Reporting environments.
- Design and implement reporting and analytical solutions.
- Analyses business and functional requirements and translates these requirements into robust, scalable, operable solutions.
- Help to maintain our Kappa & Lambda event-driven architecture built on BigQuery, DataForm and Looker.
- Ensuring that the data pipelines and general support infrastructure continue to run and operate in the most efficient manner.
- Provide operational support, bug fixes, and performance enhancements.
- Automating data extraction and report update processes.
- Data validation and integrity testing.
- Data cleansing and multidimensional data modeling.
- Optimisation of data models.
Requirements
- Solutions-oriented, can-do attitude and high energy
- Excellent problem-solving skills
- Proven track record of delivering high-quality work, in a fast-paced environment
- Focus on getting the job done, but have fun doing so
- Taking ownership and displaying accountability in the work required of you
- Have an interest in e-commerce, building a brand and business
- Customer-centric
- Bachelor’s Degree or Advanced Diploma in Information Systems, Computer Science, Mathematics, Engineering and a minimum of 3 years experience in a software/technology environment is required.
- In the event that a candidate does not have a Bachelor’s Degree or an Advanced Diploma (in Information Systems, Computer Science, Mathematics, or Engineering), an equivalent experience requirement must be met, which equates to a minimum of 6 years experience in a software/technology environment.
- 4 - 6 years related experience
- Minimum 2 years’ experience using a BI reporting tools (e.g. QlikView, Tableau, Microsoft Power BI, Looker, etc.)
- Minimum 4 years SQL experience
- A thorough understanding of computer science fundamentals, including object-oriented design, data structures and algorithms
- A solid understanding of computer science fundamentals, including Linux and operating systems, networking
- OLAP and multidimensional cube design experience
- Familiar with CI/CD tools such as Jenkins, Github Actions
- Have experience with Google Cloud, or another cloud provider (architecture, operations)
- High proficiency in working with large data sets and business models
Preferred Qualifications
- 1 - 2 years of coding experience in Python and JavaScript (advantageous)
- Experience using Looker, BigQuery and Dataform is advantageous
- Experience with Domain Driven Design (DDD) is advantageous
- Experience working in Scrum and Sprint Agile methodologies is advantageous
- Retail or e-commerce industry experience beneficial