Sr. Data Engineer, Data Products

Build certified, Snowflake-based data products that power ministry reporting, advanced analytics, and AI-enabled data consumption.

Responsibilities

• Design and build Snowflake-centric solutions, including optimized views, data models, and stored procedures for BI, analytics, business operations, and data quality.
• Create and certify semantic views that define ministry metrics, dimensions, and relationships for consistent consumption by both traditional BI and AI-driven natural language querying (for example, Snowflake Cortex Analyst).
• Build 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 enable 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.
• Represent certified data products for multiple (5–10) ministry departments, translating recurring questions into reusable certified datasets instead of one-off reports.
• Monitor and optimize Snowflake performance, storage utilization, and query execution.
• Advise on and support 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 they provide 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 outputs with ministry reporting needs.
• Support data migration and modernization, 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 (for example, GitHub Copilot and 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 (for example, 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 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 a structured deployment and change management process 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, Snowflake 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 (for example, Salesforce objects and SOQL), especially nonprofit/NPSP data models.
• Migration from legacy on-premises platforms (for example, SQL Server, SSRS) to a cloud data warehouse.
• SnowPro Core certification or equivalent.

Schedule, Location, and Salary

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

Application Materials

• Cover Letter, Resume/CV
• Colorado Residents: age-identifying information such as age, date of birth, or dates of school attendance/graduation may be redacted or removed; no penalty for redacting.
• In the cover letter, identify job-specific minimum qualifications; ensure resume includes relevant experience for assessment.
• Submit: (1) current resume, (2) cover letter addressing job requirements and qualifications.

Benefits (Eligible Based on Weekly Hours)

• 20+ hours/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
• 30+ hours/week: all above plus Medical Plan, Dental Plan, Vision Plan, Life Insurance, Disability Insurance, Flexible Spending Accounts, EAP (Employee Assistance Program), Tuition Reimbursement, Warehouse Membership Reimbursement
• Temporary employees: eligible for Sick Time, Bookstore Discount, Fitness Center only

Timeline

• Priority consideration: applications submitted by September 28, 2026; posting remains open until filled.
• Potential start date: October 12, 2026
• Posting date: August 28, 2026
• Un-posting date: ongoing until filled

Contact: [email protected]

Personal Characteristics

• Creative thinker; effective problem-solver
• Self-motivated; requires little direct supervision
• Analytical and organized mindset
• Team player; trustworthy; reliable
• Dedicated to superior individual performance and team effectiveness
• Coachable; able to redirect priorities and assignments as requested

Skills, Abilities, and Talents

• Strong software engineering discipline, including testing, peer review, and documentation
• 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 for complex problems
• Ability to work independently and in a team setting
• Clear written communication and ability to produce technical documentation others can use

Character and Spiritual

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