AWS Data Engineer - Associate

Job description / Role

Line of Service
Advisory

Industry/Sector
Technology

Specialism
Advisory - Other

Management Level
Senior Associate

Job Description & Summary
A career within General Consulting services, will provide you with the opportunity to help clients seize essential advantages by working alongside business leaders to solve their toughest problems and capture their greatest opportunities. We work with some of the world's largest and most complex companies to understand their unique business issues and opportunities in an ever changing environment. We help create sustainable change by stimulating innovation, unlocking data possibilities, navigating risk and regulatory complexity, optimising deals, and aligning costs with business strategy to create a competitive advantage.

About the Role
You'll be joining our Data engineering, Reporting and Analytics practice, a core part of our Technology, Data & Analytics business unit. We support our clients in delivering a variety of transformation projects across the commercial sector from defining data strategies to helping architect, design and implement modern data and analytics solutions using the latest cloud technologies.

The role will provide you with an opportunity to work across a portfolio of clients, with a focus on large and complex organisations.

You will work in the team that reports to the Data Analytics delivery service leadership team and will be an integral part of the team based in Cairo, as well as those delivering client transformation programmes across the PwC Global Network, including the UK, Germany and Middle East.

Essential Skills and attributes:
• You'll have +1 years of hands-on experience of data analytics solutions on cloud platforms
• +1 years hands-on experience of AWS data analytics technologies including: S3, Lake Formation, RDS, EMR, Glue, Redshift, Athena, Kinesis, Sage Maker, Kafka, QuickSight, Elasticsearch
• Well versed in data architecture approaches to ingest, model and serve data from various sources including structured and unstructured data sources.
• Comfortable in implementing the right solution, whether that is ELT or ETL.
• Experience in the delivery of solutions through the full lifecycle of a enterprise data platform implementation, including data warehouses, Big Data, MDM and DQM / data profiling
• Modern data lakes and data warehouse solutions.
• Data modelling - the ability to design and implement data models from conceptual through to physical which could include slowly changing dimensions or single customer views
• Dimensional Modelling
• Experience in infrastructure elements of a cloud platform including the setup and implementation of DevOps, networking and security elements.
• Having experience within at least one business area function (e.g Marketing, Sales, Finance, Workforce, Procurement etc.)
• Experience in adapting your communication style to help translate complex technical information to audiences unfamiliar with the technologies.
• Foundational understanding of Data & Analytics architectures, definition of KPIs / metrics and insight requirements
• You should have foundational delivery knowledge in at least one of the following vendors: SAP Business Analytics, Oracle, Cognos, Informatica, IICS, SSIS, Datastage, Talend, data warehouse and data management vendors
• Experience in SQL and performance tuning of queries, ensuring solutions are both scalable and maintainable
• Some practical knowledge of core data modelling, manipulation and visualisation skills- for example using tools such as Excel, Alteryx, PowerBI / Tableau / Qlik

Requirements

Additional Skills
• Preferably experience in implementing data visualization using Power BI but will consider other visualisation tools.
• Data modelling techniques in Data Vault, Industrial 3NF data Models ex: Accord, TDW, CLDM, etc.

Education
• University Degree, in computer science/engineering, business analytics, information systems, or other related disciplines
• Open Group Certified Technical Specialist - Data Engineering is a plus
• Alteryx Certification is a plus
• Celonis certification is a plus
• Microsoft Power BI, Tableau Certification is a plus
• AWS Certification including Data Analytics and/or Database is a plus
• AWS DevOps knowledge is a plus

About the Company

At PwC Middle East, we've set out an ambitious purpose and strive to live it everyday: to solve important problems and build trust in society.

We're a community of solvers that come together in unexpected ways to build trust and create sustained outcomes. We solve important problems, support one another as we grow, develop and build fulfilling careers.

PwC provides industry-focused services for public and private clients across Assurance and Audit, Deals, Consulting, Tax and Legal. We draw on our development legacy that brings together the collective experience of over 7,000 people in our region with offices across 12 countries to solve for tomorrow.

We're striving to consistently deliver innovative work that builds trust and delivers sustained outcomes. And we're proud of the strength that comes from all our different backgrounds and experiences and we value everyone's uniqueness. We thrive in uncertainty, operate with integrity and leverage the diverse perspectives of our teams.

If you're looking for a place that fuels your ambition to make a difference, that matches your curiosity with continuous learning opportunities and reimagines ways of working to enable you to lead a more balanced life, then you're a future PwCer.