Data Engineer Senior (PythonSQL)
Denver, CO - USA
Job Summary
An ideal candidate will have:
Advanced Python Mastery & Software Engineering
oExpertise writing clean reusable and maintainable python code.
oStrict adherence to software engineering standards patterns and architectures.
oDeep familiarity with Git usage and context including guiding complex operations and
oExperiencing managing and maintaining consistency across Linux based remote development environments.
oStrong understanding of reliability engineering principles incident response root-cause analysis and postmortem processes.
Databasing & Data Modeling
oExpertise in storing and interacting with large tables via Oracle SQL.
oUnderstanding of database execution techniques indexing and schema strategies and query optimization
oExperience with ETL/ELT patterns and frameworks and the ability to develop novel ones from scratch to solve complex requirements.
oDeep understanding of data quality frameworks validation strategies reconciliation techniques and automated testing.
Architecture and Performance
oDeep understanding of resource optimization patterns used to eliminate processing bottlenecks and develop code utilizing minimal required resources.
oExperiencing designing custom mechanisms for tracking pipeline states pipeline failures managing incremental loads and logging operational metadata.
oDeep knowledge of production process maintenance and support techniques and procedures.
Modern Data Infrastructure & Orchestration
oAdvanced experience implementing and managing programmatic workflows orchestration via Cron Airflow and Kafka including best practices for managing concurrent task orchestration and complex task dependency.
oFamiliarity with a range of cloud solutions including platforms/ecosystems ETL tooling and high performance data warehousing.
oDeep understanding the software development lifecycle DevOps and CI/CD pipelines along with the ability to perform basic pipeline configuration and maintenance.
Technical Leadership and Mentorship
oExperience defining coding standards and practices as well as leading rigorous code review.
oProven ability to upskill other engineers mentor teammates through complex tasks and foster a collaborative engineering culture.
oAbility to balance high engineering quality with pragmatic business delivery with a focus on meeting milestones without accumulating technical debt.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