904.834.2385

Join Our Team

Current Job Openings at Clearsense

POSITION SUMMARY – SQL Report Writer

We are looking for a dedicated and reliable SQL report writer / programmer. Under limited supervision, the Report Writer / Programmer will design and build a variety of health care related reports for Patient Legal Medical Record. This will be a 6-month project for the migration of reports from an existing EMR systems into SQL Server reports. The reports, when complete, will be ran once and then sent on to another subsystem that will store them for later retrieval. You will be working closely with team members who are expert EMR report writers for the source system. The team will evaluate existing reports in source EMR systems, and determine how to deliver the same reports using SSRS, Datazen, Microsoft Report Builder, or similar technology.

Reports will generally involve a variety of INNER and OUTER JOINS on 5-10 tables, and will involve the use of some complex SQL queries.

ESSENTIAL FUNCTIONS (Other duties may be assigned)

· Responsible for creation of new MS SQL Server Report Services reports.

· Ability to produce Ad-hoc reports when requested.

· Design, create, and manage reports. Execution of reports for millions of medical patients, which will likely be a complex task and involve throttling of report generation so not to cause problematic load on source system resources. The report generation will be a one-time process, and will likely the most lengthy and complicated part of the project.

REQUIRED COMPETENCIES – KNOWLEDGE, SKILLS, ABILITIES

Individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

· Strong technical background in SQL databases, queries and report writing platforms including SSRS.

· Candidate needs to possess the ability to write complex SQL and analyze data.

· Must have 2+ years SQL Server experience

· SQL Joins; Inner and Outer

· Control-of Flow queries – IF / ELSE blocks

· Expressions – CASE

· Operators – String concatenation, String substring

WORKING ENVIRONMENT/PHYSICAL REQUIREMENTS

This job can be remote or in our corporate office in Jacksonville, FL.

* Please attach resume to all applications