Data Engineer

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

We're Looking for an experienced Data Engineer!

About the Company:

Security Benefit is a leader in the U.S. retirement market with more than $60 billion in assets under management. We offer opportunities to thrive, innovate, and make an impact. As part of our team, you’ll play a key role in driving the future of the U.S. retirement industry. Security Benefit is a PLACE where we promise to help our customers To and Through Retirement.

• Named to Ward’s 50 list of top-performing life-health insurance companies
• Recognized on list of Ingram’s Top 100 Private Companies in the Kansas City area in 2024

About the Role:

The Data Engineer independently develops and maintains data pipelines, implements ELT processes, builds data transformations, and ensures data quality across DTS's ACUMEN data platform (Fivetran, Coalesce, Snowflake, AWS). This role takes ownership of assigned data engineering areas and collaborates with Data Architects and analysts to deliver reliable, well-documented data products supporting the Snowflake-First architecture.

The Data Engineer position reports to the Principal Data Integration Architect and can be based out of our home office in Topeka, Kansas, or remotely for the right candidate. We work a hybrid schedule, offering flexibility to work both remotely and on-site.

• Independently develop, test, and deploy data pipelines and transformations using Snowflake, Coalesce, Fivetran, and AWS services
• Implement ELT processes following DTS's Extract-Load-Transform architecture pattern 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, source-to-target maps, and transformation logic in Confluence
• Support legacy system data operations (MS SQL Server, SSIS) during migration period and contribute to repointing reports from legacy systems to Snowflake
• Participate in on-call rotation for data platform operations
• Follow DTS ACUMEN onboarding standards when integrating new data sources

What We’re Looking For:

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, 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
• Familiarity with Coalesce, dbt, Fivetran, or comparable ELT/pipeline tools
• Working knowledge of AWS data services (S3, Glue, Lambda)
• Familiarity with version control (Git) and CI/CD practices

Why Choose Security Benefit?

When you join our team, you’re not just getting a paycheck — you’re getting a career path full of growth opportunities, plus a robust benefits package that puts your well-being first. Here’s what you can expect as a full-time Security Benefit associate:

• Competitive salary and annual incentive bonuses to reward your contributions.
• 33 days of paid time off (including PTO, holidays, Volunteer Day, and days of significance).
• Paid parental leave after 90 days of service.
• Comprehensive medical, dental & vision insurance.
• 401(k) with company match, plus Profit Sharing & Savings Plan.
• Short- and Long-Term Disability Insurance to give you peace of mind.
• Flexible Spending Accounts for medical and dependent care.
• Life Insurance to protect your loved ones.
• Educational assistance to support your career development.
• Associate assistance programs for your personal and professional well-being.

Ready to Make an Impact?

Security Benefit is an Equal Opportunity Employer.