Senior Data Engineer (Snowflake)

TL;DR

Senior Data Engineer (Snowflake/AWS): Designing and delivering enterprise data platforms and scalable data pipelines with an accent on Snowflake architecture and Data Vault 2.0. Focus on optimizing ELT frameworks, mentoring engineering teams, and ensuring operational reliability of high-impact data solutions.

Location: Hybrid (Chicago, IL; Birmingham, AL; Richardson, TX; Jacksonville, FL) or Remote within the USA

Salary: $99,000 – $164,800

Company

hirify.global is one of the nation’s leading specialized insurers focused on providing high-performing culture and professional challenge.

What you will do

• Provide technical leadership and set standards for solution design, coding practices, and data governance.
• Define and evolve enterprise data architecture leveraging Snowflake, Data Vault 2.0, and event-driven ELT frameworks.
• Architect and oversee the delivery of scalable data pipelines using Python, Spark, Informatica, and AWS Glue.
• Design and maintain enterprise data models, including dimensional and Data Vault 2.0 structures.
• Optimize Snowflake platform capabilities, including Snowpipe, Dynamic Tables, and warehouse performance tuning.
• Collaborate with product owners and architects to translate business requirements into technical specifications.

Requirements

• 8+ years of experience in data engineering, with 2+ years in a senior or lead capacity.
• Advanced hands-on expertise in Snowflake and implementation of Data Vault 2.0 models.
• Proficiency with ETL/ELT tools (Informatica IDMC, PowerCenter, AWS Glue) and Python-based pipelines.
• Deep understanding of dimensional modeling, CDC frameworks, and orchestration tools like Control-M or Airflow.
• Strong SQL expertise and experience delivering large-scale AWS-based data platforms.
• Sponsorship is not accepted for this opportunity.

Nice to have

• Experience with Snowpark (Python/Java/Scala) and advanced Snowflake RBAC.
• Knowledge of DataOps/DevOps frameworks, including CI/CD (GitHub Actions, GitLab CI) and Terraform.
• Familiarity with data quality tools like Great Expectations, Monte Carlo, or Alation.
• Experience with streaming technologies such as Kafka or Kinesis.
• P&C Insurance industry experience, specifically with Guidewire PolicyCenter, ClaimCenter, or BillingCenter.

Culture & Benefits

• Annual discretionary bonus.
• Comprehensive benefits package including Medical, Dental, Vision, and 401k.
• Paid Time Off (PTO) and a healthy work-life balance.
• Collaborative, growth-oriented environment with strong investment in data modernization.
• Flexible work options including hybrid and remote arrangements.