Remote Data Engineer: Snowflake ELT & Data Pipelines

Security Benefit; Topeka (KS); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive salary

Paid time off and holidays

Parental leave after 90 days

Medical, dental & vision insurance

401(k) with company match

Job summary

Security Benefit in Topeka, KS seeks a Data Engineer to develop and maintain data pipelines on the ACUMEN platform, using Snowflake, Fivetran, Coalesce and AWS. You will own ELT processes and ensure quality across analytics-ready datasets.

The role reports to the Principal Data Integration Architect and offers hybrid work with remote flexibility for the right candidate, collaborating with data architects and analysts to deliver reliable data products.

Qualifications

• 2-4 years of data engineering experience.
• Strong SQL proficiency with complex queries and performance tuning.
• Experience with Snowflake or a comparable cloud data warehouse.
• Familiarity with Coalesce, dbt, Fivetran, or similar ELT tools.
• Working knowledge of AWS data services (S3, Glue, Lambda).
• Familiarity with version control (Git) and CI/CD practices.

Responsibilities

• Independently develop, test, and deploy data pipelines and transformations using Snowflake, Coalesce, Fivetran, and AWS services.
• Implement ELT processes following Architecture patterns and Snowflake-First principles.
• Build and maintain Snowflake-native transformations, data marts, and analytics-ready datasets.
• Ensure data quality through validation logic, monitoring, automated testing, and alerting.
• Collaborate with Data Architects to implement designs in alignment with platform standards.
• Document pipelines including data flow diagrams and transformation logic in Confluence.
• Support legacy system data operations (MS SQL Server, SSIS) during migration period.
• Participate in on-call rotation for data platform operations.

Skills

SQL Proficiency

Snowflake

ELT Pipelines

AWS Services

Version Control

CI/CD

Education

Bachelor's degree in CS/IS

Tools

Snowflake

Coalesce

Fivetran

dbt

AWS

Git

Job description

Security Benefit in Topeka, KS seeks a Data Engineer to develop and maintain data pipelines on the ACUMEN platform, using Snowflake, Fivetran, Coalesce and AWS. You will own ELT processes and ensure quality across analytics-ready datasets.

The role reports to the Principal Data Integration Architect and offers hybrid work with remote flexibility for the right candidate, collaborating with data architects and analysts to deliver reliable data products.