Consulting - Senior Data Engineer at Deloitte

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

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