Data Warehouse Analytics Specialist

Data Warehouse & Analytics SpecialistLocation: Sandy Utah (100% On-Site)Department: Research Operations and R&DAbout Challenger SchoolChallenger 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 OverviewChallenger 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 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 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 position is heavily focused on SQL/PYTHON documentation data quality warehouse analysis semantic consistency and business understanding rather than dashboard design or software SQL/PYTHON queries views reports source systems and warehouse structures to understand how business metrics are data lineage from operational systems through data warehouse transformations reporting layers and semantic technical data logic into clear business and maintain business glossaries data dictionaries metric definitions and metadata report outputs against source systems and warehouse the development and maintenance of Snowflake semantic and maintain mappings between business terminology and physical database and validate AI-generated SQL/PYTHON analytics and business with stakeholders to standardize business definitions and reporting data quality reconciliation governance and AI-readiness prepare trusted data assets for natural-language querying AI-assisted reporting and future analytics QualificationsStrong SQL/PYTHON working with relational databases data warehouses or cloud data to understand complex query logic and data analytical and problem-solving written communication and documentation attention to to work effectively with technical and nontechnical QualificationsExperience with Snowflake or similar cloud data warehouse intelligence or reporting documenting business rules metrics or data with semantic models governed metrics or metadata with Python for data analysis or with AI-assisted analytics tools and CandidateThe 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 dental and vision insurance401(k)Paid time offProfessional development opportunitiesLong-term career growth in analytics data warehousing semantic modeling data governance and AI-enabled data systemsIf 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