Consulting - Senior Data Engineer

Company Description

Deloitte is the largest private professional services network in the world. Every day, around 312,000 professionals in over 150 countries prove their commitment to a single vision: to establish the standard of excellence, while working towards one goal – to make an impact that matters. Click here to read more about Deloitte.

About the division

Innovation, transformation, and leadership occur in many ways. At Deloitte, our ability to help solve clients’ most complex challenges is distinct. We provide strategy and implementation, from a business and technology perspective, to help lead in the markets where our client's compete.

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

Deloitte consulting is expanding, with a focus on developing our already strong teams across our array of offerings. We are looking for intelligent, accountable, innovative professionals with technical expertise and deep industry experience insights. The combination of our six areas of expertise, our well-formed industry structure, and our integrated signature solutions is a unique offering never seen before on the African continent.

Job Description

Assist and collaborate with the Technical Lead in establishing new models and standards, processes and procedures for client’s solution and data community.

Master data integration and data warehousing concepts to extract data from various sources and transform it as per business requirement and load the necessary tables to be consumed downstream.

Help design and build solutions, communicate both with technical and business teams at a client and convey solutions to business requirements.

Delivery Leadership:

• Define high level solution design options based on client needs
• Create design standards and patterns reusable in a client’s solution
• Experience in quick prototyping of potential solutions for design discussions
• Mentoring and coaching of Junior team members
• Perform code reviews of team members
• Accurate breakdown and estimations of tasks for solution
• Capability to quickly learn new technology

Engineering:

• Able to define a structured approach to problem solving
• Completion of data models and designs within client’s architecture and standards
• Understanding of complex business environments and requirements and design 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.
• Sturdy experience in data and SQL is required

Technical:

Demonstrate experience in the database and database development field. Practical knowledge in other areas is a plus.

DataBase:

• SAP Hana
• Teradata
• SQL Server
• NoSQL (Hbase, Cassandra or Mongo DB)
• Cloud Based Databases(Hive, Cosmos DB, Dynamo DB)

Database Development:

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

Cloud:

• AWS
• Azure
• GCP
• Snowflake

ETL:

• SSIS
• IBM DataStage
• SAP Data Services
• Informatica or similar
• Redshift
• Glue
• Sagemaker

Programming:

• SQL (TSQL /HQL etc)
• Java
• Python
• Spark / Kafka / RabbitMQ
• UNIX & Shell Commands (Python / shell / Perl) is a plus

Modelling:

• Data Vault (preferred)
• Kimball (preferred)
• 3rd Normal Form / OLAP / MDX)
• Big Data
• Hadoop Platform (Cloudera / cloud equivalent)
• HiveQL /Spark / Ooozie / Impala / Pig)
• Optimizing Big Data
• Streaming (NiFi / Kafka)
• Methodologies:
• Agile
• PMBOK
• DataOps / DevOps

Data Acquisition:

• Pipeline creation, Automation and data delivery
• Once off, CDC, Streaming

Behavioral:

• Excellent communication skills, both written and verbal
• Ability to develop & grow technical teams
• Objective-oriented with strong client delivery focus
• Customer-centric, building strong trusting relationships with clients
• Focus on quality and risk
• Good problem-solving ability
• Ability to comprehend complex environments and systems.
• Curious by nature and eager to figure out how things function

Qualifications

3 - 5 years of work experience with client-facing experience

Minimum:

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

Preferred:

Post Graduate Degree in Data Science Engineering or related Degree,
Data-related cloud certifications

Additional Information

Please note that Deloitte may ask its employee to perform additional duties or responsibilities, which may fall reasonably within the scope of the role profile, depending on operational requirements.