Senior Consultant - Data Engineering & Data Quality

Seeking a highly skilled Senior Consultant with deep experience in Data Engineering and Data Quality to join our team. This role will focus on building, testing and optimizing modern, cloud-based data platforms using AWS, Snowflake, dbtCloud, Python, and SQL. The ideal candidate combines strong engineering discipline with hands-on experience implementing automated data quality frameworks and scalable ingestion pipelines in enterprise environments.

This position requires adaptability across multiple clients environments and a passion for delivering high-quality, production-ready data solutions that balance engineering rigor with practical execution.  You will play an integral role in shaping our Data & Analytics practice through project delivery, engineering excellence, collaboration with U.S.-based teams, and mentorship.

Responsibilities

         Design, build, and optimize cloud-based data pipelines using AWS, Snowflake, dbtCloud, Python, and SQL.

         Implement ingestion frameworks that support scalable integration of data from enterprise systems (SAP, MES, Salesforce, etc.)

         Develop transformation logic and data models that support analytics, BI reporting, and downstream data products.

         Establish automated data quality and validation processes, including test suites that ensure reliability across the pipeline lifecycle.

         Troubleshoot and resolve pipeline issues, performing root-cause analysis and improving stability, performance, and maintainability.

         Document technical designs, data flows, and testing approaches with clarity appropriate for both technical and consulting audiences.

         Collaborate with product owners, analysts, and architecture teams to refine requirements and translate business needs into technical solutions.

Required Experience

         8+ years of experience as a Data Engineer, delivering end-to-end pipeline development in cloud environments.

         3+ years of hands-on experience validating and testing pipelines in AWS/Snowflake ecosystems.

         Strong experience with AWS data services (Glue, EMR, RDS, S3, IAM) and Snowflake.

         Practical experience with dbtCloud for modeling, transformations, and testing.

         High proficiency in Python and SQL for data processing and automation.

         Experience working in Agile delivery environments and collaborating with distributed/global teams.

Required Skills

         Ability to design and build scalable, cloud-based ELT/ETL pipelines.

         Skilled in implementing automated data quality checks and testing frameworks.

         Strong SQL fundamentals including performance tuning and debugging.

         Experience with data modeling and transformation patterns using dbtCloud.

         Familiarity with integrating pipelines into CI/CD workflows.

Desired Skills

         AWS Certifications (Solutions Architect, Data Engineer, Developer).

         Experience with BI tools (Tableau, Power BI).

         Exposure to SAP, MES, or supply chain/manufacturing data systems.

         Understanding of data governance and metadata management concepts.

         Experience in regulated environments (medical devices, healthcare, finance).

         Prior experience mentoring or supporting junior engineers.

         Background in global delivery models or nearshore/offshore collaboration.