Key skills
AWSAzureCloudETLHadoopInformaticaPythonScalaSparkSQLAgile
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. Prepares technical and procedural documentation required.
- Participates in code reviews & testing
- Applies modern principles, methodologies, and tools to advance business initiatives and capabilities.
- 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 ensuring data quality and integrity at all times
- Stay current with industry trends, technologies and best practices to continuously improve our data ecosystem
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 skills
- Familiarity with cloud platforms (e.g Azure, AWS) and their data related services
- Ability to work in agile environment
- Experience in Spark, Big Data, ETL and Python
Tech Stack
- AWS
- Azure
- Cloud
- 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, unless otherwise required by law
- between 15 to 25 vacation days each year, depending on career level; and years of service