15 days ago
Lakewood, CO, USASenior
Base Salary
$91k - $186k/yr
Responsibilities
- Develop, support, and implement data solutions for multiple applications.
- Analyze data requirements and develop data preparation processes.
- Design and build scalable, available, and maintainable data service infrastructure across multiple data platforms.
- Develop data models, ETL/ELT frameworks, validation strategies, reconciliation processes, and automated data-quality testing.
- Optimize database queries, resource usage, processing performance, incremental loads, and pipeline operations.
- Implement and manage workflows and task dependencies using Cron, Airflow, and Kafka.
- Maintain production processes, troubleshoot pipeline failures, and support incident response, root-cause analysis, and postmortems.
- Consult on data migration and transformation to ensure data accuracy and security.
- Define coding standards, lead code reviews, mentor engineers, and support delivery without accumulating technical debt.
Requirements
- Bachelor's degree is required.
- 5+ years of industry-relevant experience is typically required.
- Advanced Python development skills, including clean, reusable, and maintainable code and software engineering standards.
- Expertise with Oracle SQL, database execution, indexing, schema design, and query optimization.
- Experience with ETL/ELT patterns and frameworks, including developing custom solutions.
- Experience with data quality, validation, reconciliation, and automated testing strategies.
- Experience designing pipeline-state tracking, failure management, incremental loads, and operational metadata logging.
- Advanced experience with Cron, Airflow, and Kafka for programmatic workflow orchestration.
- Understanding of reliability engineering, incident response, root-cause analysis, postmortems, production support, DevOps, and CI/CD pipelines.
- Experience with Git and Linux-based remote development environments.
- Experience defining coding practices, conducting code reviews, mentoring engineers, and balancing engineering quality with business delivery.
- Preferred skills include analytical thinking, data analytics, data mining, data science, machine learning, Python, and SQL.
Benefits
- PNC offers medical and prescription drug coverage, dental and vision options, life insurance, short- and long-term disability protection, 401(k) matching, pension, stock purchase plans, dependent care reimbursement, backup child and elder care, adoption/surrogacy/doula reimbursement, educational assistance, and wellness programs.
- Paid time off may include parental leave, up to 11 paid holidays, 9 occasional absence days, and 15 to 25 vacation days depending on eligibility and career level.
- The role is in-office and may be based in Denver, Phoenix, Birmingham, Dallas, Pittsburgh, or Cleveland.
- The posting was generally expected to remain open for two business days from September 14, 2026, subject to business discretion.
Tech Stack
Categories
Data Engineering
About PNC
PNC is a U.S. bank offering retail, business, and corporate banking, including checking, savings, credit cards, mortgages, auto loans, and wealth management. It earns revenue from interest income and fees across consumer, small-business, and institutional clients, and provides digital and branch services nationwide. Headquartered in Pittsburgh, it is a public company listed on the NYSE.