Data Engineer & Data Vault

Role & responsibilities

• Design and implement Data Vault 2.0 data models including Hubs, Links, and Satellites.
• Develop and maintain data ingestion, transformation, and integration pipelines.
• Build enterprise data warehouses, data marts, and analytical data models. Implement ELT/ETL processes using modern data engineering tools.
• Collaborate with business analysts, architects, and stakeholders to gather requirements and translate them into scalable data solutions.
• Ensure data quality, governance, lineage, and auditability across the data ecosystem.
• Optimize data processing performance and cloud resource utilization.
• Develop and maintain technical documentation, data dictionaries, and model standards.
• Support reporting, analytics, and AI/ML initiatives by delivering trusted data assets.
• Participate in code reviews and establish best practices for data engineering Databases & Warehousing SQL Server, Oracle, PostgreSQL, Snowflake, Synapse, or Redshift.
• Data warehouse design and dimensional modeling (Star/Snowflake schemas)