Note: The job is a remote job and is open to candidates in USA. HD-Tech is a leading enterprise consulting organisation focused on large-scale data transformation and cloud migration programmes across North America. They are seeking a Senior Data Engineer to design and deliver modern cloud data warehouse solutions, primarily using Snowflake, while supporting major Oracle-to-Snowflake migration programmes.

Responsibilities

• Act as a technical lead on Snowflake-based data platform design and delivery
• Work closely with stakeholders to translate business requirements into scalable Snowflake architectures
• Design, build, and maintain data pipelines with Snowflake as the core data warehouse
• Lead Oracle data warehouse migration projects into Snowflake , ensuring accuracy, performance, and scalability
• Develop and optimise SQL-based transformations within Snowflake environments
• Implement ELT pipelines using tools such as dbt, Fivetran, and Informatica IICS, with Snowflake as the target platform
• Ensure best practices for Snowflake performance tuning, cost optimisation, and data modelling
• Troubleshoot and resolve complex data issues within Snowflake-based solutions
• Collaborate with cross-functional teams including analysts, engineers, and business users
• Provide technical leadership and mentorship to junior engineers
• Contribute to data governance, architecture standards, and delivery best practices

Skills

• Expert-level, hands-on experience with Snowflake (mandatory)
• Strong SQL development and performance tuning within Snowflake
• Proven experience with Snowflake data warehousing and cloud data platform architecture
• Strong understanding of data modelling and modern ELT/ETL approaches
• Excellent communication skills and stakeholder engagement ability
• Experience migrating from Oracle to Snowflake strongly preferred
• Experience with dbt, Fivetran, and/or Informatica IICS
• Background in enterprise data engineering or consulting environments
• Experience with Windows scripting or automation tools is beneficial

Benefits

• Competitive base salary + performance bonus
• Fully remote working (US-based)
• Comprehensive benefits package including healthcare and retirement plan
• Opportunity to lead major Snowflake transformation programmes
• High-impact enterprise consulting environment with strong growth trajectory
• Ongoing technical development and training opportunities

Company Overview