Senior Consultant - Data Engineer
Indexed description
Your Role And Responsibilities
What we are looking for:
We are looking for a Sr. Consultant, Data Engineer to join our growing team of experts. This position will work in the design and development of Snowflake Data Cloud solutions. The work includes data ingestion pipelines, data architecture, data governance and security. The ideal candidate is an experienced data pipeline builder and migrations who enjoys optimizing data systems and building them from the ground up.
Key Responsibilities
Data Engineering & Solution Delivery
- Build and maintain scalable data pipelines, ingestion frameworks, and ELT/ETL processes using modern cloud technologies.
- Implement ingestion and CDC patterns using tools like Fivetran, Qlik Replicate, or native cloud services.
- Develop transformation logic using SQL, dbt, Python, and DataOps best practices.
- Engineer data models across Dimensional, Data Vault, Lakehouse, and semantic layers.
- Optimize pipelines for performance, reliability, cost efficiency, and scalability.
- Develop and optimize cloud-native data platforms (Snowflake, Databricks, AWS, Azure, GCP).
- Implement warehouse/lakehouse structures, storage standards, governance rules, and data quality frameworks.
- Leverage orchestration tools such as Airflow, dbt Cloud, or native cloud schedulers to deploy and operate pipelines.
- Engage with client technical and business teams to gather requirements, define solutions, and ensure clarity.
- Communicate progress, blockers, and recommendations clearly and professionally.
- Participate in architecture reviews and support Solution Architects in defining best-fit approaches.
- Serve as a trusted advisor during delivery, balancing technical execution with client expectations.
- Implement data validation, observability, and monitoring frameworks to ensure trust and reliability.
- Apply RBAC, data classification, masking, encryption, and compliance best practices.
- Document technical solutions, lineage, standards, and handover materials.
- Support and mentor junior and mid-level engineers, promoting Hakkoda’s engineering standards and delivery excellence.
- Conduct code reviews, provide technical guidance, and contribute to team continuous improvement.
- Collaborate on internal accelerators, reusable templates, and Hakkoda-branded methodologies.
- Stay current with emerging technologies across Snowflake, Databricks, AI/ML, streaming platforms, and modern data tooling.
- Contribute to internal communities of practice, accelerators, and thought leadership.
- Share learnings and promote a culture of experimentation and continuous improvement.
- 6+ years of experience in Data Engineering or related technical roles.
- Strong SQL expertise and experience with ELT/ETL pipeline development.
- Hands-on experience with at least one major cloud platform (AWS, Azure, GCP).
- Good experience with modern data platforms (Snowflake, Databricks, BigQuery, Redshift, Synapse).
- Proficiency in Python or similar languages for data engineering tasks.
- Knowledge of data modeling (Dimensional, Data Vault, Lakehouse).
- Experience with CICD workflows and version control (GitHub, Bitbucket).
- Consulting or client-facing delivery experience.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search