Enterprise Data Operations Analyst (Senior) / Data Analyst Senior - (SQL, AI Tools, Agile, Jira)
PNC · Lakewood, CO
- On site
- Full-time
- $150,000 / year
- Lakewood, CO
Job highlights
- Support Enterprise Data Warehouse and downstream consumers.
- Focus on data quality, production support, and PII compliance.
- Collaborate with cross-functional teams for data integrity.
- Develop strategies for data implementation and management.
- Utilize SQL, AI tools, Agile, and Jira.
About the role
About the Role
At PNC, we believe our people are our greatest differentiator and competitive advantage. We are united in delivering the best experience for our customers and fostering an inclusive workplace where all employees feel respected, valued, and have an opportunity to contribute to the company’s success.
Position Overview
As a Senior Data Analyst within PNC's Data Operations organization, you will play a crucial role in supporting the Enterprise Data Warehouse (EDW) and downstream regulatory, analytics, and reporting consumers. This position focuses on data quality, production support, release readiness, PII compliance, and cross-team coordination across key Commercial source systems. You will be highly collaborative and operational, with a strong emphasis on ensuring data flows accurately and predictably to various teams.
Key Responsibilities
- Manage and develop information systems for clients, conducting data information analysis for various studies under organizational standards.
- Develop strategies for data implementation, data acquisition, and archive recovery.
- Advise business, applications, and operations counterparts to ensure data integrity and availability.
- Structure the environment and create logical storage units, mapping database elements into logical units.
- Implement and support technologies for managing and effectively utilizing multiple information sources, formats, and uses.
- Resolve data integration and security issues to ensure adherence to the organization's quality standards.
- Research customer needs and conduct awareness and promotional sessions for potential customers.
- Advise end-users on data manipulation, end-user support systems, and statistical analysis.
- Select new information sources and acquire stock; catalog and index new materials.
Company Culture and Values
PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We expect our employees to be:
- Customer Focused: Prioritize customer needs and satisfaction in all business decisions and leverage that information for customized solutions.
- Managing Risk: Assess and effectively manage risks associated with business objectives and activities to adhere to PNC's Enterprise Risk Management Framework.
Qualifications
Successful candidates will demonstrate appropriate knowledge, skills, and abilities.
- Education: Bachelors degree (or equivalent experience).
- Work Experience: 3+ years of relevant/direct industry experience.
- Preferred Skills: Analytical Thinking, Competitive Advantages, Data Analytics, Data Mining, Data Science, Machine Learning (ML), Project Management, Scrum, Structured Query Language (SQL).
- Competencies: Application Design, Architecture, Business Intelligence, Data Architecture, Data Mining, Emerging Technologies, Informatics/Information Sciences, Information Management, IT Environment, Modeling (Data, Process, Events, Objects), Requirements Analysis.
Pay and Benefits
Base Salary: $75,000.00 – $150,000.00. Salaries may vary based on location, market data, skills, experience, and education. This role is incentive eligible.
PNC offers a comprehensive benefits package including medical, dental, vision, life insurance, disability protection, 401(k) with match, pension, stock purchase plans, dependent care reimbursement, wellness programs, and paid time off (maternity/parental leave, holidays, occasional absence days, vacation days).
Key skills/competency
- Data Analysis
- SQL
- Data Quality
- Production Support
- Data Operations
- Enterprise Data Warehouse
- Regulatory Reporting
- PII Compliance
- Agile Methodologies
- Jira
Skills & topics
- Data Analyst
- Data Operations
- Enterprise Data Warehouse
- SQL
- Data Quality
- Production Support
- PII Compliance
- Agile
- Jira
- Analytics
How to get hired
- Tailor your resume: Highlight your experience with SQL, data quality, and production support relevant to enterprise data operations.
- Showcase collaboration: Emphasize your ability to work with cross-functional teams and advise business counterparts.
- Demonstrate technical skills: Include specific examples of using AI tools, Agile methodologies, and Jira in your previous roles.
- Understand PNC's values: Align your application and interview responses with PNC's focus on customer centricity and risk management.
- Prepare for technical questions: Be ready to discuss data analysis, data mining, and data architecture concepts.
Technical preparation
Master SQL for data querying and manipulation.,Practice using AI tools for data analysis.,Familiarize with Agile and Jira workflows.,Understand data warehouse concepts and support.
Behavioral questions
Describe a time you ensured data quality under pressure.,How do you collaborate with different teams?,Share an experience resolving data integration issues.,How do you stay updated on emerging tech?
Frequently asked questions
- What is the primary focus of the Senior Enterprise Data Operations Analyst role at PNC?
- The Senior Enterprise Data Operations Analyst role at PNC primarily focuses on supporting the Enterprise Data Warehouse (EDW) and ensuring the accuracy and predictability of data flow to regulatory, analytics, and reporting teams. Key responsibilities include data quality, production support, PII compliance, and cross-team coordination.
- What are the key technical skills required for the Senior Enterprise Data Operations Analyst position?
- Key technical skills for this role include strong proficiency in Structured Query Language (SQL), experience with AI tools, familiarity with Agile methodologies, and proficiency in using Jira for project management. A background in Data Analytics, Data Mining, and understanding of Machine Learning (ML) is also beneficial.
- What is the expected work experience for this Senior Data Analyst role at PNC?
- PNC typically requires a university or college degree with at least 3 years of relevant, direct industry experience for roles at this level. In lieu of a degree, a comparable combination of education, job-specific certifications, and experience, including military service, may be considered.
- What is the salary range for the Senior Enterprise Data Operations Analyst at PNC?
- The base salary range for this position is $75,000.00 to $150,000.00 annually. Actual salaries may vary based on geographic location, market data, and individual skills, experience, and education. The role is also incentive eligible.
- Does PNC offer sponsorship for this Senior Data Analyst role?
- No, PNC will not provide sponsorship for employment visas or participate in STEM OPT for this specific position.
- How does PNC foster an inclusive workplace for employees in data operations roles?
- PNC fosters an inclusive workplace by emphasizing that all employees are united in delivering the best customer experience and by promoting a culture where everyone feels respected, valued, and has opportunities to contribute to the company’s success. They also provide resources like pncthrive.com for benefits information.
- What are the main competencies expected from a Senior Enterprise Data Operations Analyst at PNC?
- Key competencies for this role include expertise in Application Design, Architecture, Business Intelligence, Data Architecture, Data Mining, Emerging Technologies, Informatics/Information Sciences, Information Management, IT Environment, Data Modeling, Process Modeling, and Requirements Analysis.
Similar roles
Open positions we recommend based on this role.