Sr. SQL Developer; ISA

• Salary: $ USD - $ USD

SCRAM Systems is a leading provider of alcohol and location monitoring hardware, software, and mobile apps, including the SCRAM Continuous Alcohol Monitoring ® (SCRAM CAM ® ) bracelet, the Life Safer ® L250 Ignition Interlock device, and Life Safer Intelligence Speed Assistance. We provide an integrated approach to supporting our customers by offering solutions specific to court and agency needs in the community corrections industry throughout all phases of client management.

As a company, we are committed to continuing our tradition of re‑engineering operations to streamline processes, enhance productivity, and improve client outcomes through constant innovation. Our purpose is to change lives, reunite families, and make our communities safer through advanced technology and world‑class service.

The Senior SQL / Reporting Developer will play a key role in designing, building, and maintaining Life Safer’s reports for internal reporting and data delivery systems. This position works closely with engineering, product, and business stakeholders to deliver reliable, performant, and scalable reporting solutions using Microsoft SQL Server, SSRS, C#, and Life Safer’s custom internal reporting framework. This role requires deep expertise in SQL development, strong reporting and data modeling skills, C# development experience, and the ability to operate independently on complex systems while mentoring other developers and influencing technical direction.

• Design, develop, and maintain complex SQL Server‑based reporting solutions
• Integrate reporting into internal and external systems using C#
• Build and optimize stored procedures, views, and supporting database objects for reporting & analytics
• Develop and maintain SSRS reports for automated delivery (scheduled subscriptions, PDF/email distribution) and integration into internal and external web applications
• Implement reporting solutions using Life Safer’s custom internal reporting framework using both SQL and C#
• Partner with other development teams to integrate and understand reporting data into application workflows
• Analyze large datasets to support compliance, operations, and business decision‑making
• Perform advanced ad‑hoc and investigative queries for both technical and non‑technical stakeholders
• Ensure reporting accuracy, performance, scalability, and long‑term maintainability
• Troubleshoot and resolve performance issues related to queries, reports, and data pipelines
• Review and improve existing reporting solutions, queries, and database designs
• Provide technical guidance and mentorship to junior developers and analysts
• Participate in architectural discussions related to data access, reporting strategy, and system evolution

• Advanced queries (CTEs, window functions, indexing strategies, performance
• Strong experience developing SSRS reports, including parameterized reports and
• Proven experience building or working within custom reporting frameworks or data platforms
• Strong experience using C# to integrate reporting into internal and external systems
• Strong understanding of relational data modeling and reporting‑oriented schema design
• Ability to independently own and deliver complex reporting initiatives end‑to‑end
• Experience supporting large, business‑critical reporting systems
• Familiarity with regulated or compliance‑driven environments
• Experience mentoring junior developers or acting as a technical lead
• Exposure to performance monitoring and optimization of high‑volume reporting workloads

• 8+ years of professional SQL Server development experience
• 5+ years of professional experience in C# development
• SQL Server 2016 or later strongly preferred
• Experience collaborating with application developers, particularly in C# / .NET
• Extensive experience writing and maintaining:
• Complex

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.