Data Warehouse Analytics Specialist

Data Warehouse & Analytics Specialist

Location: Sandy, Utah (100% On-Site)

Department: Research, Operations, and R&D

About Challenger School

Challenger School is an independent private school organization committed to providing exceptional education and fostering critical thinking, personal responsibility, and intellectual growth. Our Research & Development team supports data-driven decision making across the organization and is actively building modern analytics, data warehouse, semantic modeling, and AI-enabled capabilities.

Position Overview

Challenger School is seeking a Data Warehouse & Analytics Specialist to help build trustworthy, well-documented, AI-ready data assets that support reporting, analytics, research, and operational decision making.

This role combines SQL/PYTHON analysis, data warehousing, semantic modeling, business intelligence, data governance, reporting validation, and AI-enabled analytics. The position serves as a bridge between technical systems and business users by translating database structures, reports, and metrics into clear, consistent business definitions.

The ideal candidate enjoys working deeply with SQL/PYTHON, understanding how business metrics are calculated, documenting data definitions, resolving inconsistencies, validating reports, and helping create reliable data structures that can be used by analysts, business users, and AI systems.

This position is heavily focused on SQL/PYTHON, documentation, data quality, warehouse analysis, semantic consistency, and business understanding rather than dashboard design or software engineering.

Responsibilities

• Analyze SQL/PYTHON queries, views, reports, source systems, and warehouse structures to understand how business metrics are calculated.
• Trace data lineage from operational systems through data warehouse transformations, reporting layers, and semantic models.
• Translate technical data logic into clear business definitions.
• Develop and maintain business glossaries, data dictionaries, metric definitions, and metadata documentation.
• Validate report outputs against source systems and warehouse data.
• Support the development and maintenance of Snowflake semantic models.
• Create and maintain mappings between business terminology and physical database structures.
• Review and validate AI-generated SQL/PYTHON, analytics, and business insights.
• Work with stakeholders to standardize business definitions and reporting logic.
• Support data quality, reconciliation, governance, and AI-readiness initiatives.
• Help prepare trusted data assets for natural-language querying, AI-assisted reporting, and future analytics initiatives.

Required Qualifications

• Strong SQL/PYTHON skills.
• Experience working with relational databases, data warehouses, or cloud data platforms.
• Ability to understand complex query logic and data transformations.
• Strong analytical and problem-solving abilities.
• Excellent written communication and documentation skills.
• Strong attention to detail.
• Ability to work effectively with technical and nontechnical stakeholders.

Preferred Qualifications

• Experience with Snowflake or similar cloud data warehouse platforms.
• Business intelligence or reporting experience.
• Experience documenting business rules, metrics, or data definitions.
• Familiarity with semantic models, governed metrics, or metadata management.
• Experience with Python for data analysis or validation.
• Familiarity with AI-assisted analytics tools and workflows.

Ideal Candidate

The ideal candidate enjoys solving data puzzles, untangling complex business logic, identifying why reports disagree, and transforming technical information into clear business definitions. They are patient, precise, intellectually curious, and committed to data quality, consistency, and accuracy.

Benefits

• Medical, dental, and vision insurance
• 401(k)
• Paid time off
• Professional development opportunities
• Long-term career growth in analytics, data warehousing, semantic modeling, data governance, and AI-enabled data systems

If you enjoy detailed analytical work and want to help build the foundation for data-driven decision making across a growing educational organization, we encourage you to apply.

#CSURGENT