Remote Data Engineer - Build Snowflake-First Data Pipelines

Security-Benefit-; Topeka (KS); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Competitive salary

401(k) with company match

PTO and holidays

Parental leave

Educational assistance

Disability Insurance

Job summary

Security Benefit is seeking an experienced Data Engineer to design and maintain data pipelines within the ACUMEN data platform (Snowflake, Fivetran, Coalesce, AWS). You will own data transformations, ensure quality, and support migration from legacy MS SQL Server/SSIS while collaborating with architects and analysts.

Role can be based in Topeka or remote for the right candidate, with a hybrid schedule offering on-site and remote work flexibility.

Qualifications

• Bachelor's degree or higher in Computer Science, Data Engineering or related field.
• 2-4 years of data engineering experience.
• Strong SQL proficiency including complex queries and performance tuning.
• Experience with Snowflake or a comparable cloud data warehouse.

Responsibilities

• Independently develop, test, and deploy data pipelines and transformations using Snowflake, Coalesce, Fivetran, and AWS services.
• Implement ELT processes following the Extract-Load-Transform architecture 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 line with platform standards.
• Document pipelines including data flow diagrams, source-to-target maps, and transformation logic in Confluence.
• Support legacy system data operations during migration and help repoint reports to Snowflake.

Skills

SQL proficiency

Snowflake

Coalesce

dbt

Fivetran

AWS data services

Git & CI/CD

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field

Tools

Snowflake

Coalesce

Fivetran

dbt

S3

Glue

Lambda

Job description

Security Benefit is seeking an experienced Data Engineer to design and maintain data pipelines within the ACUMEN data platform (Snowflake, Fivetran, Coalesce, AWS). You will own data transformations, ensure quality, and support migration from legacy MS SQL Server/SSIS while collaborating with architects and analysts.

Role can be based in Topeka or remote for the right candidate, with a hybrid schedule offering on-site and remote work flexibility.