Data Engineer Data Warehouse Developer Jobs in Colorado

The Sr. Data Engineer, Data Products position exists to design, build, and optimize certified data products on the ministry’s enterprise data platform. This position develops and tests governed, reusable data sets, semantic models, and pipelines that support ministry reporting, advanced analytics, and AI-enabled consumption, partnering with ministry departments so that key performance indicators are accurate, trusted, and consistently defined across the organization.

Essential Duties/Responsibilities:

Development:

• Designs and builds Snowflake-centric solutions — including optimized views, data models, and stored procedures — that support business intelligence, analytics, business operations, and data quality.

• Builds and certifies semantic views defining ministry metrics, dimensions, and relationships, structured to serve both traditional BI consumption and AI-driven natural language querying (e.g., Snowflake Cortex Analyst), so that measures are represented consistently for human and machine consumers.

• Builds 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.

• Develops and maintains scheduled automation (Snowflake Tasks, Streams, or equivalent orchestration tooling) to support reliable, hands-off data processing.

• Manages database code changes through version control and a defined deployment process, testing and validating pipelines and data objects prior to promotion to production.

Data Products & Governance:

• Owns assigned certified data products end to end — definition, documentation, quality tests, versioning, and deprecation — so ministry departments can consume them with confidence and without rework.

• Serves as the data product representative for multiple (5–10) ministry departments, translating recurring business questions into certified, reusable data sets rather than one-off reports.

• Monitors and optimizes Snowflake performance, storage utilization, and query execution.

• Advises on, supports, and implements governance standards for least privilege, security, and privacy, including role-based access control, row-level security, and data masking.

• Evaluates and implements Snowflake AI capabilities (e.g., Cortex functions for document processing, classification, or forecasting) where they provide clear business value, in collaboration with data governance stakeholders.

• Adheres to organizational data privacy and security policies when using AI tools of any kind, ensuring no sensitive or regulated data is submitted to external or unapproved AI services.

Collaboration & Documentation:

• Partners with business stakeholders, engineers, and analysts to gather requirements, confirm data product definitions, and ensure alignment with ministry reporting needs.

• Supports data migration and modernization efforts, including migration from on-premises legacy platforms (e.g., SQL Server, SSRS) to the enterprise data platform.

• Identifies data processing and data quality issues in collaboration with the Data Quality Analyst.

• Develops technical documentation and apply metadata tagging to convey lineage, ownership, and approved usage.

• Uses AI-assisted development tools (e.g., GitHub Copilot, Snowflake Copilot) to improve development speed and code quality, while retaining full responsibility for validating, testing, and securing all AI-assisted output before deployment.

Other Duties/Responsibilities:

• Performs other duties as assigned

Managerial Breadth/Scope of Job:

• None

Working Environment/Physical Requirements:

• Office environment
  
• Must be able to work at a computer workstation for multiple hours with infrequent interruption

JOB QUALIFICATIONS/REQUIREMENTS

Character/Spiritual:

Exemplifies Ephesians 5:1-2, “Therefore be imitators of God as dear children and walk in love, as Christ also has loved us and given Himself for us...”

Pursues the Great Commission given by Jesus Christ in Matthew 28:19-20, “Go therefore and make disciples of all the nations, baptizing them in the name of the Father and of the Son and of the Holy Spirit, teaching them to observe all things that I have commanded you; and lo, I am with you always, even to the end of the age.”

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

Demonstrates behaviors aligned with FOF core values

Personal Characteristics:

• Creative thinker, effective problem-solver

• Self-Motivated; requires little direct supervision

• Analytical, organized mindset

• Team player; trustworthy; reliable

• Dedicated to superior individual performance and team effectiveness

• Coachable, able to redirect work priorities and assignments as requested

Knowledge/Experience:

• 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, and 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 process for database code.

• Experience with a modern BI/analytics platform (e.g., Power BI, Tableau, Looker, Sigma).

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.

Skills, Abilities, and Special Talents/Gifts:

• 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

• Expertise to handle multiple projects and adhere to strict deadlines and budgets

• Exceptional analytical ability and logical thought process to deal with complex problems

• Ability to work independently and in a team setting

• Clear written communication, with demonstrated ability to produce technical documentation others can use.

Pay Range: $95,800 to $111,892

Application Materials Required: Cover Letter, Resume/CV

*Colorado Residents: In any materials you submit, you may redact or remove any age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.

Application Materials Instructions: Please identify the job specific minimum qualifications you possess in your cover letter and be sure your resume includes any and all relevant experience to be accurately assessed against the qualifications listed in the posting. To apply, please submit the following application materials to this posting. 1. A current resume. 2. A cover letter that specifically addresses the job requirements and outlines qualifications.

Focus on the Family puts a high value on our team members and offers a unique benefit package.

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

Note: This is a summary and should not be construed as future promises to continue to provide benefits as outlined above. For complete and definitive language, refer to the governing plan documents. 

*Temporary employees are not eligible for benefits, except for:

• Sick Time
• Bookstore Discount
• Fitness Center

Tentative Search Timeline:

• Priority will be given to applications submitted by September 28, 2026.  However, this posting will remain open until filled. 
• The potential employee start date is October 12, 2026

Posting date:  August 28, 2026

Un-posting date: ongoing until filled

Posting contact email: job@fotf.org