Data Engineer - Specialist - Operate
Bangalore (SDC) - Bagmane Tech Park
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
Not ApplicableSpecialism
Managed ServicesManagement Level
SpecialistJob 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: Senior Associate – Data Engineer
Tower: Data Analytics & Insights Managed Service
Experience: 1 - 3 years
Key Skills: Data Engineering
Educational Qualification: Bachelor's degree in computer science/IT or relevant field
Work Location: Bangalore AC
Job Description
As a Managed Services - Data Engineer Senior Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution by using Data, Analytics & Insights Skills. PwC Professional skills and responsibilities for this management level include but are not limited to:
- Use feedback and reflection to develop self-awareness, personal strengths, and address development areas.
- Proven track record as an SME in chosen domain.
- Mentor Junior resources within the team, conduct KSS and lessons learnt.
- Flexible to work in stretch opportunities/assignments.
- Demonstrate critical thinking and the ability to bring order to unstructured problems.
- Ticket Quality and deliverables review.
- Status Reporting for the project.
- Adherence to SLAs, experience in incident management, change management and problem management.
- Review your work and that of others for quality, accuracy, and relevance.
- Know how and when to use tools available for a given situation and can explain the reasons for this choice.
- Seek and embrace opportunities which give exposure to different situations, environments, and perspectives.
- Use straightforward communication, in a structured way, when influencing and connecting with others.
- Able to read situations and modify behavior to build quality relationships.
- Uphold the firm's code of ethics and business conduct.
- Demonstrate leadership capabilities by working with clients directly and leading the engagement.
- Work in a team environment that includes client interactions, workstream management, and cross-team collaboration.
- Good Team player. Take up cross competency work and contribute to COE activities.
- Escalation/Risk management.
Position Requirements:
Required Skills:
Primary Skill: ETL/ELT, SQL, SSIS, SSMS, Informatica, Python
Secondary Skill: Azure/AWS/GCP (preferable anyone), Power BI, Advance Excel, Excel Macro
Data Ingestion Senior Associate:
- 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, SSIS, SSMS, AWS, Azure, ADF, GCP, Snowflake, Spark, SQL, Python etc.
- Should have Hands-on experience with Data analytics tools like Informatica, Hadoop, Spark 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.
- Should have experience in creating visually impactful dashboards in Tableau for data reporting. Extract, interpret and analyze data to identify key metrics and transform raw data into meaningful, actionable information.
- Good understanding of formulas / DAX, Measures, Establishing hierarchies, Data refresh, Row/column/report level security, Report governance, complex visualizations, level of detail (LOD) expressions etc.
- Ability to create and replicate functionalities like parameters (for top fields, sheet switching), interactive buttons to switch between dashboards, burger menus etc.
- Participate in requirement gathering with business and evaluate the data as per the requirement. Coordinate and manage data analytics & Reporting activities with stakeholders.
- Expertise in writing and analyzing complex SQL queries. Excellent problem solving, design, debugging, and testing skills, Competency in Excel (macros, pivot tables, etc.)
- Good to have minimum 5 years’ hands on Experience of delivering Managed Data and Analytics programs (Managed services and Managed assets)
- Should have Strong communication, problem solving, quantitative and analytical abilities.
- Effectively communicate with project team members and sponsors throughout the project lifecycle (status updates, gaps/risks, roadblocks, testing outcomes)
Nice to have:
- Certification in any cloud platform
- Experience in Data ingestion technology by using any of the industry tools like Informatica, Talend, DataStage, 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 SpecifiedAvailable for Work Visa Sponsorship?
NoGovernment Clearance Required?
YesJob Posting End Date
November 22, 2024* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: AWS Azure Business Intelligence CloudFormation Computer Science Data Analytics Data management Data pipelines Data Warehousing EC2 ELT Engineering ETL Excel GCP Google Cloud Hadoop Informatica Lambda Pipelines Power BI Privacy Python Security Snowflake Spark SQL SSIS Tableau Talend Terraform Testing
Perks/benefits: Career development Flex hours Team events
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.