Job Title: Senior Data Engineer

Location: Warwick

Remuneration:

- Day Rate: £550pwd, paid via Umbrella Company

- Contract Length: 6 months, potential to move to Perm

Contract Details: Fixed Term Contract, Full Time

Responsibilities:

• Design, develop, and maintain ETL processes using tools like Matillion.
• Develop and maintain Data warehouse objects like tables, views, and security roles in a Snowflake database.
• Extract data from various sources, such as databases, flat files, and APIs.
• Transform and cleanse data to ensure data quality and integrity.
• Load data into the data warehouse, ensuring data consistency and accuracy.
• Optimise ETL processes for performance, scalability, and reliability.
• Work closely with data architects, analysts, and developers to support data integration initiatives.
• Implement data validation, data quality checks, and data security measures.
• Troubleshoot and resolve data issues, performance bottlenecks, and ETL failures.
• Implement best practises for data warehousing, Datamodelling, and ETL development.
• Document ETL processes, data mappings, and configurations.

Requirements:

• Expert level knowledge of industry leading ETL/ELT tools such as Informatica, Matillion, or SSIS.
• Experience in designing and developing complex near Real Time and/or batch data integration solutions using cloud-based ETL and integration tools.
• Experience with traditional and non-traditional forms of analytical data design (Kimbal, Inmon, etc).
• Proficiency in SQL programming and relational database concepts.
• Experience with loading and maintaining a data warehouse.
• Bachelor's degree in Computer Science or a related field with six years of related experience, or Master's degree in Computer Science or a related field with at least 4 years of related experience required.
• Ability to work with different functional groups and levels of employees to effectively and professionally achieve results.
• Strong organisational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritisation of duties and functions in a fast-paced environment.

Nice to Have:

• Experience with cloud-based data platforms, such as Snowflake.
• Domain knowledge in the area of finance data is preferred.
• Experience with SAP Systems and Databases.
• Knowledge of data visualisation tools, such as PowerBI or Tableau.

Join our client's Finance data and reporting office team, where you will contribute to connecting people to the energy they use safely, reliably, and efficiently. As a Data Engineer, you will have a hands-on role in the design, development, and delivery of database, business intelligence, data warehouse, and data integration solutions. This is an exciting opportunity to work with a dynamic team and contribute to the organisation's success.

In this role, you will be responsible for designing, developing, and maintaining ETL processes using tools like Matillion, extracting, transforming, and loading data from various sources into our data warehouse, and optimising ETL processes for performance, scalability, and reliability. You will also collaborate closely with data architects, analysts, and developers to support data integration initiatives and implement best practises for data warehousing and ETL development.

To be successful in this role, you should have experience in relational databases, ETL, and data warehousing, expert-level knowledge of ETL/ELT tools, proficiency in SQL programming, and a Bachelor's or Master's degree in Computer Science or a related field. Strong organisational skills and the ability to work effectively with different functional groups and levels of employees are essential.

Additionally, experience with cloud-based data platforms, finance data, SAP systems and databases, and data visualisation tools would be advantageous.

Our client offers an attractive hourly rate and a fixed-term contract of 6 months, providing you with an exciting opportunity to contribute to their data engineering initiatives and enhance your skills in a utilities industry environment.

If you are ready to make an impact in an innovative and dynamic organisation, apply now with your updated CV and let's discuss how you can join our client's team as a Senior Data Engineer.

Adecco is a disability-confident employer. It is important to us that we run an inclusive and accessible recruitment process to support candidates of all backgrounds and all abilities to apply. Adecco is committed to building a supportive environment for you to explore the next steps in your career. If you require reasonable adjustments at any stage, please let us know and we will be happy to support you.