Compass Technology Salary: $120,000-$130,000 Who We Are 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. Compass Group is the leading foodservice management and support services company, with $26 billion in revenue in 2023. In 2023, Compass Group was named one of Forbes’ America’s Best Large Employers along Springbuk’s Healthiest 100 Workplaces in America (since 2019). Job Summary + Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements. + Develop enterprise level ETL processes that include process logging, data validation, data integrity checks. + Automate complex processes using SQL agent jobs, SQL Server Integration Services, etc. + Ensure accuracy and integrity of data through the development of constraints and validation rules. + Implement database performance monitoring and tuning. + Manage SQL code in a source control system. + Establish and enforce SQL development coding standards and best practices. + Lead/participate in SQL code reviews. + Deep knowledge and experience in SQL Server and T-SQP with respect to troubleshooting and optimizing queries and stored procedures. + Provide technical mentoring and coaching for junior and mid-level database developers and data quality analysts. Job Qualifications + Overall 5+ years of enterprise software development experience with specifics in data + warehousing or enterprise operational data marts. + Database: MS SQL Server 2019. + Working understanding of cloud development principles and software design patterns. + Experience with CI\CD, Git, and ADO Pipelines + Strong Experience with Scrum, Agile Process, Unit Testing using Test Driven Development. + Continuous learner, process improver. + Excellent time management skills and ability to work on concurrent assignments with + different priorities. + Excellent communications skills and ability to work collaboratively across several teams. + C# Development experience or EFCore exposure a plus + Snowflake experience\knowledge a plus + AWS Managed Database Experience a plus. + Database Wizard JD Apply to Compass Group today! Click here to Learn More about the Compass Story (http://www.compass-usa.com/our-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) 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 (https://www.compass-usa.com/wp-content/uploads/2023/08/2023\_WageTransparency\_CorpAndFoodbuy.pdf) for paid time off benefits information. Req ID: 1393352 Compass Technology MARY DICKSON