Data Engineer – Senior Consultant – AWS

myDeloitte; Johannesburg; On-site; ZAR 300,000 - 800,000; Full time

Job summary

Join a forward-thinking company at the forefront of AI and data solutions. This role focuses on data integration and warehousing, allowing you to work with cutting-edge technologies while collaborating with talented professionals. You will help clients leverage AI to transform their operations and achieve new levels of excellence. With a commitment to innovation and a diverse workplace, this opportunity offers a chance to grow your skills and make a real impact in the industry. If you're ready to embrace challenges and drive change, this position is perfect for you.

Qualifications

• 3-5 years of client-facing experience in data integration and warehousing.
• Bachelor’s degree in Data Science or Engineering required.

Responsibilities

• Support Technical Lead in establishing patterns and standards for data solutions.
• Design and build solutions, communicating effectively with teams.

Skills

Data Integration

Data Warehousing

SQL

Communication Skills

Problem-Solving

Client Relationship Management

Agile Methodologies

DataOps

Education

Bachelor’s Degree in Data Science

Post Grad Degree in Data Science

Tools

SAP Hana

SQL Server

AWS

SSIS

IBM DataStage

Informatica

Java

Python

UNIX & Shell Commands

Job description

Deloitte is a leading global provider of audit and assurance, consulting, financial advisory, risk advisory, tax and related services. Our global network of member firms and related entities in more than 150 countries and territories (collectively, the “Deloitte organisation”) serves four out of five Fortune Global 500 companies. Learn how Deloitte’s approximately 457,000 people make an impact that matters at www.deloitte.com.

Innovation, transformation and leadership occur in many ways. At Deloitte, our ability to help solve clients’ most complex issues is distinct. We deliver strategy and implementation, from a business and technology view, to help lead in the markets where our clients compete.

Are you a game changer? Do you believe in adding advantage at every level in everything you do? You may be one of us.

Deloitte Consulting is growing, with a focus on developing our already powerful teams across our portfolio of offerings. We are looking for smart, accountable, innovative professionals with technical expertise and deep industry experience insights. The combination of our 6 areas of expertise, our well-developed industry structure and our integrated signature solutions is a unique offering never seen before on the African continent.

Be at the forefront of the revolution.

AI-enabled technologies are shaking business foundations. Some find this daunting. We see opportunity—for clients, societies, and people.

Deloitte’s AI & Data Specialists partner with clients to leverage AI and reach new levels of organisational excellence. We turn data into insights, into action—at an industrial scale.

Join us as we enable clients to grasp the future and reach new heights. Learn from the best in the field to create solutions blending data science, data engineering, and process engineering with our industry-leading expertise.

Job Description

Working with and supporting 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 convey solutions to business requirements.

Delivery Leadership:

• Define high-level solution design options based on client requirements
• Creation of design standards and patterns reusable in a client’s solution
• Experience in rapid prototyping of potential solutions for design trade-discussions
• Mentoring and training of Junior members of the team
• Completing code reviews of team members
• Accurate breakdown and estimations of tasks for solution
• Ability to pick up and learn new technology quickly
• Able to define a structured approach to problem-solving
• Completion of data models and designs within client’s architecture and standards
• Understanding complex business environments and requirements and designing a solution based on leading practices
• Ability to document design and solutions for understanding by 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

Technical:

Demonstrate experience in database and database development. Experience in other areas is a bonus.

DataBase:

• SAP Hana
• SQL Server

Database Development:

• Experience with Views, functions, stored procedures, optimisation of queries, building indexes, OLAP / MDX

Cloud:

• AWS

ETL:

• SSIS
• IBM DataStage
• SAP Data Services
• Informatica or similar

Programming:

• Java
• Python
• UNIX & Shell Commands (Python / shell / Perl) is a plus
• Data Vault (preferred)
• Kimball (preferred)
• 3rd Normal Form / OLAP / MDX
• Streaming (NiFi / Kafka)

Methodologies:

• Agile
• PMBOK
• DataOps / DevOps

Data Acquisition:

• Once off, CDC, Streaming

Qualifications

Minimum: Bachelor’s Degree in Data Science, Engineering or related Degree

Preferred: Post Grad Degree in Data Science Engineering or related Degree,
Data related cloud certifications

Experience:

3 - 5 years working experience with client facing experience

Additional Information

Behavioural:

• 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

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. We seek to create and leverage our diverse workforce to build an inclusive environment across the African continent.