Sr. Data Engineer, Data Products

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 is looking for a senior data engineer to design, build, and optimize certified data products on its enterprise data platform. In this onsite Colorado Springs role, you will help enable ministry reporting, advanced analytics, and AI-enabled data consumption through governed datasets, semantic models, and reliable pipelines.

As a product owner across multiple ministry departments, you will translate recurring reporting needs into reusable, trustworthy data assets that support consistent KPIs for both human and machine consumers.

What you'll do

• Design and build Snowflake-centric solutions including optimized views, data models, and stored procedures for business intelligence, analytics, business operations, and data quality.
• Build and certify semantic views that define ministry metrics, dimensions, and relationships for traditional BI and AI-driven natural language querying (such as Snowflake Cortex Analyst), keeping measures consistent across consumers.
• Create durable, optimized ETL/ELT pipelines for data ingress and egress using SQL and Python, including Snowpark and Python stored procedures, in collaboration with the Data Warehouse Manager.
• Implement scheduled automation using Snowflake Tasks, Streams, or equivalent orchestration tooling to support reliable, hands-off processing.
• Manage database code changes with version control and a defined deployment process, including testing and validation of pipelines and data objects before promoting to production.
• Own assigned certified data products end to end, including definition, documentation, quality tests, versioning, and deprecation so ministry departments can consume them without rework.
• Represent the data product for 5-10 ministry departments, translating repeated business questions into certified datasets rather than one-off reports.
• Monitor and optimize Snowflake performance, storage utilization, and query execution.
• Advise on and implement governance standards for least privilege, security, and privacy, including role-based access control, row-level security, and data masking.
• Evaluate and implement Snowflake AI capabilities (for example, Cortex functions for document processing, classification, or forecasting) when there is clear business value, working with data governance stakeholders.
• Follow organizational data privacy and security policies when using AI tools, ensuring no sensitive or regulated data is submitted to external or unapproved AI services.
• Partner with business stakeholders, engineers, and analysts to gather requirements, confirm data product definitions, and align deliverables with ministry reporting needs.
• Support data migration and modernization efforts, including migration from on-premises legacy platforms such as SQL Server and SSRS to the enterprise data platform.
• Identify data processing and data quality issues in collaboration with the Data Quality Analyst.
• Develop technical documentation and apply metadata tagging to communicate lineage, ownership, and approved usage.
• Use AI-assisted development tools (such as GitHub Copilot and Snowflake Copilot) while retaining full responsibility for validating, testing, and securing AI-assisted output before deployment.
• Perform other duties as assigned.

What you bring

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent professional experience.
• 5-7 years of data engineering, data warehousing, or business intelligence development experience, including 3+ years building on a cloud data platform (Snowflake preferred).
• Advanced SQL experience, including window functions, query optimization, and complex transformations.
• Working proficiency in Python for pipeline development, including Snowpark, stored procedures, or automation scripting.
• Experience designing and building ETL/ELT pipelines, including ingestion from external sources (APIs, SFTP, or replication tools such as Fivetran).
• Knowledge of dimensional modeling and semantic layer design, including how upstream modeling impacts downstream reporting and AI consumption.
• Familiarity with role-based access control, least-privilege principles, and data security and privacy practices.
• Experience with version control (for example, Git) and structured deployment/change management for database code.
• Experience with a modern BI/analytics platform such as Power BI, Tableau, Looker, or Sigma.

Technologies

• Snowflake, Snowpark, Python, SQL
• Snowflake Tasks, Streams
• Snowflake Cortex Analyst, Snowflake Cortex
• Git, GitHub Copilot, Snowflake Copilot
• Power BI, Tableau, Looker, Sigma
• Fivetran, SFTP, APIs
• Role-based access control, row-level security, data masking
• AI tools
• SQL Server, SSRS
• Metadata tagging

Preferred qualifications

• Snowflake-specific features such as Tasks, Streams, Time Travel, Snowpark, external access integrations, or Cortex AI functions.
• Transformation frameworks such as dbt, including model testing, lineage, and CI/CD for analytics code.
• CRM data structures (for example, Salesforce objects and SOQL), especially nonprofit/NPSP data models.
• Migration experience from legacy on-premises platforms (such as SQL Server and SSRS) to a cloud data warehouse.
• SnowPro Core certification or equivalent.

Role fit and expectations

• Exemplifies Ephesians 5:1-2 and pursues the Great Commission (Matthew 28:19-20).
• Maintains a courteous, Christ-like attitude and adheres to the Standard of Moral Conduct and Statement of Faith, upholding Focus on the Family's ministry in prayer.
• Prays personally for Focus on the Family's staff and constituents and may occasionally lead in a public prayer.
• Engages in Christian ministry and demonstrates behaviors aligned with FOF core values.

Personal characteristics and skills

• Creative thinker with strong problem-solving and software engineering discipline, including testing, peer review, and documentation.
• Analytical and organized, attentive to detail, and focused on accuracy.
• Self-motivated and able to work with limited direct supervision.
• Team player who is trustworthy and reliable, with strong interpersonal and presentation skills.
• Customer-service mindset and professional demeanor; clear written communication and ability to produce technical documentation others can use.
• Ability to handle multiple projects, meet strict deadlines, and address complex problems with logical reasoning.
• Coachable, able to redirect work priorities and assignments as requested.

Compensation and location

• Location: Colorado Springs, CO (onsite)
• Salary range: USD 95,800 - 111,892 per year

Application requirements

• Cover Letter and Resume/CV
• Colorado residents may redact or remove age-identifying information (such as age, date of birth, or dates of school attendance or graduation) in any submitted materials.

Important dates

• Posting date: August 28, 2026
• Priority deadline: September 28, 2026 (applications may remain open until filled)
• Potential start date: October 12, 2026
• Status: Ongoing until filled

Benefits (eligible for employees scheduled 20 hours or more per week)

• Norton LifeLock ID Theft Coverage
• Legal Shield/ID Shield Coverage
• AFLAC
• 403B Retirement Plan
• Vacation Time & Vacation Payout
• Sick Time
• Holidays
• Service Awards
• Community Service Days
• Bookstore Discount
• Fitness Center

Benefits (eligible for employees scheduled 30 hours or more per week)

• Medical Plan, Dental Plan, Vision Plan
• Life Insurance and Disability Insurance
• Flexible Spending Accounts
• EAP (Employee Assistance Program)
• Tuition Reimbursement
• Warehouse Membership Reimbursement

Temporary employees are not eligible for benefits, except for: Sick Time, Bookstore Discount, and Fitness Center.