Data Transformation Consultant
6 month day rate contract - €- per day
Dublin - Hybrid
The role
The Data Transformation Consultatn is responsible for designing, managing, and optimizing data transformation processes that convert raw data into high-quality, analytics-ready datasets. This role oversees transformation pipelines, enforces data quality standards, and partners with engineering, analytics, and business stakeholders to ensure reliable and scalable data delivery.
Key Responsibilities
Data Transformation & Modeling
1. Design and maintain data transformation logic (cleaning, normalization, enrichment)
2. Develop and manage transformation layers in the data warehouse
3. Own semantic models and business logic definitions
4. Ensure consistency of metrics across teams
Pipeline Management
5. Oversee ETL / ELT workflows and orchestration
6. Monitor pipeline performance, failures, and data freshness
7. Manage dependencies and versioning of transformation assets
Data Quality & Governance
8. Define and enforce data quality checks and validation rules
9. Ensure compliance with data governance, security, and privacy standards
10. Maintain documentation for data lineage and transformations
Collaboration & Leadership
11. Work closely with Data Engineers, Analysts, and Product teams
12. Translate business requirements into scalable data transformations
13. Mentor junior data team members and review transformation code
Required Qualifications
14. 5+ years experience in data engineering, analytics engineering, or data transformation roles
15. Strong SQL expertise; experience with Python preferred
16. Hands-on experience with transformation tools
17. Experience with cloud data platforms
18. Solid understanding of data modeling (star, snowflake, dimensional modeling)
For more info and a confidential discussion please call Michael on 01 or