Search jobs

Related jobs

More retail jobs...

BI Developer

Remuneration:market-related 
Location:Cape Town
Job level:Junior/Mid
Job policy:Employment Equity position
Type:Permanent
Reference:#CUMG-6088
Company:Cape Union Mart - Head Office


Job description

The successful incumbent will be responsible for expanding and optimizing our data warehouse architecture, as well as optimizing data flow and collection for cross functional teams. You will support our cross functional teams with data initiatives and will ensure optimal data delivery throughout ongoing projects. They must be comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimising or even re-designing our company’s data architecture to support our next generation of products and data initiatives.


Responsibilities


    • Create and maintain optimal data warehouse architecture.

    • Assemble large, complex data sets that meet functional/non-functional business requirements.

    • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

    • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Oracle technologies.

    • Build analytics tools that utilise the data pipeline to provide actionable insights into operational efficiencies and other key business performance metrics.

    • Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs.

    • Apply the necessary data governance policies to ensure that the data is accurate and up to date with source systems.

    • Create data tools for analytics and product owning team members that assist them in building and optimising our product into an innovative industry leader.

    • Work with data and analytics experts to strive for greater functionality in our data systems.


Experience


    • Advanced working SQL and Oracle knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases (SQL, RDS etc.).

    • Experience with data visualisation tools e.g. Power BI, QlikView, QlikSense.

    • Experience building and optimizing ‘big data’ data pipelines, architectures and data sets.

    • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

    • Strong analytic skills related to working with unstructured datasets.

    • Build processes supporting data transformation, data structures, metadata, dependency and workload management.

    • A successful history of manipulating, processing and extracting value from large disconnected datasets.

    • Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.

    • Experience supporting and working with cross-functional teams in a dynamic environment.

    • Experience with relational SQL and NoSQL databases, including Postgres.

    • Experience with developing/designing data warehouses/data lakes and the associated ETL, and ELT processes

    • Experience with stream-processing systems: Storm, Spark-Streaming, etc.

    • Experience with object-oriented/object function scripting languages: Python, Java, C/C#, R, etc.

    • Experience with AWS cloud services: EC2, EMR, RDS, Redshift, S3 (Advantageous).

    • Experience with big data tools: Hadoop, Spark, Kafka, etc. (Advantageous).



Requirements


    • Degree in information technology / mathematics / engineering / actuarial science or related discipline.

    • 6+ years in a technical data role, preferably in a formal data, data warehouse or business intelligence environment.



Please note:  The Cape Union Mart Group is committed to transformation.  Appointments and promotions will be made based on candidates who best meet the requirements for the position. Preference will be given to candidates who will enhance the diversity of the team, aligned to our Employment Equity plan.

Posted on 10 May 17:12, Closing date 8 Jun



Cape Union Mart
Cape Union Mart International (Pty) Ltd has been equipping South African adventurers since 1933, and is South Africa's favourite outdoor adventure store. Stocking everything one needs for outdoor pursuits - including hiking, camping, trail running, mountain biking, snow sports, travel and more - Cape Union Mart is an essential first step in every adventure. Cape Union Mart has stores across South Africa, and in Namibia and Botswana.
Recent jobs by Cape Union Mart CityDate posted
E-commerce CopywriterCape Town18 May 16:24
Shift LeaderBloemfontein18 May 15:31
Sales AssistantPretoria18 May 14:25
Sales AssistantPolokwane18 May 14:25
Sales AssistantBela-Bela18 May 14:24
Sales AssistantKlerksdorp18 May 14:23
Shift SupervisorPretoria18 May 14:15
Buyers Assistant - Poetry/Old Khaki AccessoriesCape Town17 May 21:14
Pattern Maker - Design CentreCape Town17 May 21:13
Sales AssistantPort Elizabeth17 May 16:23
More jobs...

Get job alerts for Developer jobs

Dynamics 365 Developer
Cape Town
A leading Asset Management Group seeks to fill the role of a Dynamics 365 Developer with hands-on D365 development experience & able to customize CRM forms, views...
3 hours ago
Java Developer
Cape Town
Design high-performance and exceptional quality software solutions as your coding talents as a Java Developer is sought by a global Tech company providing cutting-edge...
3 hours ago
Mid-Senior Java Developer
Cape Town
South Africa’s most dynamic financial institute requires Mid to Senior Java Developers to join their dynamic, innovative, award-winning business in two of their...
8 hours ago
BI Junior Developer
Cape Town
The successful incumbent will be responsible for expanding and optimizing our data warehouse architecture, as well as optimizing data flow and collection for cross...
2 days ago
Senior GIS Developer x2
Cape Town
The City of Cape Town promotes and applies the principles of employment equity.
2 days ago
Creative Developer
Johannesburg, Randburg Ferndale
Rapid Blue, one of the leading production companies in Africa, is looking for a creative developer to join the creative team. Closing date for applications: 15...
Rapid Blue
13 May 2022
C# Full Stack Developer
Stellenbosch
A focused cloud solutions and IT consultancy company seeks a C# Full Stack Developer who is passionate about their work.
12 May 2022
Mid-Senior Back-End API Developer
Stellenbosch
The coding expertise of a self-driven Mid-Senior Back End API Developer, with the ability to understand and interpret business requirement documentation, is sought by a...
12 May 2022
Intermediate C#/SQL Developer
Somerset West
A dynamic provider of Enterprise Software Solutions seeks the coding talents of a deadline-driven Intermediate C# / SQL Developer who enjoys solving complex problems.
12 May 2022
Front End Developer
George
Company Profile               Pacific International Insurance Pty Ltd, is an Australian based...
11 May 2022
Full Stack Developer
Cape Town
Retail bank based in Stellenbosch requires a Developer to join their fast-growing organisation.
10 May 2022
Salesforce Developer
Cape Town
Perform complex research, design, and software development assignments within a software functional area or product line as your expertise as a Salesforce Developer is...
10 May 2022
Mobile Developer/Tech Lead
Cape Town, Century City
Lead a team responsible for both iOS & Android mobile applications of a global client of a cutting-edge FinTech company in Century City seeking your coding expertise...
10 May 2022
Senior Java Software Developer
Cape Town
Want to take your career to new heights? A leading JSE listed ground breaking mobile technology organization is on the prowl for their next Senior Java Software...
10 May 2022
Senior Ruby on Rails Developer
Cape Town
A cutting-edge global Mobile Tech company seeks the coding expertise of a forward-thinking Senior Ruby on Rails Developer with a technical bent & pragmatic approach...
10 May 2022
Senior Full Stack Developer
Cape Town
A fast-paced and forward-thinking digital marketing agency seeks a senior full-stack developer to develop solutions for the fintech space.
9 May 2022
Java Developer Lead
Cape Town
Think of a career destination on the Cape Town beachfront – a breath-taking expanse of white sand and surf, against the backdrop of the world-famous Table Mountain.
9 May 2022
Junior Front End Developer
Cape Town
A global SaaS Specialist seeks an ambitious and self-driven Junior Front End Developer to provide hands-on assistance with enhancing existing products and developing new...
8 May 2022
Full Stack Developer
Cape Town
A provider of Data Security Solutions in the Graduate Recruitment space seeks the coding talents of a Full Stack Developer to fill a remote role where you will build and...
6 May 2022
Mid-Level UI Developer
Cape Town, Woodstock
Your visual eye for exceptional aesthetics coupled with proven work experience as a Mid-Level UI Developer is sought by a Digital Advertising Agency, who prides itself...
6 May 2022
Senior Java Developer
Cape Town
This retail giant offers an exciting opportunity in the IT money market space where your specialisation in preferably Hybris eCommerce or other eCommerce Platforms, and...
5 May 2022
Junior Web Developer x2
Cape Town
A national provider of digital communications seeks an ambitious & self-driven Junior Web Developer to provide hands-on assistance with the development of creative...
5 May 2022
Back-End Developer
Cape Town
A rapidly growing Specialist Software Solutions Provider in Ireland seeks a Back-End Developer who is able to build robust features and satisfy complex requirements in...
5 May 2022
Front-End Developer - React
Cape Town
A rapidly growing Specialist Software Solutions Provider in Ireland seeks a Front-End Developer (React) who is motivated to combine the art of design with the art of...
5 May 2022
Python Back End Developer - Golang
Cape Town
Give critical input on architectural decisions and design choices as the next Python Back End Developer sought by a global Telecommunications Service Provider.
5 May 2022
Senior Back End Developer
Cape Town
Take technical ownership of application and service architectural implementation as the next Senior Back End Developer sought by a dynamic FinTech company.
3 May 2022
Full Stack C# Developer
Cape Town
One of the biggest retail banks who have fast grown because they believe in pushing the boundaries to make banking simple is on the lookout for a Full Stack Developer.
3 May 2022
Software Developer
Cape Town
A provider of cutting-edge Engineering Solutions in Durbanville seeks a proactive and meticulous Software Developer for automotive controls and data analytics.
3 May 2022
Java Developer
Cape Town, Bellville
A cutting-edge FinTech company in Bellville seeks the coding talents of a Java Developer to write clean, robust, and maintainable code.
3 May 2022
More...
Let's do Biz