Data Engineer – AWS

myDeloitte; Johannesburg; On-site; ZAR 400,000 - 600,000; Full time

Job summary

myDeloitte is seeking a skilled data professional to support various data integration and warehousing projects. The role involves designing solutions, mentoring juniors, and leveraging advanced data technologies. Candidates should have 3-5 years of experience and a strong technical background in data sciences.

Benefits

Inclusive environment fostering diversity

Opportunities for professional growth

Qualifications

• 3-5 years of client-facing experience in data roles.
• Experience in database development essential.
• Data-related cloud certifications preferred.

Responsibilities

• Support the Technical Lead in establishing new patterns and processes for data integration.
• Design and build solutions that align with business needs.
• Mentor and train junior team members.

Skills

Excellent communication skills

Problem-solving skills

Data integration

Data warehousing concepts

Education

Bachelor’s Degree in Data Science

Postgraduate Degree in Data Science

Tools

SAP HANA

SQL Server

SSIS

AWS

IBM DataStage

Informatica

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 organization”) 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 perspective, 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. Our unique combination of six areas of expertise, our well-developed industry structure, and our integrated signature solutions create an 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 achieve new levels of organizational excellence. We turn data into insights, into action—on 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

Support the Technical Lead in establishing new patterns, standards, processes, and procedures for the client’s solution and data community.

Specialize in data integration and data warehousing concepts to extract data from disparate sources, transform it according to business requirements, and load the required tables for downstream consumption.

Design and build solutions, communicate effectively with technical and business teams, and convey solutions aligned with business needs.

Delivery Leadership:

• Define high-level solution design options based on client requirements
• Create design standards and patterns that are reusable in client solutions
• Prototype potential solutions rapidly for design trade-off discussions
• Mentor and train junior team members
• Conduct code reviews of team members’ work
• Break down tasks accurately and provide estimations for solutions
• Learn new technologies quickly
• Apply structured problem-solving approaches
• Develop data models and designs within client architecture and standards
• Understand complex business environments and requirements to design solutions based on best practices
• Document designs and solutions for client understanding
• Complete deliverables for architectural approval at the client
• Understand DataOps approach to solution architecture
• Solid experience in data and SQL is required

Technical Skills:

Demonstrated experience in database development is essential. Experience in other areas is a bonus.

Database:

• SAP HANA
• SQL Server

Database Development:

• Views, functions, stored procedures, query optimization, indexing, OLAP / MDX

Cloud:

• AWS

ETL Tools:

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

Programming Languages:

• 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:

• One-off, CDC, Streaming

Qualifications

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

Preferred: Postgraduate Degree in Data Science, Engineering or related field, and data-related cloud certifications

Experience:

3-5 years of client-facing experience in data roles

Additional Information

Behavioral Skills:

• Excellent communication skills, both written and verbal
• Ability to develop and grow technical teams
• Objective-oriented with a strong client delivery focus
• Builds strong, trusting relationships with clients
• Focus on quality and risk management
• Strong problem-solving skills
• Ability to understand and navigate complex environments and systems
• Keen to understand how things work

At Deloitte, we foster an inclusive environment where everyone can be themselves and thrive. We are committed to fairness, respect, and diversity across the African continent.

Note: The list of tasks and responsibilities is not exhaustive. Deloitte may assign additional duties as operationally required.