Job Description:
Company Overview:
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 LifeSafer® L250 Ignition Interlock device, and LifeSafer 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.
Shift: First Shift
The Senior SQL / Reporting Developer will play a key role in designing, building, and maintaining LifeSafer'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 LifeSafer'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.
#LI-PROMOTE
Experience and Skills:
Duties/Responsibilities:
- 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)
-
Integration into internal and external web applications
- Implement reporting solutions using LifeSafer'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
Skills/Abilities:
- Advanced queries (CTEs, window functions, indexing strategies, performance
- tuning)
- Strong experience developing SSRS reports, including parameterized reports and
- automated delivery
- 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
Education and Experience:
- 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
environments
- Extensive experience writing and maintaining:
- Complex
Physical Requirements (With or without reasonable accommodation):
*** 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. s
Comprehensive Benefits Package:
At SCRAM, we prioritize the well-being and financial security of our employees. We understand that benefits play a crucial role in ensuring our team members feel supported and valued. That's why we offer a comprehensive benefits package that includes:
- Retirement Savings:
-
401(k): We offer a 401(k)-retirement savings plan to help you plan for your future financial security.
-
401(k) Matching: SCRAM provides a 100% match for the first 3% contributed and another 50% match for the next 2% contributed, amplifying your savings potential.
-
Health and Wellness:
-
Health Insurance: We provide comprehensive health insurance coverage to safeguard your health and that of your family.
-
Dental Insurance: Our dental insurance plan ensures access to quality dental care for you and your dependents.
-
Vision Insurance: Take care of your vision health with our vision insurance coverage.
-
Health Savings Account (HSA): Our HSA option allows you to save pre-tax dollars for medical expenses, providing flexibility and savings opportunities. We strongly value saving for your wellness, so the company provides an employer contribution towards your HSA annually.
- Flexible Spending Account (FSA): With our FSA, you can set aside pre-tax dollars to cover eligible medical expenses not covered by your health insurance plan. You can also save pre-tax dollars to help cover the cost of child care with our Dependent Care FSA.
- Financial Protection:
-
Disability Insurance: We offer company paid short and long term disability insurance to provide financial protection in the event of injury or illness that prevents you from working.
- Life Insurance: Ensure the financial security of your loved ones with our company paid life insurance coverage at 1.5x your annual salary. Want more coverage – supplemental life is also available.
- Work-Life Balance:
-
Paid Time Off: We understand the importance of work-life balance. That's why we provide generous paid time off, allowing you to recharge and enjoy life outside of work.
-
Paid Sick Time: Your health matters to us. We offer paid sick time to support you during times of illness.
-
Employee Assistance Program (EAP): Our EAP offers free confidential counseling and support services to help you navigate personal or professional challenges.
-
Additional Perks:
-
Referral Program: We believe in the power of teamwork and collaboration. Our referral program rewards you for referring talented individuals to join our team.
- Tuition Reimbursement Program: We support the professional growth of all employees, but understand that going back to school is expensive. We offer tuition reimbursement up to the IRS limit annually to help our employees flourish.
At SCRAM, we are committed to empowering our employees to thrive both personally and professionally. Join us and take advantage of our comprehensive benefits package as you embark on a rewarding career journey with us.
From: SCRAM Systems
