Focus on the Family is seeking a Sr. Data Engineer, Data Products to design, build, and optimize certified data products on the organization’s enterprise data platform. This onsite role in Colorado Springs will support ministry reporting, advanced analytics, and AI-enabled consumption through governed datasets, semantic models, and reliable pipelines.
Location
Colorado Springs, CO (onsite)
Compensation
USD 95,800 - 111,892 per yearly
Experience and Education
- Minimum experience: 5 years
- Education: Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent professio
Summary
Design, build, and optimize certified data products on Focus on the Family’s enterprise data platform, supporting ministry reporting, advanced analytics, and AI-enabled consumption. Develop governed reusable datasets, semantic models, and pipelines with cross-department collaboration to ensure accurate and trusted KPIs.
Responsibilities
- Design and build Snowflake-centric solutions, including optimized views, data models, and stored procedures, supporting business intelligence, analytics, business operations, and data quality.
- Build and certify semantic views defining ministry metrics, dimensions, and relationships for both traditional BI consumption and AI-driven natural language querying (including Snowflake Cortex Analyst), ensuring consistent measures for human and machine 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.
- Develop and maintain 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 prior to production promotion.
- Own assigned certified data products end to end, including definition, documentation, quality tests, versioning, and deprecation to enable ministry departments to consume data without rework.
- Serve as the data product representative for multiple (5–10) ministry departments by translating recurring business questions into certified, reusable 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 (e.g., Cortex functions for document processing, classification, or forecasting) when they deliver clear business value, in collaboration 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 with ministry reporting needs.
- Support data migration and modernization, including migrations from on-premises legacy platforms (e.g., SQL Server, 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 (e.g., GitHub Copilot, Snowflake Copilot) to improve development speed and code quality, while retaining responsibility for validating, testing, and securing AI-assisted output before deployment.
- Perform other duties as assigned.
Requirements
- 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, including window functions, query optimization, and complex data transformations.
- Working proficiency in Python for data pipeline development (e.g., 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).
- Working knowledge of dimensional modeling and semantic layer design, including how upstream modeling decisions affect downstream reporting and AI consumption.
- Familiarity with role-based access control, least-privilege principles, and data security and privacy practices.
- Experience with version control (e.g., Git) and structured deployment and change management processes for database code.
- Experience with a modern BI/analytics platform (e.g., Power BI, Tableau, Looker, 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
- Snowflake-specific features: 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 (e.g., Salesforce objects and SOQL), particularly nonprofit/NPSP data models.
- Migration from legacy on-premises platforms (e.g., SQL Server, SSRS) to a cloud data warehouse.
- SnowPro Core certification or equivalent.
Personal and Professional Alignment
- Exemplifies Ephesians 5:1-2 (“Therefore be imitators of God as dear children and walk in love…”).
- Pursues the Great Commission given by Jesus Christ in Matthew 28:19-20.
- Is a consistent witness for Jesus Christ; maintains a courteous, Christ-like attitude in dealing with people within and outside of Focus; adheres to the Standard of Moral Conduct and Statement of Faith; upholds 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
- Creative thinker and effective problem-solver.
- Self-motivated with the ability to work with little direct supervision.
- Analytical and organized mindset.
- Team player; trustworthy and reliable.
- Dedicated to superior individual performance and team effectiveness.
- Coachable, able to redirect work priorities and assignments as requested.
Skills, Abilities, and Special Talents
- Strong software engineering discipline, including testing, peer review, and documentation.
- Demonstrated competence in data management and design of multiple large projects.
- Attention to detail and accuracy.
- Excellent interpersonal and presentation skills.
- Customer-service mindset and professional demeanor.
- Ability to handle multiple projects and adhere to strict deadlines and budgets.
- Exceptional analytical ability and logical thought process to address complex problems.
- Ability to work independently and in a team setting.
- Clear written communication, including producing technical documentation others can use.
Benefits (Eligible Roles)
Employees scheduled for 20 hours or more per week are eligible for:
- 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
Employees scheduled for 30 hours or more per week are eligible for all the above and:
- Medical Plan
- Dental Plan
- Vision Plan
- Life Insurance
- 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
- Fitness Center
Application Materials
Colorado Residents: In any materials submitted, age-identifying information such as age, date of birth, or dates of school attendance or graduation may be redacted or removed. Candidates will not be penalized for redacting or removing this information.
Application Instructions
- Identify the job specific minimum qualifications possessed in the cover letter and ensure the resume includes all relevant experience for accurate assessment against the posting requirements.
- Submit: (1) a current resume and (2) a cover letter that specifically addresses the job requirements and outlines qualifications.
Search Timeline
- Priority given to applications submitted by September 28, 2026
- Posting remains open until filled
- Potential start date: October 12, 2026
Posting Details
- Posting date: August 28, 2026
- Un-posting date: ongoing until filled
- Contact email: job@fotf.org
