Key skills
ETLPythonSQLData LakeRepositoryAgile
About this role
Role Overview
- Acquire/map datasets that align with our business partner needs.
- Develop ETL pipelines, Data Ingestion, basic transformations.
- Build, test, and maintain database pipeline architectures.
- Form new data validation methodologies and data analysis tools.
- Ensure continued compliance with data security policies and governance.
Requirements
- Experience working in an Agile Team construct.
- Extensive knowledge of databases, data warehouses, systems integrations, and data flows are mandatory for this role.
- Coding: Proficiency in coding languages is essential to this role.
- Common programming languages used by the team include SQL, Python.
- ETL (extract, transform, and load) systems: Moving data from databases and other sources into a single repository, like a data warehouse.
- Data storage knowledge: As solutions are designed, when to use a data lake versus a data warehouse, for example.
- Bachelor’s degree with 2+ years of relevant professional experience.
Tech Stack
- ETL
- Python
- SQL
Benefits
- medical/prescription drug coverage (with a Health Savings Account feature)
- 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/elder care
- adoption, surrogacy, and doula reimbursement
- educational assistance, including select programs fully paid
- a robust wellness program with financial incentives
- maternity and/or parental leave
- up to 11 paid holidays each year
- 9 occasional absence days each year, unless otherwise required by law
- between 15 to 25 vacation days each year, depending on career level; and years of service