Data Transformation Engineer (Snowflake)

TL;DR

Data Transformation Engineer (Snowflake): Building and optimizing next-generation enterprise data solutions with an accent on robust data modeling, efficient ELT processes, and Snowflake performance optimization. Focus on designing scalable data pipelines, implementing data quality monitoring, and ensuring system reliability for critical business operations.

Location: Must be based in the USA (Remote)

Salary: $130,000–$150,000/year

Company

hirify.global is a leading provider of insurance solutions committed to diversity, equity, and inclusion.

What you will do

• Design and develop robust data pipelines and ELT workflows to populate cloud Data Lake and Data Warehouse.
• Develop Snowflake data objects including tables, views, and stored procedures.
• Implement ELT processes using tools like SnowPipe, Streams, and Tasks.
• Perform data cleaning, analysis, and integration using Python.
• Monitor and optimize query performance and resource utilization within Snowflake.
• Ensure data quality and availability for key stakeholders and business processes.

Requirements

• 4+ years of professional experience in data engineering and building data infrastructure.
• 4+ years of strong experience with Snowflake data cloud and ETL development.
• 3+ years of experience with Python programming, including Snowpark, pandas, and numpy.
• 2+ years of experience with data integration tools like Coalesce, WhereScape, or Azure Data Factory.
• Solid understanding of data warehousing concepts and dimensional modeling.
• Bachelor's degree in Computer Science, Engineering, or a related field.

Nice to have

• Snowflake Advanced Certification.
• Experience with data quality and observability concepts.

Culture & Benefits

• Comprehensive benefits package including medical, dental, vision, and life insurance.
• Retirement Plan (401k) with company-matched contributions.
• Performance-based bonuses.
• Paid time off and flexible work options.
• Education advancement support via scholarship fund.
• Fitness reimbursement and employee assistance program.