Modeller OLAP/Automation

Circana; Cape Town; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading data analytics firm is seeking a Data Modeler to join their Global Professional Services team in Cape Town, South Africa. The role requires designing and maintaining data pipelines on the Azure cloud platform, with a focus on retail and hospitality sectors. Candidates should hold a relevant degree and possess strong skills in SQL, Python, and big data analytics. The ideal candidate will have at least two years of experience and a passion for technology and data solutions.

Qualifications

• Degree focused on systems technology is required.
• 2 years of hands-on experience in big data analytics is essential.
• Strong understanding of data manipulation techniques is crucial.

Responsibilities

• Interface with business and data engineering teams.
• Support sales process by interacting with clients.
• Convert business requirements to data models.

Skills

SQL

Python

Java

C++

C#

Data manipulation

Quantitative techniques

Education

Engineering, Science or Business Degree

Tools

Big Data infrastructures

OLAP principles

Job description

Let’s be unstoppable together!

At Circana, we are fueled by our passion for continuous learning and growth, we seek and share feedback freely, and we celebrate victories both big and small in an environment that is flexible and accommodating to our work and personal lives. We’re a global company dedicated to fostering inclusivity and belonging. We value and celebrate the unique experiences, cultures, and viewpoints that each individual brings. By embracing a wide range of backgrounds, skills, expertise, and beyond, we create a stronger, more innovative environment for our employees, clients, and communities. With us, you can always bring your full self to work. Join our inclusive, committed team to be a challenger, own outcomes, and stay curious together. Circana is proud to be Certified by Great Place To Work. This prestigious award is based entirely on what current employees say about their experience working at Circana.

Learn more at www.circana.com.

What is the role & team:

Join our Global Professional Services team as a Data Modeler, where you will be instrumental in bridging the gap between client needs, business objectives, and cutting‑edge technology solutions, particularly supporting our new Private Cloud clients. This role is for more than just a service provider; we are seeking a consultant‑mindful go‑getter who is client‑obsessed, a liquid thinker who thrives at pace, and is bold and brave in challenging the status quo. We are a team that values being part of a successful business and building partnerships based on trust, deep knowledge, respect, and unwavering support. We are passionate about technology, data and AI and how it can be leveraged to solve our clients' most pressing business challenges. You will be a key player in understanding our clients' world, becoming their trusted partner, and proactively identifying opportunities for innovation and efficiency. Curiosity, accountability, and a positive, questioning mindset are at the core of our team's DNA – we don't just aim to meet expectations, we strive to exceed them. You will work collaboratively with global Circana teams, acting as the vital link to ensure seamless, unified support and strategic technological partnership for our clients. In this role we are seeking a skilled and motivated Data Modeler to join a growing Global Team based in the UK. You will be responsible for designing, building, and maintaining robust data pipelines and infrastructure on the Azure cloud platform. If you have a passion for Data Modelling and a desire to make a significant impact, we encourage you to apply!

What will I be doing?

As a part of the Professional Services New Frontiers team, the AnalyticServer Modeler will participate in the analysis, exploration, and analytics model development efforts for our professional services organization. You will be part of a new industry group tasked with expanding our business into new capabilities and markets. This role will include working with clients to understand the use cases at a technical level and to translate those requirements into the development of multi‑dimensional business models and analytics. Initially, the role will entail working very closely with one of the senior technical leaders and supporting existing engagements, as well as proof of concept for new clients. Ultimately, this role will transition into a leader of a self‑contained team as new markets expand. The role will work very tightly with the business teams to understand use cases and translation into the measures, dimensions and algorithms required to support those insights. This role will be responsible for documenting the required model, as well as the build, test and deployment. Initially, this role will primarily be in all areas of retail and hospitality, however, expected to expand into other industries.

Job Responsibilities

• Interfacing both with the front-end business teams, as well as the data, sourcing and engineering teams
• Support of initial sales process including interacting with client technical teams
• Conversion of business requirements into data and business model requirements
• Design, development, and testing of new analytics features & capabilities
• Collaborate with other team members in creation and extension of multi‑dimensional models
• Directly support the ongoing development and maintenance of systems lifecycle methodologies

Requirements

• Engineering, Science or Business Degree with a heavy focus on systems technology
• Demonstrated understanding of data manipulation and broad quantitative techniques
• Strong working knowledge of SQL and DDL
• Advanced expertise in an object‑oriented language, such as Java, C++, or C#
• 2 years of hands‑on experience in big data analytics and coding in Python or similar scripting language
• Problem solving mindset
• Good verbal and written communication (including documentation) skills
• Knowledge and experience on Big Data infrastructures (MPP databases and Distributed Data platforms) and any Cloud platform is a plus
• Understanding, as well as the ability to clearly communicate OLAP principles is a plus, but not required
• Knowledge and experience in retail and hospitality is a plus but not required

About Us

As one of the original innovators in Big Data, CIRCANA integrates the world’s largest set of otherwise disconnected purchase, media, social, causal and loyalty data to help CPG, retail, over‑the‑counter health care and media companies grow their businesses. We combine this data with predictive analytics to uncover new consumer insights and integrate them on the most technologically advanced, cloud‑based visualization platform. Learn more about us

What are we looking for?

We are seeking an individual who embodies the following characteristics:

• An authentic optimist with a genuine passion for solving problems and driving progress.
• Intensely curious – you love to understand the ‘why’ and ‘how’ behind things, especially when it comes to technology and client challenges.
• Highly accountable for your actions, your deliverables, and the success of your clients.
• Comfortable and adept at building strong, professional relationships with both external clients and internal technical and business teams.
• Deeply committed to giving your best for your team and ensuring our technology solutions exceed client expectations.
• Confident in making informed decisions, weighing options and considering the technical and business implications.
• Highly organised, with meticulous attention to detail in managing documentation, communication, and time.
• Passionate about technology, Data, AI, and their application in solving real‑world business problems.
• Previous experience translating client requirements into technical specifications
• Previous experience building relationships with clients.