Consulting - AWS Data Engineer
- Full-time
- Service Line: Consulting
Company Description
Deloitte is the largest private professional services network in the world. Every day, approximately 312,000 professionals in more than 150 countries demonstrate their commitment to a single vision: to be the standard of excellence, while working towards one purpose – 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 issues is distinct. We deliver strategy and implementation, from a business and technology view, to help lead in the markets where our client's 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.
Job Description
Working with and 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.
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
Engineering:
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 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.
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
- Teradata
- SQL Server
- NoSQL (Hbase, Cassandra or Mongo DB)
- Cloud Based Databases(Hive, Cosmos DB, Dynamo DB)
Database Development:
- Experience Views, functions, stored procedures, Optimisation of queries, building indexes, OLAP / MDX
Cloud:
- AWS
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 (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)
- 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
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
Qualifications
3 - 5 years working experience with client facing experience
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
Additional Information
Please note that 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.
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.