Salary: $130,000-$140,000
Reports To: Development Manager
Compass Technology is a dedicated internal team for Compass Group delivering enterprise-wide initiatives that support our diverse customer base and enhance our business operations. Our domain encompasses a vast spectrum of opportunities, from hands-on desk support to Cybersecurity, Cloud Engineering, AI, and Modern Application development. We are committed to building robust IT infrastructures, driving digital transformation, and much more.
Job Summary
The Supply Chain Reporting Engineer is responsible for designing, developing, and supporting enterprise reporting solutions across both legacy and modern analytics platforms. This role serves as a critical bridge between existing SQL Server-based reporting environments and the organization's evolving Snowflake data platform, ensuring continuity of business reporting while advancing modernization efforts.
The ideal candidate possesses deep SQL development expertise, strong data modeling skills, and hands-on experience working with Snowflake to deliver scalable reporting and analytics solutions for sourcing, procurement, supplier performance, inventory, and supply chain operations.
Key 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.
Required Qualifications
- 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.
Preferred Qualifications
- Snowflake
- SnowSQL
- dbt
- SQL Server
- ETL (SSIS)
- SSAS Cube
- Query Optimization & Performance Tuning
- Data Modeling
- GitHub/Version Control
Apply to Compass Group today!
Click here to Learn More about the Compass Story
Compass Group is an equal opportunity employer. At Compass, we are committed to treating all Applicants and Associates fairly based on their abilities, achievements, and experience without regard to race, national origin, sex, age, disability, veteran status, sexual orientation, gender identity, or any other classification protected by law.
Qualified candidates must be able to perform the essential functions of this position satisfactorily with or without a reasonable accommodation. Disclaimer: this job post is not necessarily an exhaustive list of all essential responsibilities, skills, tasks, or requirements associated with this position. While this is intended to be an accurate reflection of the position posted, the Company reserves the right to modify or change the essential functions of the job based on business necessity. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act.
Compass Technology maintains a drug-free workplace.
Applications are accepted on an ongoing basis.
Associates at Corporate are offered many fantastic benefits.
- Medical
- Dental
- Vision
- Life Insurance/ AD
- Disability Insurance
- Retirement Plan
- Paid Time Off
- Holiday Time Off (varies by site/state)
- Associate Shopping Program
- Health and Wellness Programs
- Discount Marketplace
- Identity Theft Protection
- Pet Insurance
- Commuter Benefits
- Employee Assistance Program
- Flexible Spending Accounts (FSAs)
- Paid Parental Leave
- Personal Leave
Associates may also be eligible for paid and/or unpaid time off benefits in accordance with applicable federal, state, and local laws. For positions in Washington State, Maryland, or to be p formed Remotely, click here or copy/paste the link below for paid time off benefits information.
https://www.compass-usa.com/wp-content/uploads/2023/08/2023_WageTransparency_CorpAndFoodbuy.pdf
Certain positions may require Florida Level 2 background screening. Details: https://info.flclearinghouse.com/
Req ID: 1540476
Compass Technology
MARY DICKSON
