Sr. SQL Developer (ISA)

Salary: $110,000.00 USD - $125,000.00 USD 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. Job Description 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. 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) and 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 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 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 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. Benefits 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. 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 – supplementallife 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. 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 your employees flourish. Qualified applicants are considered for employment, and employees are treated during employment without regard to race, color, religion, national origin, citizenship, age, sex, marital status, ancestry, physical or mental disability, veteran status or sexual orientation. Solely to help us comply with federal and state Equal Opportunity record keeping, reporting, and other legal requirements, we request that you complete this data information questionnaire. The information that you provide will be recorded and maintained in a confidential file, separate from all other records. This information will not be used in consideration for your employment. #J-18808-Ljbffr SCRAM Systems