Analytics Developer

FLSA Status : Exempt

Department : Finance

Reports To : Director, Health Care Economics

Employee Unit : Employees in this classification are represented by Service Employees International Union (SEIU) Local No. 521.

GENERAL DESCRIPTION OF POSITION

The Analytics Developer designs, develops, implements and supports small to large scale, basic to complex in-house and vendor applications and interfaces, including the accurate data exchange between SCFHP and trading partners in support of SCFHP objectives and regulatory compliance.

ESSENTIAL DUTIES AND RESPONSIBILITIES

To perform this job successfully, an individual must be able to satisfactorily perform each essential duty listed below.

1. Maintain existing and develop new applications to support organizational business needs.

2. Utilize data analysis techniques and queries to support internal business functions through the generation of reports and development and maintenance of the data warehouse.

3. Review existing basic to complex processes and recommend new or improved solutions that increase efficiency and accuracy and implement those solutions.

4. Assess and troubleshoot small to large scale production issues related to performance, data errors, and process failures by reviewing error logs, source code, and applicable data to identify, recommend and implement solutions.

5. Collaborate with business analysts, other developers and business users through the project life cycle to gather and understand requirements, determine best solutions, test solutions and demonstrate functionality to end users.

6. Actively participate in design reviews and provide input to other Application Developers and Business Systems Analysts to ensure quality solutions are developed, working with the Application Developer Lead and Manager as needed.

7. Responsible for following the SCFHP Project Life Cycle, Software Development Coding Standards, and Change Control Management policies and procedures.

8. Create technical requirements based on review and analysis of requirement specifications supplied by Business Systems Analysts and / or business users.

9. Perform other related duties as required or assigned.

REQUIREMENTS - Required (R) Desired (D)

The requirements listed below are representative of the knowledge, skill, and / or ability required or desired.

1. Bachelor's Degree in Computer Science, or related field, or equivalent experience, training or coursework. (R)

2. Minimum four years of experience in application development. (R)

3. Applicable software development certifications. (D)

4. Minimum three years of experience with SQL programming, MS SQL database development, and T-SQL query generation. (R)

5. Minimum three years of experience with MS SQL Business Intelligence tools (SSRS, SSIS, SSAS) or other enterprise business intelligence software. (R)

6. Minimum three years of experience with any of the following applicable languages / platforms : .NET, PERL, Java, SAS, VB, C , or other modern programming language or related software. (R)

7. Minimum three years of experience with healthcare management information systems. (R)

8. Experience with the design and development of EDI solutions that meet HIPAA X12 standards. (D)

9. Knowledge of database concepts and data processes in order to understand, develop, analyze and support various new projects and make recommendations for improvements to existing processes. (R)

10. Ability to document code and processes. (R)

11. Ability to create and follow technical specifications. (R)

12. Ability to analyze data. (R)

13. Knowledge of BizTalk, Sharepoint, ActiveBatch and other core integration tools and services (D)

14. Working knowledge of and the ability to efficiently operate all applicable computer software including computer applications such as Outlook, Word and Excel. (R)

15. Ability to use a keyboard with moderate speed and a high level of accuracy. (R)

16. Excellent communication skills including the ability to express oneself clearly and concisely when providing service to SCFHP internal departments, providers and outside entities over the telephone, in person or in writing. (R)

17. Ability to think and work effectively under pressure and accurately prioritize and complete tasks within established timeframes. (R)

18. Ability to assume responsibility and exercise good judgment when making decisions within the scope of the position. (R)

19. Ability to maintain confidentiality. (R)

20. Ability to comply with SCFHP's policies and procedures. (R)

21. Ability to perform the job safely with respect to others, to property, and to individual safety. (R)

WORKING CONDITIONS

Generally, duties are primarily performed in an office environment while sitting or standing at a desk. Incumbents are subject to frequent contact with and interruptions by co-workers, supervisors, and plan members or providers in person, by telephone, and by work-related electronic communications.

PHYSICAL REQUIREMENTS

Incumbents must be able to perform the essential functions of this job, with or without reasonable accommodation :

• Mobility Requirements : regular bending at the waist, and reaching overhead, above the shoulders and horizontally, to retrieve and store files and supplies and sit or stand for extended periods of time; (R)
• Lifting Requirements : regularly lift and carry files, notebooks, and office supplies that may weigh up to 5 pounds; (R)
• Visual Requirements : ability to read information in printed materials and on a computer screen; perform close-up work; clarity of vision is required at 20 inches or less; (R)
• Dexterity Requirements : regular use of hands, wrists, and finger movements; ability to perform repetitive motion (keyboard); writing (note-taking); ability to operate a computer keyboard and other office equipment (R)
• Hearing / Talking Requirements : ability to hear normal speech, hear and talk to exchange information in person and on telephone; (R)
• Reasoning Requirements : ability to think and work effectively under pressure; ability to effectively serve customers; decision making, maintain a concentrated level of attention to information communicated in person and by telephone throughout a typical workday; attention to detail. (R)

ENVIRONMENTAL CONDITIONS

General office conditions. May be exposed to moderate noise levels.