Key skills
ETLHadoopInformaticaPythonScalaSparkSQLAgileCommunicationProblem SolvingCollaboration
About this role
Role Overview
- Design, develop and maintain scalable and efficient data pipelines and ETL processes
- Collaborate with analysts and stakeholders to gather requirements and implement data solutions that meet business needs
- Proposes & designs data solutions to address complex business needs
- Prepare technical and procedural documentation required
- Participate in code reviews & testing
- Develop and manage data integrations between various systems, ensuring seamless data flow and consistency
- Optimize database and query performance to support analytical workloads
- Monitor and troubleshoot data workflows to ensure data quality and integrity
Requirements
- 5+ years of industry-relevant experience
- Experience with data pipelines and ETL
- informatica
- Experience in SQL and database management systems
- Knowledge of data modelling, warehousing concepts, and ETL processes
- Experience with big data technologies and frameworks such as Hadoop, Hive, Spark
- Programming experience in Python or Scala
- Excellent problem solving communication and collaboration skills
- Ability to work in an agile environment
Tech Stack
- ETL
- Hadoop
- Informatica
- Python
- Scala
- Spark
- 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
- between 15 to 25 vacation days each year, depending on career level and years of service