Data Engineer - Specialist - Operate

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Managed Services

Management Level

Specialist

Job Description & Summary

A career in our Managed Services team will provide you an opportunity to collaborate with a wide array of teams to help our clients implement and operate new capabilities, achieve operational efficiencies, and harness the power of technology.

Our Managed Data, Analytics & Insights team will provide you with the opportunity to help organizations harness the power of their enterprise data/analytics solutions by optimizing the technology while driving innovation to increase business outcomes and through data insights. We assist our clients in capitalizing on technology improvements, implementing new capabilities and achieving operational insights by managing, maintaining and evolving their analytics platforms and ecosystems. We help our clients maximize the value of their investment focusing on continuous improvement of their analytics solutions such as Microsoft, Amazon Web Services and Google Cloud.

Role: Specialist

Experience: 1 - 3 years

Key Skills: Data Engineering

Educational Qualification: Bachelor's degree in computer science/IT or relevant field

Work Location: Bangalore, India

Position Requirements:

Required Skills:

Primary Skill: ETL/ELT, SQL, Informatica, Python

Secondary Skill: Azure/AWS/GCP, Talend, DataStage, etc.

Data Engineer:

• Should have minimum 1 years of Operate/Managed Services/Production Support Experience
• Should have extensive experience in developing scalable, repeatable, and secure data structures and pipelines to ingest, store, collect, standardize, and integrate data that for downstream consumption like Business Intelligence systems, Analytics modelling, Data scientists etc.
• Designing and implementing data pipelines to extract, transform, and load (ETL) data from various sources into data storage systems, such as data warehouses or data lakes.
• Should have experience in building efficient, ETL/ELT processes using industry leading tools like Informatica, Talend, SSIS, SSRS, AWS, Azure, ADF, GCP, Snowflake, Spark, SQL, Python etc.
• Should have Hands-on experience with Data analytics tools like Informatica, Collibra, Hadoop, Spark, Snowflake etc.
• Monitoring and troubleshooting data pipelines and resolving issues related to data processing, transformation, or storage.
• Implementing and maintaining data security and privacy measures, including access controls and encryption, to protect sensitive data.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Scaling and optimizing schema and performance tuning SQL and ETL pipelines in data lake and data warehouse environments.
• Should have Experience of ITIL processes like Incident management, Problem Management, Knowledge management, Release management, Data DevOps etc.
• Should have Strong communication, problem solving, quantitative and analytical abilities.

Nice to have:

• Certifications in Cloud Technology is an added advantage.
• Experience in Visualization tools like Power BI, Tableau, Qlik, etc.

Managed Services- Data, Analytics & Insights

At PwC we relentlessly focus on working with our clients to bring the power of technology and humans together and create simple, yet powerful solutions. We imagine a day when our clients can simply focus on their business knowing that they have a trusted partner for their IT needs. Every day we are motivated and passionate about making our clients’ better. 

Within our Managed Services platform, PwC delivers integrated services and solutions that are grounded in deep industry experience and powered by the talent that you would expect from the PwC brand. The PwC Managed Services platform delivers scalable solutions that add greater value to our client’s enterprise through technology and human-enabled experiences.  Our team of highly skilled and trained global professionals, combined with the use of the latest advancements in technology and process, allows us to provide effective and efficient outcomes.  With PwC’s Managed Services our clients are able to focus on accelerating their priorities, including optimizing operations and accelerating outcomes.  PwC brings a consultative first approach to operations, leveraging our deep industry insights combined with world class talent and assets to enable transformational journeys that drive sustained client outcomes. Our clients need flexible access to world class business and technology capabilities that keep pace with today’s dynamic business environment.  

Within our global, Managed Services platform, we provide Data, Analytics & Insights Managed Service where we focus more so on the evolution of our clients’ Data, Analytics, Insights and cloud portfolio. Our focus is to empower our clients to navigate and capture the value of their application portfolio while cost-effectively operating and protecting their solutions. We do this so that our clients can focus on what matters most to your business: accelerating growth that is dynamic, efficient and cost-effective.  

As a member of our Data, Analytics & Insights Managed Service team, we are looking for candidates who thrive working in a high-paced work environment capable of working on a mix of critical Application Evolution Service offerings and engagement including help desk support, enhancement and optimization work, as well as strategic roadmap and advisory level work.  It will also be key to lend experience and effort in helping win and support customer engagements from not only a technical perspective, but also a relationship perspective.

Job Summary -   

A career in our Managed Services team will provide you with an opportunity to collaborate with a wide array of teams to help our clients implement and operate new capabilities, achieve operational efficiencies, and harness the power of technology. Our Data, Testing & Analytics as a Service team brings a unique combination of industry expertise, technology, data management and managed services experience to create sustained outcomes for our clients and improve business performance. We empower companies to transform their approach to analytics and insights while building your skills in exciting new directions. Have a voice at our table to help design, build and operate the next generation of software and services that manage interactions across all aspects of the value chain. 

 

Minimum Degree Required (BQ) *:  

Bachelor's degree  

 

Degree Preferred:   

Required Field(s) of Study (BQ):   

 

Preferred Field(s) of Study:  

Computer and Information Science, Management Information Systems 

  

Minimum Year(s) of Experience (BQ) *: US 

Minimum of 1 year of experience 

 

Certification(s) Preferred: 

 

Preferred Skills (PQs): 

 

We are looking for skilled AWS and Snowflake Production Support Specialists to join our dynamic IT team. In these roles, you will be responsible for ensuring the availability, performance, and security of our AWS cloud infrastructure and Snowflake data platform. You will play a critical role in monitoring, troubleshooting, and resolving incidents to minimize downtime and support our business operations. 

Responsibilities: 

• AWS Infrastructure Management: 

• Monitor and manage AWS cloud resources such as EC2 instances, S3 buckets, RDS databases, and Lambda functions. 

• Configure and optimize AWS services for scalability, reliability, and cost-efficiency. 

• Implement infrastructure as code (IaC) using tools like CloudFormation or Terraform. 

• Snowflake Data Platform Support: 

Monitor and maintain Snowflake data warehouses and data pipelines. 

Perform performance tuning and optimization of Snowflake queries and data loading processes. 

• Incident Management: 

Respond to alerts and incidents related to AWS and Snowflake environments. 

Diagnose and troubleshoot issues, collaborating with internal teams and vendors as needed. 

Implement and document resolutions and preventive measures. 

• Backup and Disaster Recovery: 

Design and implement backup strategies for AWS resources and Snowflake data. 

Test and maintain disaster recovery plans to ensure business continuity. 

• Security and Compliance: 

Implement and enforce AWS and Snowflake security best practices. 

Conduct regular security assessments and audits to ensure compliance with industry standards and regulations. 

• Change Management: 

Coordinate and execute changes to AWS and Snowflake configurations following change management processes. 

Manage scheduled maintenance activities, patches, and updates. 

• Collaboration and Communication: 

Collaborate effectively with development teams, infrastructure teams, and business stakeholders to support application deployments and releases. 

Communicate effectively with internal teams and external vendors, including AWS and Snowflake support. 

Qualifications: 

• Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience). 

• Proven experience in AWS cloud infrastructure management and Snowflake data platform administration. 

• Strong knowledge of AWS services (EC2, S3, RDS, Lambda, etc.) and Snowflake features (warehouses, data loading, security). 

• Experience with infrastructure as code and automation tools. 

• Familiarity with data warehousing concepts, ETL processes, and SQL querying. 

• Experience in incident management, troubleshooting, and root cause analysis. 

• Solid understanding of cloud security best practices and compliance requirements. 

• Excellent communication and collaboration skills, with the ability to work effectively in a team environment. 

  

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?

Yes

Job Posting End Date

November 15, 2024