ETIC Data Engineer Senior Associate - PwC

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

• Bachelors degree in Computer Science Information Systems or a related field.

• Youll have 3 years of handson 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 realtime 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 largescale 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 decisionmaking

• 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 endtoend planning coordination and oversight of the project lifecycle including resourcing scoping architecting and delivery Developing client relationships including with Clevel 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 Clevel 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