ETL Pipeline Architect

Job Title: BI Developer

Location: Redhill, 3 days office based

Salary: £60-65k pa + good benefits package

E-Resourcing Ltd is a global organisation seeking an experienced Business Intelligence Developer to provide project and support expertise business wide.

In this role, you will be responsible for designing, developing, and implementing ETL pipelines as data warehouse models, working collaboratively with various IT divisions.

1. Design and develop ETL pipelines using Snowflake, Informatica, and Change Data Capture technologies.
2. Collaborate with IT divisions to deliver data warehouse solutions using Kimball & Inmon methodologies.
3. Develop data models, dimensions, and measures using SCD.
4. Maintain and evaluate 3rd party applications.

You will also participate in requirement-gathering activities, pre-project boards, and ensure data security and reliability.

• Excellent experience in data modelling and development in Snowflake.
• Proven experience with ETL/ELT technologies in Informatica and Change Data Capture.
• Data warehouse solution design using Kimball & Inmon methodologies.
• Proven capability with Oracle, SQL, and PL/SQL.
• Understanding of big data concepts, Data Lake, Data Vault, NoSQL databases, Amazon S3, and external files.
• Experience with Python, Spark, Machine Learning, and REST API.

This is a responsible role in a complex environment. You will need excellent communication skills and enjoy project-based work.

Please send a CV detailing the above required experience for consideration.