Data Engineer Senior - Data Modeling

PNC•Strongsville, OH

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

About The Position

As a Data Engineer Senior within PNC’s Asset Management Group organization, you will design, build, and support scalable data solutions in a hands-on role focused on data engineering, governance, and modeling. You will partner closely with a Lead and collaborate with engineers, BSA’s, QE, and reporting teams. The role is based in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; or Phoenix, AZ, and PNC identifies itself as an in-office company. The position leads development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements. It includes leading data requirement analysis and data preparation processes; designing and building data service infrastructure across data platforms; overseeing solutions for scalability, availability, and maintainability; and consulting on data migration and transformation to ensure accuracy and security. The team supports the technology and data that power Asset Management Group operations and helps make critical information accurate, accessible, and reliable for business users, advisors, operations teams, and leadership.

Requirements

University or college degree, typically, with 5 or more years of industry-relevant experience; a comparable combination of education, job-specific certifications, and experience, including military service, may be considered in lieu of a degree.
Demonstrated appropriate knowledge, skills, and abilities for the role.
Experience working across cross-functional teams.
Understanding of data governance principles.
Bachelor’s degree listed under Education.
No required certifications.
No required licenses.

Nice To Haves

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.
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 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 the accuracy and security of data solutions.
Assess and manage risks associated with business objectives and activities in support of PNC’s Enterprise Risk Management Framework.
Apply customer needs and satisfaction as primary considerations in business decisions and customer solutions.

Benefits

Medical and prescription drug coverage, with a Health Savings Account feature, for eligible employees.
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, 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.
15 to 25 vacation days each year depending on career level and years of service, subject to eligibility.
Incentive-eligible compensation based on company, business, and/or individual performance.