Senior Data Engineer - AMG Tech

PNC • Strongsville, OH

9d • $50,000 - $202,800 • Onsite

About The Position

At PNC, employees work together to deliver strong customer experiences in an inclusive workplace. This Senior Data Engineer role is within PNC’s Asset Management organization and is based in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; or Dallas, TX. The position partners closely with a Lead to design, build, and support scalable data solutions, with hands-on work in data engineering, governance, and modeling in a modern data environment. PNC describes the role as an in-office position.

The role leads development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements. It uses technical knowledge and industry experience to design, build, and maintain technology solutions; leads data requirement analysis and preparation processes; and leads the design and construction of data-service infrastructure across multiple platforms. It also oversees solution scalability, availability, and maintainability, and consults on data migration and transformation to support data accuracy and security.

The role is incentive eligible. PNC states that employment visa sponsorship and STEM OPT participation are not available for this position.

Requirements

• Strong experience in data warehousing, data modeling, and SQL.
• Knowledge of source-to-target mapping, DDL, SCD types, and naming standards across Oracle and Hadoop.
• Experience working across cross-functional teams.
• Understanding of data governance principles.
• Roles at this level typically require a university or college degree and 5+ years of industry-relevant experience; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
• Successful candidates must demonstrate appropriate knowledge, skills, and abilities for the role.

Nice To Haves

• Analytical thinking.
• Competitive advantages.
• Data analytics.
• Data mining.
• Data science.
• Machine learning (ML).

Responsibilities

• Design and build data warehouse solutions, including pipelines, models, and transformations.
• Support data governance practices, including data quality, lineage, and compliance.
• Create and maintain source-to-target mappings, DDL documentation, and SCD models.
• Contribute to metadata management and documentation using tools such as Alation.
• Collaborate with engineers, BSA’s, QE, and reporting teams to deliver aligned data solutions.
• Support migration and modernization efforts, including legacy rationalization.
• Participate in cross-functional initiatives, releases, and code reviews.
• Troubleshoot data issues and perform root cause analysis.
• Lead development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements.
• Lead data requirement analysis and development of data preparation processes for targeted data solutions.
• Lead the design and building of data-service infrastructure across multiple data platforms according to workflow.
• Oversee development and implementation of data solutions to ensure scalability, availability, and maintainability.
• Consult on data migration and transformation to ensure data accuracy and security.
• Focus on customer needs and satisfaction when making business decisions and creating customer solutions.
• Assess and manage risks associated with business objectives and activities in support of PNC’s Enterprise Risk Management Framework.

Benefits

• Medical and prescription drug coverage, with a Health Savings Account feature, subject to eligibility.
• Dental and vision options, subject to eligibility.
• Employee and spouse/child life insurance, subject to eligibility.
• Short- and long-term disability protection, subject to eligibility.
• 401(k) with PNC match.
• Pension and stock purchase plans.
• Dependent care reimbursement account.
• Back-up child and elder care.
• Adoption, surrogacy, and doula reimbursement.
• Educational assistance, including select fully paid programs.
• Wellness program with financial incentives.
• Maternity and/or parental leave, depending on eligibility.
• Up to 11 paid holidays each year, depending on eligibility.
• 9 occasional absence days each year, unless otherwise required by law, depending on eligibility.
• Between 15 and 25 vacation days each year, depending on career level and eligibility.
• Incentive compensation based on company, business, and/or individual performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior