Data Transformation Consultant
6 month day rate contract - €500-600 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
- Design and maintain data transformation logic (cleaning, normalization, enrichment)
- Develop and manage transformation layers in the data warehouse
- Own semantic models and business logic definitions
- Ensure consistency of metrics across teams
Pipeline Management
- Oversee ETL / ELT workflows and orchestration
- Monitor pipeline performance, failures, and data freshness
- Manage dependencies and versioning of transformation assets
Data Quality & Governance
- Define and enforce data quality checks and validation rules
- Ensure compliance with data governance, security, and privacy standards
- Maintain documentation for data lineage and transformations
Collaboration & Leadership
- Work closely with Data Engineers, Analysts, and Product teams
- Translate business requirements into scalable data transformations
- Mentor junior data team members and review transformation code
Required Qualifications
- 5+ years experience in data engineering, analytics engineering, or data transformation roles
- Strong SQL expertise; experience with Python preferred
- Hands-on experience with transformation tools
- Experience with cloud data platforms
- Solid understanding of data modeling (star, snowflake, dimensional modeling)
For more info and a confidential discussion please call Michael on 01 614 6058 or [email protected]
