Lightbeam Health Solutions

Job Description Job Description SQL Developer JOB SUMMARY: The Quality Measure Developer is responsible for developing healthcare quality measures, financial and risk calculations, and associated reporting tools, as well as providing technical and industry guidance to clinical, operations and support stakeholders throughout the Lightbeam organization and its customers. A successful Quality Measure Developer has SQL development experience, strong troubleshooting skills, and healthcare industry knowledge. This individual spends much of their day developing, maintaining, and tuning SQL stored procedures, and a smaller portion of their day collaborating with customers, customer support, project managers, and quality assurance. In addition to these responsibilities, the Quality Measure & Reporting Analyst helps with documentation, refinement of specifications, software deployments, and industry certification. JOB RESPONSIBILITIES: Develop and maintain Healthcare Quality Measure and Reporting software. Analyze and tune performance of stored procedures. Analyze business requirements and specifications to determine an optimal development strategy and timeline. Participate in Industry Certification activities, particularly annual NCQA HEDIS certification. Provide Quality Measures assistance to Customer Support and Project Management. Provide development assistance to DevOps and QA in cases of job failures or errors. Deploy Healthcare Quality Measure Software. Attend Agile meetings (Daily scrum meeting/Sprint planning/Backlog refinement) on assigned project. QUALIFYING JOB KNOWLEDGE, SKILLS, & ABILITIES: Required: 1-3 years of experience writing T-SQL, Snowflake/SnowSQL, or similar (e.g., Python+Pandas). Demonstrated troubleshooting skills, with experience identifying and resolving issues in large software platforms. Excellent oral and written communication skills Strong organizational skills. Preferred: Working experience with HL7 and healthcare interfaces Working experience with healthcare claims a plus. Exposure to C# / .NET a plus. Python, Snowflake. Healthcare Industry knowledge EDUCATION: Required: A relevant college degree, with 1-3 years of professional experience In lieu of a degree, equivalent professional experience may be considered Preferred: BS degree in Computer Science, Engineering, Mathematics, or a related subject. Background in technical support, quality assurance, software testing or application engineering will be considered as an advantage, as well as experience with population health systems. Lightbeam Internal Use Only: Position Security Classification CRITERIA: POSITION RISK LEVEL High Risk (if any of these are true) Access to Restricted information, including PHI and PII Elevated access privileges Access to the Security Infrastructure Medium Risk Access to Confidential , but not to Restricted information Low Risk Access to Unclassified information only Medium Risk CRITERIA: SECURITY ROLES & RESPONIBILITIES Security Roles & Responsibilities: Approve security-related changes Execute security-related changes Not applicable Policy/procedures for Lightbeam Cyber Security Incident Response (CSIRT) team Not applicable