Data Engineer Senior - Data Modeling

PNC•Strongsville, OH

3d•$91,000 - $185,900•Onsite

About The Position

At PNC, employees work together to deliver a strong customer experience and foster an inclusive workplace. This Senior Data Engineer role is part of PNC's Asset Management Group and is based in Pittsburgh, Pennsylvania; Birmingham, Alabama; Cleveland, Ohio; Dallas, Texas; or Phoenix, Arizona. PNC describes itself as an in-office company and encourages candidates to discuss workplace expectations with the recruiter and hiring manager. The role partners closely with a Lead to design, build, and support scalable data solutions, with hands-on work in data engineering, governance, and modeling. It leads development, support, and implementation of data solutions for multiple applications, analyzes data requirements, develops data preparation processes, and builds data service infrastructure across platforms. The position also oversees solution scalability, availability, and maintainability; consults on data migration and transformation; and supports governance, documentation, modernization, and troubleshooting. Candidates should have a bachelor's degree and typically at least five years of industry-relevant experience. A comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree. No certifications or licenses are required. The position is incentive eligible, with payment based on company, business, and/or individual performance. PNC will not provide employment visa sponsorship or participate in STEM OPT 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 in Oracle and Hadoop environments.
Experience working across cross-functional teams.
Understanding of data governance principles.
Typically, 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.
Appropriate knowledge, skills, and abilities for the role.

Nice To Haves

Skills in Big Data, data architecture development, database management, data engineering, data governance, data migrations, data modeling, data pipelines, data warehousing, and SQL.
Competencies in application delivery processes, Big Data management and analytics, business intelligence, consulting, software-based data analysis, data architecture, database structures, problem solving, and the software development life cycle.

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 build of data service infrastructure on 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 solution accuracy and security.
Focus on customer needs and satisfaction in business decisions and customized customer solutions.
Assess and manage risks associated with business objectives and activities in alignment with PNC's Enterprise Risk Management Framework.

Benefits

Medical and prescription drug coverage, including a Health Savings Account feature, subject to eligibility.
Dental and vision options.
Employee and spouse/child life insurance.
Short- and long-term disability protection.
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, subject to eligibility.
Up to 11 paid holidays each year, subject to eligibility.
9 occasional absence days each year, unless otherwise required by law.
Between 15 and 25 vacation days each year, depending on career level and eligibility.
Incentive-eligible compensation based on company, business, and/or individual performance.