ETIC, Azure Data Engineer, Senior Associate
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Line of Service
Industry/Sector
Specialism
Management Level
Senior AssociateJob Description & Summary
At PwC our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in transforming raw data into actionable insights enabling informed decision-making and driving business growth.In data engineering at PwC you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis. You will be responsible for developing and implementing data pipelines data integration and data transformation solutions.
Data Engineer:
Job Description:
Were looking for a versatile Data Engineer whos equally comfortable building data pipelines as they are digging into complex SQL queries and supporting ad hoc data needs. This role straddles the line between engineering and analytics requiring someone who thrives on solving business problems through data and has a strong grasp of relational databases data modeling and hands-on data play a key role in maintaining data accuracy across systems supporting stakeholders with one-off data needs and making targeted updates directly in production databases.
Responsibilities:
- Write SQL queries to extract analyze and transform data for business reporting or internal use.
- Create and execute ad hoc insert update and delete scripts in complex relational databases.
- Partner with analysts product managers and business stakeholders to fulfill one-off data requests and generate insights.
- Ensure data integrity and accuracy when performing manual interventions or debugging data issues.
- Collaborate with engineering teams to optimise database structure and improve data quality.
- Document queries data structures and one-off scripts for transparency and repeatability.
- Design develop and maintain data pipelines and ETL/ELT processes in Azure Cloud environments (Data Factory / Logic Apps / Synapse / Databricks)
Requirements:
- 5 years of experience in data engineering analytics or database administration roles.
- Strong proficiency in SQL (including CTEs window functions subqueries).
- Basic proficiency in Python for maintaining and updating existing ETL processes.
- Deep understanding of relational database systems.
- Experience writing safe efficient data modification scripts for use in production environments.
- Strong communication skills able to explain technical data issues to non-technical stakeholders.
- Excellent problem-solving and analytical skills.
- Strong attention to detail and ability to work in a fast-paced environment.
Nice to haves:
- Experience working with Azure cloud platforms such as Data Factory Logic Apps Synapse etc.
- Experience working with Azure App Insights to identify and resolve application errors resulting from data quality issues.
- Basic proficiency to enhance investigation into errors within the applications.
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
Azure Logic Apps Data Pipelines Microsoft Azure Microsoft Cloud Python (Programming Language) Structured Query Language (SQL)Optional Skills
Accepting Feedback Accepting Feedback Active Listening Agile Scalability Amazon Web Services (AWS) Analytical Thinking Apache Airflow Apache Hadoop Azure Data Factory Communication Creativity Data Anonymization Data Architecture Database Administration Database Management System (DBMS) Database Optimization Database Security Best Practices Databricks Unified Data Analytics Platform Data Engineering Data Engineering Platforms Data Infrastructure Data Integration Data Lake Data Modeling Data Pipeline 27 moreDesired Languages (If blank desired languages not specified)
Travel Requirements
Available for Work Visa Sponsorship
Government Clearance Required
Job Posting End Date
Required Experience:
Senior IC
Employment Type
Full-Time
