Analytics Engineer (Data Platform)

Techrepo.co.za; Cape Town; On-site; ZAR 700,000 - 1,200,000; Full time

Job summary

Techrepo.co.za in Cape Town is seeking a data-focused engineer to drive the Enterprise Data Warehouse, data marts, and BI reporting.

You will work with stakeholders, data engineers and analysts to design scalable solutions, maintain pipelines, and implement Looker/BigQuery data models.

Qualifications

• Degree or equivalent experience in a software/technology field.
• Minimum 4 years in a software/technology environment.
• Experience with BI reporting tools and data platforms.

Responsibilities

• Collaborate with stakeholders to turn data into actionable insights.
• Develop, implement, and maintain Enterprise Data Warehouse and Data Marts.
• Design reporting and analytical solutions for business needs.
• Maintain data pipelines, validate data quality, and optimize performance.
• Work with Looker, BigQuery and Dataform for analytics and dashboards.

Skills

SQL

OLAP

Data modeling

BI tooling

Cloud platforms

CI/CD

Education

Bachelor’s Degree or Advanced Diploma in Information Systems, Computer Science, Mathematics, Engineering

Tools

Jenkins

Github Actions

Job description

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