0

ETIC, Data Engineer, Senior Associate

024 PwC IT Services Egypt LLC
Full-time
Remote friendly

Line of Service

Advisory

Industry/Sector

Technology

Specialism

Advisory - Other

Management Level

Senior Associate

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, 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.


Job Description

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

  • You’ll have 3+ years of hands-on experience of data analytics solutions on cloud platforms with a minimum of 2 years using Microsoft Stack (Onpremise)

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

  • Develop and maintain innovative Azure 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

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

  • Functional and technical design of DW (star schema and snowflakes)

  • Advanced working experience in dimensional data modeling, data model optimization and model performance tuning

  • Build and verify new data models that aid decision-making

  • Capable of collaborating with Team Leads in understanding and contributing to the technical solution from design through implementation level

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

  • Worked with DevOps/ DataOps

  • Worked with CI/CD frameworks

  • Task tracking tools, such as TFS and JIRA

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.

•Excellent spoken and written English skills, with ability to communicate clearly and concisely with QA, other developers and Team Lead

•Follow defined methodology and standards including preparation and maintenance of documentation for all stages of an Analytics project execution

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

This job is closed.