ETIC, AWS Data Engineer - Senior Associate

Job description / Role

Line of Service
Advisory

Industry/Sector
Technology

Specialism
Advisory - Other

Management Level
Senior Associate

Job Description & Summary

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 4+ years of hands-on experience of data analytics solutions on cloud platforms
• +4 years hands-on experience of AWS data analytics technologies including: S3, Lake Formation, RDS, EMR, Glue, Redshift, Athena, Kinesis, Sage Maker, Kafka, QuickSight, Elasticsearch
• You'll be well versed in data architecture approaches to ingest, model and serve data from various sources including structured and unstructured data sources
• In addition, you should also be comfortable in implementing the right solution, whether that is ELT or ETL
• Delivery of solutions through the full lifecycle of a enterprise data platform implementation, including data warehouses, Big Data, MDM and DQM / data profiling
• Experience of design and implementation of Information Strategy, Information Architecture and Governance projects to ensure the security, integrity, and availability of information with appropriate technical documentation and QA activities
• Modern data lakes and data warehouse solutions.
• The ability to design and implement data models from concept through to reality, which could include slowly changing dimensions or single customer views
• 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

Technical skills:
• Foundational understanding of Data & Analytics Architectures, definition of KPIs / metrics and insight requirements
• You should have experienced 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
• Proficient in SQL and performance tuning of queries, ensuring solutions are both scalable and maintainable
• Practical knowledge of core data modelling, manipulation and visualisation skills- for example using tools such as Excel, Alteryx, PowerBI/Tableau/Qlik

Project skills:
• Experience in shaping and planning projects through either Waterfall or Agile methodologies
• Experience using Agile project management tools (DevOps, Trello, JIRA, Kanbanchi etc)
• Supporting the design and delivery of data transformation projects with clients. This will include:
• Translating business requirements into technical specifications, helping to understand and create solutions to our clients' key challenges
• Participating in end-to-end planning, coordination and oversight of the project lifecycle including resourcing, scoping, architecting and delivery
• Developing client relationships including with C-level staff, Heads of Data and Analytics, IT and Data Architects and other business stakeholders during the lifecycle of a project
• Collaborating with our wider D&A teams across the firm, whether that be locally or working with our alternative delivery teams (onshore and offshore)
• Taking an active role in coaching and developing skills for more junior team members
• Man interface with client relationships including with C-level staff, Heads of Data and Analytics, IT and Data Architects and other business stakeholders during the lifecycle of a project.

Additional Skills:
• Preferably experience in implementing data visualization using Power BI but will consider other visualisation tools.

Requirements

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 Data Analytics is a must
• 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.