Senior Analytics Engineer

Sep 14, 2023

Cape Town

Our Company:

If you are looking to join a team where your opinion is valued, your contributions are noticed, and enjoy working with fun and talented people from all over the world then this is the place for you.

If you have a desire to work in an organisation that is:

  • Passionate about its people
  • Focused on delivering the very best tech to our customers
  • Offering the flexibility to work how and where you are most successful
  • Obsessed with our customer’s success
  • The leading SaaS platform to automate partnerships - affiliate, influencer, technology partners, and more!
  • Entrepreneurial in spirit with a culture that rewards collaboration and curiosity
  • Obsessed with making a difference in business and to the wider community


Impact is the global leader in Partnership Automation, working with innovative brands like Ticketmaster, Levi’s, Microsoft, Airbnb, and Uber to help them manage their online affiliate, influencer, brand to brand, and content partnerships. The Impact Partnership Cloud covers the full life partnership lifecycle including onboarding, tracking ads and paying partners, recruiting for new partners, data and marketing intelligence, and protection from fraud. Founded in 2008, Impact has grown to over 500 employees and ten offices across Europe, the United States, Africa, and Asia so there is plenty of opportunity for growth and advancement.

Your Role at Impact:

The Senior Analytics Engineer is a technical data professional; able to manage, process and analyse large datasets using big data technologies such as Apache Spark, SingleStore and BigQuery as well as being able to visualise and report on these datasets. The ideal candidate will be proficient in designing and implementing efficient data workflows to move, transform, aggregate and enrich data from various sources into a centralised data warehouse and purpose-built data marts, ensuring internal code management and data quality standards are adhered to, in addition to providing users access to standard reports, rich visualisations and other analytical data assets.

The position requires a strong analytical mindset, attention to detail, programming skills and experience with big data technologies. This is a highly collaborative role as the engineer needs to engage with Subject Matter Experts to implement business logic, understand source data structures and ensure data outputs are accurate, fit-for-purpose, pass quality assurance and provide value to the business.

What You'll Do:

  • Design, develop and maintain data models, data marts and analytical data stores
  • Work closely with Subject Matter Experts (SMEs), Business and Technical stakeholders to define and document business logic and transformation rules to be used in data load jobs and (materialised) analytical views
  • Build and maintain data load and transformation jobs to populate data lakes, data marts and data warehouses following the Extract-Load-Transform (ELT) and Extract-Transform-Load (ETL) paradigms as appropriate
  • Create and maintain reusable data assets ready for consumption by machine learning models, data visualisation tools and data analysts
  • Create and maintain entity-relationship diagrams (ERDs), data dictionaries and data flow diagrams
  • Create and maintain table and column metadata
  • Manage code releases, deployment cycles and the associated change management processes
  • Build and maintain standard reports for internal stakeholders
  • Contribute to the development and expansion of common utility libraries used by data teams
  • Maintain high standards of quality, integrity and accuracy in produced data assets
  • Troubleshoot and resolve any issues that arise relating to data assets in the production environment in a timely manner
  • Optimise total system performance related to ETL/ELT workloads and analytical queries, ensuring efficient use of compute resources and stability of data systems
  • Optimise code related to ELT/ETL workloads for simplicity, reusability and efficiency and in line with best practice
  • Conduct periodic integrity checks on productionalized data assets
  • Safeguard sensitive company data
  • Work with the data Quality Assurance (QA) function to extend and enhance programmatic validation of productionalized data assets
  • Stay up-to-date with the latest big data technologies and best practices
  • Automate manual data load, data transformation and data management processes
  • Review and Sign off code changes
  • Mentor and train junior colleagues
  • Actively participate in the hiring process and performance management of team members

What You Have:

  • Bachelor's or Master's degree in Computer Science, Data Science or related field
  • 6+ years of experience in data pipeline development and data warehousing using big data technologies such as Apache Spark, Google DataFlow, SingleStore, Impala, Kudu and/or BigQuery
  • Proven track record in developing enterprise-level data marts
  • Experience with Databricks advantageous
  • Experience with dbt advantageous
  • Experience with Google Cloud Platform and BigQuery advantageous
  • Strong SQL development experience required
  • Strong Python programming skills required
  • Strong knowledge of relational database management systems
  • Strong data modelling and schema design experience
  • Experience with workflow management tools such as Airflow, Luigi or Oozie advantageous
  • Knowledge of data integration patterns, data load patterns and best practices required
  • Knowledge of software development best practices and version control tools
  • Strong analytical and problem-solving skills
  • Strong written and verbal communication skills
  • Good leadership and workload management skills and experience advantageous
  • Ability to work in a team environment and collaborate with internal stakeholders


  • Unlimited PTO policy

  • Take the time off that you need. We are truly committed to a positive work-life balance, recognising that it is important to be happy and fulfilled in both

  • Training & Development

  • Learning the advanced partnership automation products

  • Medical Aid and Provident Fund 

  • Group schemes with Discovery & Bonitas for medical aid

  • Group scheme with Momentum for provident fund

  • Stock Options

  • 4-year vesting schedule pending Board approval

  • Internet Allowance

  • Flexible work hours

  • Casual work environment


All employees and applicants for employment shall be given fair treatment and equal employment opportunity regardless of their race, ethnicity or ancestry, color or caste, religion or belief, age, sex (including gender identity, gender reassignment, sexual orientation, pregnancy/maternity), national origin, weight, neurodivergence, disability, marital and civil partnership status, caregiving status, veteran status, genetic information, political affiliation, or other prohibited non-merit factors.


Join 27177+ Machine Learning Engineers, receiving daily job alerts.