Data Engineer II
Summary
Designs and maintains scalable data pipelines and ETL processes using SQL, SAS, and Oracle to integrate and ensure data quality across systems.
Overview
The Group Data and Analytics Office is on the lookout for a skilled Data Engineer. The ideal candidate will have extensive experience in data engineering, particularly with SAS, SQL and Oracle, and will be responsible for designing, developing, and maintaining the data infrastructure.
Responsibilities
- Design, build, and maintain scalable data pipelines.
- Develop ETL processes to extract, transform, and load data from various sources.
- Integrate data from multiple sources to create a unified data environment.
- Ensure data quality and consistency across different systems.
- Monitor and optimize the performance of data pipelines and ETL processes.
- Implement best practices for data storage and retrieval.
- Work closely with data scientists, analysts, and other stakeholders to understand data needs and requirements.
- Collaborate with cross-functional teams to ensure seamless data integration.
- Identify and resolve data-related issues and discrepancies.
- Provide support for data-related queries and requests.
Qualifications
- Education: Bachelor’s or Master’s degree in Computer Science, Engineering, Information Technology, or a related field.
- Experience: 5+ years of experience in data engineering and ETL development.
- Extensive experience in developing and maintaining data pipelines.
- Proficiency in SQL, SAS, Oracle and other database technologies.
- Skills: Strong problem-solving and analytical skills.
- Excellent communication and collaboration abilities.
- Knowledge of data modelling, data warehousing, and data integration best practices.
Preferred Qualifications
- Experience with cloud platforms such as Azure.
- Familiarity with scripting languages like Python or R.
- Knowledge of data governance and security practices.