Cloud & AWS - Data Engineer - Consultant

We are looking for a Data Engineering Consultant to make an impact in our team and at the clients. This role will support the Engagement team in delivery of services to clients on engagements and projects.Main Purpose of the Job: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.Data Engineering Competencies:Able to define a structured approach to problem solvingCompletion of data models and designs within client’s architecture and standardsBuild robust data pipelines and ETL’s using integration tools and servicesUnderstanding complex business environments and requirements and design a solution based on leading practicesAbility to document design and implement solutions for client product ownersCompletion of deliverables for gaining architectural approval at clientUnderstanding of DataOps approach to solution architecture.Solid experience in data and SQL is requiredSolid data modelling experienceTechnical Competencies:Must have experience in one or more services and technologies listed below:Database: SQL Server, NoSQL (Hbase, Cassandra or Mongo DB), Cloud Based Databases (Hive, Cosmos DB, Dynamo DB), Redshift/Redshift Spectrum, AWS RDSDatabase Development: Experience Views, functions, stored procedures, Optimisation of queries, building indexes, OLAP / MDXCloud: AWS / Azure / GCP /SnowflakeETL: AWS Glue, Athena, SSIS, IBM DataStage / SAP Data Services, AWS DMS, Appflow Programming, SQL (TSQL /HQL etc), Python, Spark, UNIX & Shell Commands (Python / shell / Perl) is a plusModelling: 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)Data Acquisition: Pipeline creation, Automation and data delivery Once off, CDC, StreamingBehavioural Competencies:         Excellent communication skills, both written and verbalAbility to develop & grow technical teamsObjective oriented with strong client delivery focusClient focused by building strong trusting relationships with clientsFocus on quality and riskSound problem solving abilityAbility to understand and comprehend complex environments and systems.Inquisitive by nature and keen to figure out how things workContinuous learning mindset