Snowflake Consultant

We’re looking for a Snowflake Consultant to join one of our Data Engineering teams. You’ll design, develop, and optimize modern cloud data warehouse solutions using the Snowflake Data Cloud platform. You’ll work closely with Data Engineers, BI Developers, Solution Architects, Data Modellers, and business stakeholders to build scalable, secure, and high-performing data solutions that support enterprise analytics, reporting, and AI initiatives.

𝗗𝗮𝘁𝗮 𝗲𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 & 𝘀𝗼𝗹𝘂𝘁𝗶𝗼𝗻 𝗱𝗲𝘀𝗶𝗴𝗻

• Design, develop, and maintain enterprise data warehouse solutions using the Snowflake Data Cloud platform.

• Translate business and technical requirements into scalable cloud-native data solutions.

• Design data integration architectures supporting enterprise analytics and reporting.

• Collaborate with Solution Architects to define modern cloud data platform solutions.

• Develop reusable frameworks, standards, and best practices for Snowflake development.

• Produce and maintain technical documentation, data flow diagrams, and solution specifications.

𝗗𝗮𝘁𝗮 𝗶𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 & 𝗘𝗧𝗟/𝗘𝗟𝗧

• Develop and optimize ETL/ELT pipelines loading data into Snowflake from multiple enterprise data sources.

• Implement scalable data ingestion and transformation processes.

• Develop source-to-target mappings and transformation logic based on business requirements.

• Support incremental loading strategies and Change Data Capture (CDC) implementations.

• Ensure data consistency, integrity, and quality throughout data integration processes.

• Collaborate with Data Engineers and BI teams to support enterprise reporting solutions.

𝗗𝗮𝘁𝗮 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴 & 𝗱𝗮𝘁𝗮 𝘄𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗶𝗻𝗴

• Design and implement dimensional data models supporting analytical workloads.

• Develop data marts and curated analytical datasets.

• Collaborate with Data Modellers to ensure alignment with enterprise data architecture.

• Optimize database structures for reporting, analytics, and self-service BI.

• Support metadata management and data lineage initiatives.

• Ensure data models remain scalable, maintainable, and well documented.

𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 & 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻

• Optimize Snowflake performance through warehouse tuning, clustering, partitioning strategies, and query optimization.

• Monitor platform utilization and recommend cost optimization opportunities.

• Analyze workloads and improve resource efficiency.

• Implement best practices for workload management and performance monitoring.

• Investigate production issues and implement corrective actions.

• Continuously improve scalability, reliability, and operational efficiency.

𝗧𝗲𝘀𝘁𝗶𝗻𝗴, 𝗱𝗲𝗽𝗹𝗼𝘆𝗺𝗲𝗻𝘁 & 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀

• Develop automated testing and validation processes for data pipelines.

• Collaborate with DevOps and DataOps teams to implement CI/CD pipelines.

• Support deployment across development, testing, and production environments.

• Monitor production workloads and investigate operational issues.

• Maintain technical documentation throughout the project lifecycle.

• Contribute to continuous improvement of development standards and operational practices.

Work model

Hybrid and remote-friendly. We trust you to deliver, wherever you work best from.

𝗤𝘂𝗮𝗹𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀

𝗠𝘂𝘀𝘁-𝗵𝗮𝘃𝗲

• University degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field.

• 3+ years of experience in Data Engineering, Cloud Data Warehousing, or Business Intelligence.

• Hands-on experience with Snowflake Data Cloud.

• Strong SQL skills and solid understanding of relational databases.

• Experience developing ETL/ELT solutions and data integration pipelines.

• Good understanding of dimensional modeling and enterprise data warehouse concepts.

• Experience with cloud platforms such as Microsoft Azure, AWS, or Google Cloud.

• Strong analytical and problem-solving skills.

• Excellent communication and collaboration abilities.

𝗡𝗶𝗰𝗲 𝘁𝗼 𝗵𝗮𝘃𝗲

• Experience with dbt, Azure Data Factory, Matillion, Fivetran, Informatica, or similar integration tools.

• Familiarity with Snowpark (Python, Java, or Scala).

• Experience with CI/CD, Git, and Infrastructure as Code.

• Knowledge of DataOps and MLOps practices.

• Experience with Power BI, Tableau, or other analytics platforms.

• Experience in Banking, Retail, Insurance, or Telco industries.

• SnowPro Core or SnowPro Advanced certification.

• Microsoft Azure, AWS, or Google Cloud certifications.

𝗛𝗼𝘄 𝘆𝗼𝘂 𝘄𝗼𝗿𝗸

• Passionate about cloud data platforms and modern data engineering.

• Strong ownership and attention to detail.

• Analytical, proactive, and solution-oriented.

• Comfortable working with multidisciplinary technical teams.

• Focused on delivering scalable, secure, and high-quality data solutions.

• Committed to continuous learning and innovation.

𝗪𝗵𝗼 𝘄𝗲 𝗮𝗿𝗲

IDS Consulting — a team of data people who genuinely love what they do. For 14+ years, we’ve been the go-to consultants for BI and Data Warehousing, partnering with enterprise clients across Banking, Retail, and Telco in Romania and Europe.

Today, we help organizations modernize their cloud data platforms, enabling Business Intelligence, Advanced Analytics, and Artificial Intelligence through scalable enterprise solutions.

Our promise is short and to the point: We always deliver. Expert Data Services.

𝗪𝗵𝘆 𝗜𝗗𝗦 𝗖𝗼𝗻𝘀𝘂𝗹𝘁𝗶𝗻𝗴

• 14+ years of expertise in Data Engineering, Data Warehousing, Business Intelligence, and Cloud Analytics.

• A team of experienced data specialists who learn from each other every day.

• Real projects, real impact—you’ll build modern cloud data platforms that support enterprise reporting, analytics, and AI initiatives.

• A culture that pushes you to grow, mentors you when you need it, and trusts you to deliver.

Sound like your kind of place? We’d love to meet you.