Quality Measures Developer / SQL Developer

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