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.Line of Service
AdvisoryIndustry/Sector
TechnologySpecialism
Advisory - OtherManagement Level
ManagerJob 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 SpecifiedAvailable for Work Visa Sponsorship?
NoGovernment Clearance Required?
NoJob Posting End Date
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
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
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.