Analytics Engineer

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 Analytics Engineer to support the growth and development of our 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 be responsible for developing and maintaining 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 integration and optimization of our data infrastructure. Our ideal candidate will have a strong technical background in data engineering, a solid understanding of data analytics, and the ability to collaborate effectively across teams to deliver impactful solutions.

What You'll Do:

• Develop 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 SQL queries to support data transformation and analysis. Ensure the performance and scalability of SQL code and participate in 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.
• Support the establishment and enforcement of data quality standards and governance policies. Monitor data pipelines for accuracy and completeness, and assist in implementing validation procedures to resolve data issues.
• Collaborate effectively with cross-functional teams, communicating technical concepts clearly to non-technical stakeholders.
• Assist in identifying and addressing performance bottlenecks in data processing and querying. Implement optimization techniques to enhance database performance and monitor operations for efficiency

What You Have:

• Proven experience in developing data marts to support business reporting and analytics
• Strong understanding of relational database management systems, data modelling, and schema design
• Proficient in SQL development and Python programming
• Excellent analytical, problem-solving, written, and verbal communication skills
• 3+ years of experience in data pipeline development and data warehousing
• Knowledge of data integration patterns, data load patterns, and software development best practices
• Familiarity with version control tools
• Exposure to 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 degree in Computer Science, Engineering, or a related field is preferred
• Ability to collaborate effectively in a team environment with internal stakeholders

Nice to have:

Affiliate & Partnerships Industry Fundamentals Certification by PXA

Benefits:

• Hybrid, Casual work environment
• Primary caregiver leave
• 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 reimbursements Technology stipend

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.