Senior Data Engineer (Snowflake)

Location: Hybrid from local hirify.global offices in Chicago, IL, Birmingham, AL, Richardson, TX, or Jacksonville, FL; remote options with travel are available for non-local candidates. The position is limited to the United States, and visa sponsorship is not accepted.

Salary: $99,000–$164,800 annually, plus an annual discretionary bonus and hirify.global benefits.

Company

hirify.global is a specialized insurance company providing products and services for customers with evolving insurance needs.

What you will do

• Provide technical leadership to data engineers, establish solution design, coding, governance, and quality standards, and mentor team members.
• Define and evolve enterprise data architecture using Snowflake, Data Vault 2.0, event-driven patterns, and modern ELT frameworks.
• Architect and oversee scalable data pipelines, ingestion frameworks, transformation processes, and batch, micro-batch, and real-time solutions.
• Design and maintain Data Vault 2.0 and dimensional data models, including Hubs, Links, Satellites, PIT, Bridge, and relational structures.
• Translate business requirements into technical designs, coordinate delivery across stakeholders, and oversee documentation, testing, deployment readiness, and production releases.
• Maintain reliability, accuracy, and performance of data platforms through monitoring, root-cause analysis, query and pipeline optimization, and preventative solutions.

Requirements

• 8+ years of data engineering experience, including 2+ years in a senior, lead, or architect capacity.
• Advanced hands-on Snowflake expertise and strong experience implementing Data Vault 2.0 models and automated ELT frameworks.
• Proficiency with Informatica IDMC, PowerCenter, Pentaho, AWS Glue, Control-M, and Python-based data pipelines.
• Deep understanding of data warehousing, analytics engineering, dimensional modeling, relational structures, ELT patterns, CDC frameworks, and metadata-driven design.
• Experience with orchestration frameworks including Control-M and Airflow, plus strong SQL skills involving stored procedures, Snowflake Scripting, and complex query optimization.
• Hands-on experience designing and delivering large-scale AWS-based data platforms.
• Demonstrated ability to guide teams, influence architecture decisions, manage technical delivery, and collaborate with technical and business stakeholders.
• Excellent communication and collaboration skills.

Nice to have

• Experience with Snowpark, Snowflake warehouses, databases, schemas, RBAC, Snowpipe, Tasks, Streams, Stages, File Formats, performance tuning, clustering, data sharing, secure data sharing, reader accounts, and AI/ML Functions.
• Experience with DataOps, DevOps, CI/CD, infrastructure-as-code, and automated data pipeline testing, including GitHub Actions, GitLab CI, Azure DevOps, Terraform, or CloudFormation.
• Familiarity with Great Expectations, Monte Carlo, Datafold, Soda, Alation, or Collibra.
• Experience with Kafka, Kinesis, or MSK, and exposure to ML feature engineering pipelines or MLOps practices.
• P&C insurance industry experience, specifically auto insurance experience, and experience with Guidewire PolicyCenter, ClaimCenter, BillingCenter, or Agency Licensing data.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent relevant experience or certifications.

Culture & Benefits

• Opportunity to lead the technical direction of an enterprise-wide data platform and shape the organization’s data strategy.
• Work with modern cloud-native technologies in a collaborative, growth-oriented environment.
• Strong investment in data modernization and professional development.
• Hybrid work from local hirify.global offices or remote work with travel for non-local candidates.
• Medical, dental, vision, paid time off, 401(k), and other hirify.global benefits.