Enterprise Data Engineer - Snowflake, DBT Pipelines

Sammons Financial Group Companies; West Des Moines (IA); On-site; USD 95,311 - 158,851; Full time

Benefits offered by this job

Health coverage

ESOP

401(k)

Fridays off

Paid time off

Tuition reimbursement

Professional development

Volunteer time off

Nonprofit matching

Ownership culture

Job summary

Sammons Financial Group is seeking a Systems Analyst at Level 2 or 3 to design and implement scalable data pipelines. The role emphasizes Snowflake, SQL, and dbt, with strong integration across enterprise systems and a blend of hands-on delivery and strategic planning.

The ideal candidate will have a CS/IS degree and 8+ years' IT development experience, plus excellent communication and problem-solving abilities.

Qualifications

• College Degree in computer science, information science, MIS preferred.
• Minimum 8 years IT development experience or equivalent preferred.
• Excellent verbal and written communication with business partners and IT staff.
• Strong problem solving and multi-tasking abilities to meet deadlines.
• Ability to lead and coordinate team members without HR management responsibility.
• Knowledge of programming languages as required for the system.

Responsibilities

• Design, develop, and implement scalable data pipelines and ELT/ETL solutions using Snowflake and modern data engineering frameworks.
• Develop and manage data transformations and orchestration using dbt, ADF, ADL, or comparable tools.
• Integrate Snowflake with enterprise systems and cloud data platforms.
• Collaborate with product owner, architects, and developers to translate requirements into scalable data solutions.
• Translate business and technical requirements into effective data models and pipelines.
• Establish and enforce data engineering standards, governance, and QA.
• Monitor pipeline performance, reliability, and cost; implement improvements.
• Research and adopt emerging data delivery tools and patterns.

Skills

Snowflake

SQL

dbt

ETL/ELT

Data pipelines

Communication skills

8+ years IT experience

Education

Bachelor's degree in CS/IS

Tools

Azure Data Factory

Azure Data Lake

MuleSoft

Kafka

REST APIs

Job description

Sammons Financial Group is seeking a Systems Analyst at Level 2 or 3 to design and implement scalable data pipelines. The role emphasizes Snowflake, SQL, and dbt, with strong integration across enterprise systems and a blend of hands-on delivery and strategic planning.

The ideal candidate will have a CS/IS degree and 8+ years' IT development experience, plus excellent communication and problem-solving abilities.