the future project ltd company
Data Engineer
£500 - per day – Outside of IR35
3 months
Fully remote
We are only looking for someone with DataVault, Snowflake and dbt skills for this one!!
My client are embarking on a significant enterprise-wide HR program to transition from IFS v9 to IFS v11 for HCM processes. This transition includes a shift from existing ETL processes to a modern data infrastructure, leveraging Data Vault 2.0 modeling, Snowflake for database management, and dbt for data transformation to establish robust data pipelines.
Key Responsibilities:
Develop and implement Data Vault 2.0 models to support their advanced HR data requirements.
Design and generate dimensional (star schema) and fact tables based on Data Vault models.
Utilize dbt (data build tool) for data transformation within these pipelines, with a preference for experience in using Automate DV in dbt.
Understand and document current ETL processes to effectively transition them into scalable data pipelines.
Ensure high data quality and integrity throughout the data pipeline development and maintenance.
Provide insights and recommendations to optimize new data pipelines.
Collaborate closely with HR and IT departments to ensure reporting requirements are fulfilled in the new system.
Required Skills and Experience:
Extensive experience in data engineering, with a strong focus on Data Vault 2.0 modelling.
Proficiency in Snowflake for data storage and management.
Expertise in dbt for data transformation, particularly with experience in Automate DV.
Familiarity with HR data processes and systems, including experience with IFS versions.
Solid understanding of dimensional modelling and fact table generation for data pipelines.
Ability to translate complex data requirements into efficient and effective data models.
Excellent problem-solving skills and meticulous attention to detail.
Strong communication skills to effectively collaborate with various teams.
