Senior Data Architect - Hybrid/Remote Data Platform Lead

Colonial Group; Topeka (KS); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive salary

Annual bonus

PTO & holidays

Parental leave

Medical, dental & vision insurance

401(k) match

Profit Sharing

Disability insurance

FSAs

Life Insurance

Educational assistance

Employee assistance program

Job summary

Security Benefit is seeking an experienced Senior Data Architect to lead data architecture for multi-source initiatives and mentor other architects. The role supports a unified data platform strategy with Snowflake, AWS, and Python tooling, reporting to the Director of Data Platform Architecture & Operations.

Remote/hybrid work is available for the right candidate, with an emphasis on delivering scalable data solutions in a regulated industry.

Qualifications

• Minimum 5 years of experience in data architecture or data engineering with architecture ownership.
• Hands-on experience with Snowflake and ELT tooling (Fivetran, Coalesce, dbt).
• Strong experience with AWS data services (S3, Glue, Lambda, Step Functions, API Gateway).
• Proficiency in Python for data engineering automation and validation scripting.
• Experience designing REST and event-driven API integration patterns.
• Knowledge of data governance, data lineage, and data quality practices; Collibra or equivalent catalog.
• Experience in financial services or regulated industry preferred.

Responsibilities

• Lead data architecture for complex, multi-source initiatives including enterprise data pipelines, platform migrations, API-based integrations, and third-party system integrations.
• Define and enforce data architecture standards, pipeline design patterns, and API integration patterns within the domain.
• Architect data solutions on Snowflake, Coalesce, Fivetran, and AWS (Lambda, Glue, S3, Step Functions, API Gateway); ensure alignment between ingestion, transformation, and storage patterns under the Snowflake-First architecture.
• Lead API integration architecture for data ingestion from REST, GraphQL, and event-driven API sources; define API contract evaluation standards and source system connectivity patterns.
• Develop and maintain Python-based tooling for architecture validation, automation scripting, and shared engineering utilities across the architecture team.
• Lead data architecture and integration design reviews for significant data initiatives within the domain.
• Lead migration architecture for legacy-to-modern data platform transitions (MS SQL Server/SSIS to Snowflake/ACUMEN), including report repointing from CDR, FAR, MCS, and SQL Server to Snowflake.
• Partner with Data Governance team to ensure designs support lineage, quality, and classification requirements; govern Collibra catalog alignment.
• Document architectural decisions using ADRs and maintain the domain architecture knowledge base in Confluence.
• Mentor Data Architects (IC2) and provide architectural guidance to Data Engineers

Skills

Python

Snowflake

ELT tooling

AWS data services

REST & GraphQL APIs

Data governance

Collibra

Financial services experience

Education

Bachelor's degree in Computer Science/Information Systems/Data Management or related field

Tools

Fivetran

Coalesce

dbt

Job description

Security Benefit is seeking an experienced Senior Data Architect to lead data architecture for multi-source initiatives and mentor other architects. The role supports a unified data platform strategy with Snowflake, AWS, and Python tooling, reporting to the Director of Data Platform Architecture & Operations.

Remote/hybrid work is available for the right candidate, with an emphasis on delivering scalable data solutions in a regulated industry.