Consulting Tech Lead - 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 solution architect to establish new patterns, standards, processes and procedures for client’s solution and data community.
Providing technical leadership to teams that 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.
Effectively communicating solution to both business and technical teams.
Understanding technical landscape that the solution resides in.
Delivery Leadership:
Providing technical leadership to developers and analysts for various workloads
Delivery team management and oversight
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
Engage with range of technical and non-technical stakeholders on a project to convey progress, solution, issues and risks of workload.
Constant learning and keeping up to date with current technology and data standards
Ability to successfully manage complexity and make sense of conflicting information around a client’s requirements
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 background in SQL and data is required
Ability to pick up and understand new technology is expected.
Technical:
Demonstrate experience in database and database development. Experience in some 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
- Azure
- GCP
- Snowflake
ETL:
- SSIS
- IBM DataStage
- SAP Data Services
- Informatica or similar
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
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
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.
Minimum:
6 Years of working experience
Preferred:
8 Years in a client facing role
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.