Consulting - Data Engineer

Job description / Role

Line of Service
Advisory

Industry/Sector
Specialism

Management Level
Senior Associate

Job Description & Summary
Needs to have the ability to work with business and technical stakeholders to understand the business requirements, extract the analysis needed, study the data available and produce a data product that can support a company's decision-making process and advanced analysis of information. Able to design, build, operationalize, secure and monitor data processing systems with emphasis on security and compliance; scalability and efficiency; reliability and fidelity; and flexibility and portability.

Key Technical Skills:
• Collect, manage, analyze and visualize data
• Develop, construct, test and maintain architectures (such as databases and large-scale processing systems)
• Ability to work with multiple data sources and databases
• Advanced working SQL knowledge and experience working with relational databases, query authoring (T-SQL, PL/SQL, etc.) as well as working familiarity with a variety of databases (SQL Server, Oracle, etc.)
• Functional and technical design of DW (star schema and snowflakes)
• Advanced working experience in data ingestion tools, such as ADF, SSIS, Informatica for ETL pipelines development
• Advanced working experience in dimensional data modelling, data model optimization and model performance tuning
• Build and verify new data models that aid decision-making
• Practical experience with Visualization and Reporting tools such as Qlik, Tableau,   Power BI and Excel (Power Pivot)
• Capable of collaborating with Team Leads in understanding and contributing to the technical solution from design through implementation level

Leadership, Management and Other Skills:
• Partner with Team Leads and Product Owners in understanding all data requirements
• Proven ability to suggest and implement creative, innovative solutions which are aligned to the business requirements
• Work with technical teams to build/improve data analytics and business intelligence techniques
• Excellent spoken and written English skills, with ability to communicate clearly and concisely with QA, other developers and Team Lead
• Interpersonal skills to interact with team members
• Follow defined methodology and standards including preparation and maintenance of documentation for all stages of an Analytics project execution
• Strong analytical and problem-solving skills
• Positive attitude with ability to see through to completion

Requirements

Technologies and Tools:
• Relational SQL and NoSQL databases, including some of the following: Azure Synapse/SQL DW and SQL Database, SQL Server and Oracle
• Data pipeline and workflow management tools: Data Factory, Informatica Data Engineering, Databricks, etc.
• Core cloud services from at least one of the major providers in the market (Azure, AWS, Google)
• Data visualization tools, mainly Power BI
• Agile Methodologies, such as SCRUM
• Task tracking tools, such as TFS and JIRA

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.