AI & Data - Data Engineer - Consultant

Deloitte Africa; Midrand; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading consulting firm in South Africa is seeking a Data Engineering Consultant to support client projects. The role involves establishing standards for data solutions and integrating various data sources to build robust data pipelines. Ideal candidates should have a Bachelor’s degree in Data Science and 1-3 years of experience in data engineering, preferably with AWS knowledge.

Qualifications

• 1 - 3 years working experience in data engineering, with client-facing exposure.
• Experience with AWS is preferred.
• Solid experience in data and SQL is required.

Responsibilities

• Support the Engagement team in delivery of services to clients.
• Establish new patterns, standards, processes, and procedures for client’s solution.
• Help design and build solutions, communicating with both technical and business teams.

Skills

Problem solving

Data integration

Data warehousing

SQL

Data modeling

Communication skills

Client-focused

Education

Bachelor’s Degree in Data Science or related Degree

Post Graduate Honours Degree in Data Science or related Degree

Tools

SQL Server

NoSQL

AWS

Azure

Python

Spark

Job description

Company Description

At Deloitte, our Purpose is to make an impact that matters for our clients, our people, and society. This is the lens for which our global strategy is set. It unites Deloitte professionals across geographies, businesses, and skills. It makes us better at what we do and how we do it. It enables us to deliver on our promises to stakeholders, while creating the lasting impact we seek.

Harnessing the talent of 450,000+ people located across more than 150 countries and territories, our size and scale puts us in a unique position to help change the world for the better—by bringing together the services we provide, the societal investments we make, and the collaborations we advance through our ecosystems.

Deloitte offers career opportunities across Audit & Assurance (A&A), Tax & Legal (T&L) and our Consulting services business, which is made up of Strategy, Risk & Transactions Advisory (SR&T) andTechnology & Transformation (T&T).

Job Description

We are looking for a Data Engineering Consultant to make an impact in our team and at the clients. This role will support the Engagement team in delivery of services to clients on engagements and projects.

Main Purpose of the Job:

Supporting the Technical Lead in establishing new patterns, standards, processes and procedures for client’s solution and data community. Specialize in data integration and data warehousing concepts to extract data from disparate sources and transform it as per business requirement and load the required tables that can be consumed downstream. Helping design and build solutions, communicating to both technical and business teams at a client and covey solutions to business requirements.

Data Engineering Competencies:

• Able to define a structured approach to problem solving
• Completion of data models and designs within client’s architecture and standards
• Build robust data pipelines and ETL’s using integration tools and services
• Understanding complex business environments and requirements and design a solution based on leading practices
• Ability to document design and implement solutions for client product owners
• Completion of deliverables for gaining architectural approval at client
• Understanding of DataOps approach to solution architecture.
• Solid experience in data and SQL is required
• Solid data modelling experience

Technical Competencies:

Must have experience in one or more services and technologies listed below:

• Database: SQL Server, NoSQL (Hbase, Cassandra or Mongo DB), Cloud Based Databases (Hive, Cosmos DB, Dynamo DB), Redshift/Redshift Spectrum, AWS RDS
• Database Development: Experience Views, functions, stored procedures, Optimisation of queries, building indexes, OLAP / MDX
• Cloud: AWS / Azure / GCP /Snowflake
• ETL: AWS Glue, Athena, SSIS, IBM DataStage / SAP Data Services, AWS DMS, Appflow Programming, SQL (TSQL /HQL etc), Python, Spark, UNIX & Shell Commands (Python / shell / Perl) is a plus
• Modelling: Data Vault (pref), Kimball (Pref), 3rd Normal Form / OLAP / MDX)
• Big Data: Hadoop Platform (Cloudera / cloud equivalent), HiveQL /Spark / Ooozie / Impala / Pig), Optimising Big Data Streaming (NiFi / Kafka)
• Data Acquisition: Pipeline creation, Automation and data delivery Once off, CDC, Streaming

Behavioural Competencies:

• Excellent communication skills, both written and verbal
• Ability to develop & grow technical teams
• Objective oriented with strong client delivery focus
• Client focused by building strong trusting relationships with clients
• Focus on quality and risk
• Sound problem solving ability
• Ability to understand and comprehend complex environments and systems.
• Inquisitive by nature and keen to figure out how things work
• Continuous learning mindset

Qualifications

Minimum Qualifications

Bachelor’s Degree in Data Science, Engineering, BSc Computer Science, or related Degree

Desired Qualifications

Post Graduate Honours Degree in Data Science Engineering or related Degree,

Data and technology related cloud certifications

Minimum Experience

1 - 3 years working experience in data engineering, with client-facing exposure

Experience with AWS is preferred

Additional Information

At Deloitte, we want everyone to feel they can be themselves and to thrive at work—in every country, in everything we do, every day.We aim to create a workplace where everyone is treated fairly and with respect, including reasonable accommodation for persons with disabilities. Weseek to create and leverage our diverse workforce to build an inclusive environment across the African continent.

Note: The list of tasks / duties and responsibilities contained in this document is not necessarily exhaustive. Deloitte may ask the employee to carry out additional duties or responsibilities, which may fall reasonably within the ambit of the role profile, depending on operational requirements.

Be careful of Recruitment Scams: Fraudsters or employment scammers often pose as legitimate recruiters, employers, recruitment consultants or job placement firms, advertising false job opportunities through email, text messages and WhatsApp messages. They aim to cheat jobseekers out of money or to steal personal information.

To help you look out for potential recruitment scams, here are some Red Flags:

• Upfront Payment Requests:Deloitte will never ask for any upfront payment for background checks, job training, or supplies.
• Requests for Personal Information:Be wary if you are asked for sensitive personal information, especially early in the recruitment process and without a clear need for it. Fraudulent links or contractual documents may require the provision of sensitive personal data or copy documents (e.g., government issued numbers or identity documents, passports or passport numbers, bank account statements or numbers, parent’s data) that may be used for identity fraud. Do not provide or send any of these documents or data. Please note we will never ask for photographs at any stage of the recruitment process.
• Unprofessional Communication:Scammers may communicate in an unprofessional manner. Their messages may be filled with poor grammar and spelling errors. The look and feel may not be consistent with the Deloitte corporate brand.

If you're unsure, make direct contact with Deloitte using our official contact details. Be careful not to use any contact details provided in the suspicious job advertisement or email.