SQL REPORTING ENGINEER-REMOTE

Compass Technology is a dedicated internal team for Compass Group delivering enterprise-wide initiatives that support diverse customer bases. The Supply Chain Reporting Engineer is responsible for designing, developing, and supporting enterprise reporting solutions, bridging SQL Server environments with the Snowflake data platform to ensure continuity and modernization of business reporting.

Responsibilities:

• SQL Reporting Development (Primary Focus)
• Develop and maintain ETL processes using SQL Server Integration Services (SSIS)
• Support analytical modeling using SQL Server Analysis Services (SSAS) cubes
• Design, develop, optimize, and support complex SQL-based reporting solutions
• Maintain and enhance existing operational and analytical reports built on SQL Server environments
• Develop stored procedures, views, and reporting datasets to support business requirements
• Troubleshoot reporting issues and optimize query performance across large datasets
• Partner with business stakeholders to validate reporting logic and KPI calculations
• Snowflake Analytics Development
• Write and optimize queries using SnowSQL for efficient data transformation and reporting
• Implement and manage data transformation pipelines using dbt (data build tool) to create modular, testable, and reusable data models
• Use GitHub for version control and collaboration, enabling CI/CD workflows and code management
• Build and maintain reporting-ready datasets within Snowflake
• Develop and support dimensional models and curated data products for supply chain analytics
• Collaborate with Data Engineers and Analytics Engineers to establish reporting best practices
• Support migration and modernization of reporting assets from legacy platforms to Snowflake
• Optimize Snowflake performance, cost efficiency, and query design

Requirements:

• 5+ years of SQL development experience in enterprise reporting environments
• Advanced SQL skills including: Complex joins, Window functions, CTEs, Query optimization, Stored procedures, Performance tuning
• 2+ years of Snowflake experience
• Experience supporting operational and executive reporting solutions
• Experience designing analytical datasets and reporting models
• Experience working with procurement, supply chain, sourcing, inventory, logistics, or related operational data
• Strong stakeholder management and requirements gathering skills
• Snowflake
• SnowSQL
• dbt
• SQL Server
• ETL (SSIS)
• SSAS Cube
• Query Optimization & Performance Tuning
• Data Modeling
• GitHub/Version Control