Data Transformation Consultant
Job Title: Data Transformation Consultant
Interview: Virtual
Job Location: Remote
Job Duration: 6+ Months
The Data Transformation Consultant partners with business and technical stakeholders to modernize and optimize enterprise data ecosystems. This role designs and delivers data transformation strategies, builds scalable data pipelines, and ensures data quality, governance, and performance to enable analytics, digital transformation, and data-driven decision-making.
Key Responsibilities:
- Engage stakeholders to understand data challenges, transformation goals, and success measures
- Define and deliver data transformation roadmaps aligned to enterprise architecture and business strategy
- Design, build, and optimize ETL/ELT pipelines across on-premises and cloud environments
- Transform, cleanse, and integrate structured and unstructured data from multiple source systems
- Develop scalable, reusable data models to support reporting, analytics, and AI/ML use cases
- Establish data quality standards, validation rules, and monitoring processes
- Support data governance initiatives including metadata, lineage, and master data management
- Ensure solutions meet security, compliance, and enterprise data policy requirements
- Lead workshops, contribute to solution design, documentation, and technical reviews
- Mentor junior team members and contribute to best practices and reusable assets
Required Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field
- 5+ years of experience in data transformation, data engineering, or analytics consulting
- Strong experience designing and implementing ETL/ELT solutions on modern data platforms
- Proficiency in SQL and one programming language (Python, Scala, or Java)
- Experience working with relational and non-relational data sources
- Strong consulting, problem-solving, and stakeholder communication skills
Preferred Qualifications:
- Experience with Azure, AWS, or Google Cloud
- Hands-on experience with tools such as dbt, Spark, Airflow, Fivetran, Informatica, or Talend
- Knowledge of data warehousing and lakehouse architectures
- Familiarity with DataOps/DevOps and CI/CD pipelines
- Experience supporting BI, analytics, or AI/ML workloads
Recommended Jobs
Regional Sales Representative
Group Mission Statement: Our goal is to deliver exceptional support to our customers in the aviation industry, guided by our five core values: Respect, Integrity, Positivity, Reliability, and Effici…
Shape the Future of Pediatric Development - Join Banner Children's in Mesa, AZ!
Shape the Future of Pediatric Development — Join Banner Children's in Mesa, AZ! Banner Children's Specialists (BCS) is seeking a Pediatric Developmental Specialist to join our established team …
Physical Therapist Assistant
Salary: $26 - $32 / hour based on experience! Bodycentral Physical Therapy, a member of Therapy Partners Group, has been the premier provider for outpatient orthopedics serving Tucson, Tempe,…
Sales Account Representative - AZ
Premise One is a leading provider of low-voltage security and technology solutions, specializing in surveillance and access control systems solutions. We are dedicated to the design and delivery of c…
Electrical Drafter (Onsite)
Be Part of a Forward-Thinking Design Team: Electrical Drafter Do you have a passion for electrical design and a knack for translating complex ideas into clear visuals? Industrial Design, a leading…
Emergency Medicine Advanced Practice Clinician in Buckeye, AZ
TeamHealth has an excellent PRN opportunity for a physician assistant (PA) or nurse practitioner (NP) to join our emergency department (ED) team at Abrazo Buckeye campus in Buckeye, Arizona. We ask t…
dental assistant
Dental Assistant - Experienced At A Small World Pediatric Dentistry, we are excited to announce an opportunity for a dedicated Dental Assistant to join our team as a Full-Time experienced Dental Ass…
Senior Software Architect
Allsup LLC is a people-centered organization with a team of hundreds who are dedicated to helping people with disabilities lead lives that are as financially secure and healthy as possible. We enjoy …
Mobile HVAC/Maintenance Engineer
Mobile HVAC/Maintenance Engineer Malace|HR is seeking an experienced Mobile HVAC/Maintenance Engineer in the Des Moines, IA area. The role will be working 1st shift hours and pays $35-36 per hour. …
Off Leash K9 Dog Trainer
Are you looking for a career, not just a job? Do you love dogs? Do you love helping people? Do you possess great customer service skills? Do you have outstanding work ethic? We are a part o…