ETIC, Data Engineer, Manager

Cairo - ETIC

PwC

We are a community of solvers combining human ingenuity, experience and technology innovation to help organisations build trust and deliver sustained outcomes.

View all jobs at PwC

Apply now Apply later

Line of Service

Advisory

Industry/Sector

Technology

Specialism

Advisory - Other

Management Level

Manager

Job Description & Summary

A career within Data and Analytics services will provide you with the opportunity to help organizations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organizational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organizations in order to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.

In your role as an Data Engineer Manager, you will be responsible for expanding and optimizing data and pipeline architectures, and for optimizing data collection and flow across functional teams. Your responsibilities include assisting software developers, database architects, data analysts, and data scientists with data initiatives and ensuring a consistent data delivery architecture is put in place throughout ongoing projects.

They will work hand in hand with Project/Program Managers and Product Owners to ensure the project is delivered on time, on budget, while fulfilling quality-related best practices.


Job Description

  • Bachelor's degree in Computer Science, Information Systems, or a related field.

  • You’ll have 7+ years of hands-on experience of data analytics solutions On premise (Informatica)

  • Assure that data is cleansed, mapped, transformed, and otherwise optimized for storage and use according to business and technical requirements

  • Develop and maintain innovative Analytics solutions

  • Solution design using Microsoft Stack and other tools

  • The ability to automate tasks and deploy production standard code (with unit testing, continuous integration, versioning etc.)

  • Load transformed data into storage and reporting structures in destinations including data warehouse, high speed indexes, real-time reporting systems and analytics applications

  • Build data pipelines to collectively bring together data

  • Other responsibilities include extracting data, troubleshooting and maintaining the data warehouse

  • Gather requirements from stakeholders and translate them into technical specifications.

  • Modern data lakes and data warehouse solutions.

  • Experience in adapting your communication style to help translate complex technical information to audiences unfamiliar with the technologies

     

  • Strong hands-on experience on implementing modern data platform solutions

  • Experience supporting and working with cross-functional teams in a dynamic environment

  • Capable of leading data initiatives and communicate clearly with business stakeholders

  • Ability to work efficiently without supervision

  • Experience building and optimizing data pipelines, architectures and data sets

  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement

  • Build processes supporting data transformation, data structures, metadata, dependency and workload management

  • Technical aspects of Data Governance including glossary, metadata, data quality, master data management & data lifecycle management

  • Overseeing the technical delivery team and make sure team delivers up to quality and according to plan

  • Databases knowledge : Must know SQL/NoSQL ,Azure Synapse/SQL DW , SQL Database and SQL Server , Optional Cosmos DB , Oracle ..etc

  • Data Pipeline : Must know SSIS and Data Factory/Data Bricks , and preferably Informatica for ETL pipelines development

  • Cloud Data providers : Must know Azure , good to know AWS or GCP

  • Practical experience with Visualization and Reporting tools such as Tableau,  Power BI and Excel (Power Pivot)

  • Nice to know Big Data (Hadop) and stream processing tools like Kafka , Azure Event Hub , Spark Streaming

  • Nice to have some Machine Learning and AI knowledge 

  • Worked with DevOps/ DataOps 

  • Worked with CI/CD frameworks

  • Task tracking tools, such as TFS and JIRA

Additional Job Description

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

  •  Overseeing the design and delivery of data analytics projects with customers

  •  Foundational understanding of Data & Analytics Architectures, definition of KPIs / metrics and insight requirements

  • Practical knowledge of core data modeling, manipulation and visualization skills

  • Translating business requirements into technical specifications, helping to understand and create solutions to our clients key challenges.

  • Analysis of business functionality and needs, translating them into technical requirements and solution designs

  • Creation of relational data models based on reporting requirements and raw base data

  • Experience building and optimizing data pipelines, architectures and data sets

  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement

  • Standard approaches for data cleansing and ensuring data quality

  • Technical aspects of Data Governance including glossary, metadata, data quality, master data management & data lifecycle management

  • Ability to execute regular work review and coaching of team members

  • Engage in collaborating with our wider Technology, Data and Analytics 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

  • Participate in leading initiatives to grow our business through the creation of new innovative solutions and propositions as well as relevant thought leadership.   

Certifications : 

  • Nice to have Microsoft Azure Data engineer Associate Certificate or Microsoft Azure Data Fundamentals 

  • Mandatory Microsoft Certified in Power BI Data Analyst Associate

Travel Requirements : 75%

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: Agile Architecture AWS Azure Big Data Business Intelligence CI/CD Computer Science Cosmos DB Data Analytics Databricks Data governance Data management DataOps Data pipelines Data quality Data warehouse DevOps ETL Excel GCP Informatica Jira Kafka KPIs Machine Learning NoSQL Oracle Pipelines Power BI Spark SQL SSIS Streaming Tableau Testing

Perks/benefits: Career development Travel

Region: Middle East
Country: Egypt

More jobs like this