Senior Analytics Engineer
Cape Town
Our Company:
At impact.com we are passionate about our people, our technology, and are obsessed with customer success. Working together enables us to grow rapidly, win, and serve the largest brands in the world. We use cutting edge technology to solve real-world problems for our clients and continue to pull ahead of the pack as the leading SaaS platform for businesses to automate their partnerships and grow their revenue like never before. We have an entrepreneurial spirit and a culture where ambition and curiosity is rewarded. 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!
impact.com, the world’s leading partnership management platform, is transforming the way businesses manage and optimize all types of partnerships—including traditional rewards affiliates, influencers, commerce content publishers, B2B, and more. The company’s powerful, purpose-built platform makes it easy for businesses to create, manage, and scale an ecosystem of partnerships with the brands and communities that customers trust to make purchases, get information, and entertain themselves at home, at work, or on the go. To learn more about how impact.com’s technology platform and partnerships marketplace is driving revenue growth for global enterprise brands such as Walmart, Uber, Shopify, Lenovo, L’Oreal, Fanatics and Levi’s, visit www.impact.com.
Your Role at impact.com:
We’re looking for an experienced Senior Analytics Engineer to play a pivotal role in establishing a robust data analytics competency at Impact. As our business expands, we increasingly rely on sophisticated data products and insights to drive data-driven decision-making.
In this role, you'll take the lead in designing and implementing efficient data workflows to move, transform, aggregate, and enrich data from various sources into a centralised data warehouse and data marts. You will work closely with data analysts, data scientists, and other stakeholders to ensure the seamless integration and optimization of our data infrastructure. Our ideal candidate will have a strong technical background in data engineering, a deep understanding of data analytics, and the ability to effectively collaborate across teams to deliver impactful solutions.
What You'll Do:
- Design and maintain scalable data models that meet business requirements, ensuring best practices in schema design. Collaborate with analysts, and stakeholders to translate data needs into effective models.
- Write, optimise, and maintain complex SQL queries to support data transformation and analysis. Ensure the performance and scalability of SQL code and conduct code reviews to maintain best practices.
- Implement and manage dbt projects, developing and maintaining models, tests, and documentation to ensure data accuracy and consistency. Continuously improve dbt workflows to enhance efficiency.
- Establish and enforce data quality standards and governance policies. Monitor data pipelines for accuracy and completeness, and implement validation procedures to resolve data issues.
- Collaborate effectively with cross-functional teams, communicating technical concepts clearly to non-technical stakeholders. Provide mentorship to junior team members, fostering continuous learning and improvement.
- Identify and address performance bottlenecks in data processing and querying. Implement optimization techniques to enhance database performance, and continuously monitor and tune operations for efficiency.
What You Have:
- Proven experience in developing enterprise-level data marts to drive business reporting and analytics
- Expertise in relational database management systems, data modelling, and schema design
- Strong SQL development and Python programming skills
- Excellent analytical, problem-solving, written, and verbal communication skills
- 5+ years of experience in data pipeline development and data warehousing with big data technologies (e.g. Apache Spark, Google DataFlow, SingleStore, Impala, Kudu, BigQuery)
- Knowledge of data integration patterns, data load patterns, and software development best practices
- Proficient in version control tools
- Familiarity our tech stack: Databricks, dbt, Google Cloud Platform, and BigQuery is advantageous
- Experience with workflow management tools (e.g., Airflow, Luigi, Oozie) is beneficial
- Bachelor's or Master's degree in Computer Science, Data Science, or related field is advantageous
- Ability to collaborate effectively in a team environment with internal stakeholders is a must
- Good leadership and workload management skills are advantageous
Nice to have:
Affiliate & Partnerships Industry Fundamentals Certification by PXA
Benefits:
- Hybrid, Casual work environment
- Responsible 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 for provident fund
- Restricted Stock Units
- 3-year vesting schedule pending Board approval
- Internet Allowance
- Fitness club fee reimbursementsTechnology stipend
- Primary caregiver leave
impact.com is proud to be an equal opportunity workplace. 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow Big Data BigQuery Computer Science Data Analytics Databricks Dataflow Data pipelines Data quality Data warehouse Data Warehousing dbt Engineering GCP Google Cloud Oozie Pipelines Python RDBMS Spark SQL
Perks/benefits: Career development Equity / stock options Flex vacation Home office stipend Medical leave
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Research Scientist jobs
- Open Data Science Manager jobs
- Open Junior Data Analyst jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Scientist II jobs
- Open BI Analyst jobs
- Open Business Intelligence Engineer jobs
- Open Sr. Data Scientist jobs
- Open Data Science Intern jobs
- Open Senior Business Intelligence Analyst jobs
- Open Software Engineer, Machine Learning jobs
- Open Lead Data Analyst jobs
- Open Azure Data Engineer jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Manager, Data Engineering jobs
- Open Marketing Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Engineer III jobs
- Open Data Engineering Manager jobs
- Open Junior Data Engineer jobs
- Open Data Analyst II jobs
- Open Product Data Analyst jobs
- Open Privacy-related jobs
- Open Power BI-related jobs
- Open Tableau-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open Consulting-related jobs
- Open Business Intelligence-related jobs
- Open Generative AI-related jobs
- Open NLP-related jobs
- Open CI/CD-related jobs
- Open Data governance-related jobs
- Open Kubernetes-related jobs
- Open DevOps-related jobs
- Open Git-related jobs
- Open Docker-related jobs
- Open Hadoop-related jobs