Data Engineer Senior Data Modeling
Pittsburgh, PA - USA
Job Summary
Why This Job Matters
This role is responsible for building the data foundation that powers reporting analytics and strategic decision-making across the organization. By designing scalable and reliable data models the Senior Data Engineer ensures that business leaders and teams can trust the data they use to drive growth improve customer experience and support innovation.
What Youll Do
-Design and build data warehouse solutions including pipelines models and transformations.
-Support data governance practices (quality lineage compliance).
-Create and maintain source-to-target mappings DDL documentation and SCD models.
-Contribute to metadata management and documentation using tools like Alation.
-Collaborate with engineers BSAs 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.
Preferred Experience
-Experience working across cross-functional teams.
-Understanding of data governance principles.
Technical Skills
-Strong experience in data warehousing modeling and SQL.
-Knowledge of Source-to-Target Mapping DDL SCD types and naming standards both Oracle and Hadoop.
Why PNC
PNC is an attractive employer because it offers the stability and resources of one of the nations leading financial institutions while continuing to invest in innovation technology and employee growth. Employees can work on meaningful initiatives that impact millions of customers and businesses across the country while also benefiting from a culture that values collaboration inclusion and professional development. PNC provides opportunities for career advancement through internal mobility leadership development and continuous learning allowing employees to build long-term careers across a variety of disciplines. For technology and data professionals in particular PNC offers the chance to work on large-scale enterprise-wide projects involving data analytics cloud technologies and digital transformation. Employees can make a tangible impact by helping improve customer experiences support business decision-making strengthen risk management practices and drive innovation across the organization all while contributing to PNCs purpose of helping clients communities and employees move forward financially.PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals.PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
- Leads in developing supporting and implementing data solutions for multiple applications in order to meet business objectives and user requirements. Leverages technical knowledge and industry experience to design build and maintain technology solutions.
- Leads data requirement analysis and the data preparation process development for targeted data solutions.
- Leads in designing and building data service infrastructure on multiple data platforms according the workflow.
- Oversees the development and implementation of data solutions for multiple applications to ensure its scalability availability and maintainability.
- Consults on data migration and transformation to ensure the accuracy and security of data solutions.
PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:
- Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
- Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNCs Enterprise Risk Management Framework.
Successful candidates must demonstrate appropriate knowledge skills and abilities for a role. Listed below are skills competencies work experience education and required certifications/licensures needed to be successful in this position.
To learn more about these and other programs including benefits for full time and part-time employees visit.
If an accommodation is required to participate in the application process please contact us via email at . Please include accommodation request in the subject line title and be sure to include your name the job ID and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call and say Workday for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.
At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.
PNC provides equal employment opportunity to qualified persons regardless of race color sex religion national origin age sexual orientation gender identity disability veteran status or other categories protected by law.
This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and for any registered role the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA) which prohibit the hiring of individuals with certain criminal history.
Required Experience:
Senior IC