Senior Data Engineer, Data Products — Snowflake & AI

Focus on the Family; Colorado Springs (CO); On-site; USD 96,000 - 112,000; Full time

Benefits offered by this job

Norton LifeLock ID Theft Coverage

Legal Shield/ID Shield Coverage

AFLAC

403B Retirement Plan

Vacation Time & Payout

Sick Time

Holidays

Service Awards

Community Service Days

Bookstore Discount

Fitness Center

Job summary

Focus on the Family in Colorado Springs is seeking a Senior Data Engineer to design, build, and optimize certified data products on the enterprise data platform. This on-site role enables ministry reporting, advanced analytics, and AI-enabled data consumption through governed datasets and semantic models.

You will translate reporting needs into reusable data assets, own data products end to end, and collaborate with ministry departments to maintain consistent KPIs for both human and machine

Qualifications

• Bachelor's degree or equivalent professional experience.
• 5-7 years of data engineering, data warehousing, or BI development experience, including 3+ years on a cloud data platform (Snowflake preferred).
• Advanced SQL experience with window functions, optimization, and complex transformations.
• Proficiency in Python for pipeline development including Snowpark, stored procedures, or automation scripting.
• Experience designing and building ETL/ELT pipelines with ingestion from APIs, SFTP, or replication tools such as Fivetran.
• Knowledge of dimensional modeling and semantic layer design affecting reporting and AI consumption.
• Familiarity with RBAC, least-privilege, and data security/privacy practices.
• Experience with version control (Git) and deployment/change management for database code.
• Experience with BI platforms like Power BI, Tableau, Looker, or Sigma.

Responsibilities

• Design and build Snowflake-centric solutions with optimized views, data models, and stored procedures for BI, analytics, and data quality.
• Build semantic views defining ministry metrics and relationships for BI and AI querying.
• Create durable ETL/ELT pipelines using SQL and Python (Snowpark, stored procedures) in collaboration with the Data Warehouse Manager.
• Implement Snowflake Tasks/Streams or equivalent orchestration for reliable processing.
• Manage database code changes with version control and a defined deployment process including testing before production.
• Own certified data products end to end: definition, documentation, quality tests, versioning, and deprecation.

Skills

Advanced SQL

Python

Data warehousing

ETL/ELT pipelines

Data governance

BI/Analytics concepts

Version control

Education

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

Tools

Snowflake

Snowpark

Python

SQL

Git

Fivetran

SFTP

APIs

Snowflake Cortex

Snowflake Copilot

GitHub Copilot

Job description

Focus on the Family in Colorado Springs is seeking a Senior Data Engineer to design, build, and optimize certified data products on the enterprise data platform. This on-site role enables ministry reporting, advanced analytics, and AI-enabled data consumption through governed datasets and semantic models.

You will translate reporting needs into reusable data assets, own data products end to end, and collaborate with ministry departments to maintain consistent KPIs for both human and machine