SQL Data Analyst

DISCLAIMER:

Job descriptions are not meant to be all-inclusive and/or the job itself is subject to change. Nothing in this job description restricts management’s right to assign or reassign duties

Essential Duties and Responsibilities:

• Perform ETL duties to move data from raw format for use by multiple departments
• Apply knowledge of data, data structure and analytical tools to research or identify trends, expenditures, and utilization of healthcare providers/practices.
• Respond to requests for data by determining user’s needs, collecting, organizing, and analyzing data, and providing accurate and complete reports and information.
• Assist other analysts to perform financial analysis of facilities, practices, provider services, and utilization.
• Work with other analysts to perform a variety of ad-hoc analysis and assessments or initiatives as requested.
• Identify, develop and implement methods for improving reporting efficiency for department.
• Perform checks and audits of various data sources to ensure data adheres to data governance and maintenance policies.
• Maintain and apply knowledge of current trends, practices and developments in health care.
• Educate and assist in problem solving to promote the implementation of the health care initiatives and research.
• Knowledge of commonly-used concepts, practices, procedures, and programs within technology field.
• Contributes in the data integrity, governance, and data structure standards and policies.
• Collects, compiles and analyzes data to measure and report on provider and program performance.
• Must abide to all HIPAA, Confidentiality and Privacy laws.
• Other duties as assigned within the scope of responsibilities and requirements of the job; not limited by this job description.

Supervisory Responsibilities:

This job has no supervisory responsibilities.

Competencies: To perform the job successfully, an individual should demonstrate the following competencies:

• Analytical and advanced problem solving strategies.
• Working knowledge of industry coding (revenue codes, ICD9/ICD10/ICD11 classifications, CPT codes)
•  of data, data objects, data structure, and industry standards.
• Minimum level computer skills in a Microsoft Office environment: Advanced.
• Strong skills in SQL, Microsoft Excel, or other comparable software tools.
• Programming languages preferred, notably C#
• Experience with ETL process management and data engineering
• Strong internet research capabilities.
• Bi- or Multi- lingual skills (written and verbal): A Plus.
• High attention to detail
• SQL Server / SSRS / Other Analytics Software
• Report Writing
• Problem Solving
• Systems/Workflows/General IT
• People Skills
• Assertive / Reliable
• Oral Communication – Speaks clearly and persuasively in positive or negative situations; listens and gets clarification; responds well to questions.
• Safety and Security – Uses equipment and materials properly.
• Attendance/Punctuality – Is consistently at work and on time.
• Knowledge of legal and ethical consideration related to patient information.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience:                                                    

Required: Bachelor’s degree in statistics, engineering, computer science and 1-3 years of experience in the field or in a related area.

Preferred: Master’s degree in a related area

Language Skills:    

Ability to read and comprehend simple instructions, correspondence, and memos.  Ability to write simple correspondence.  Ability to effectively present information in one-on-one situations to visitors, clients, and other employees of the organization.

Reasoning Ability:       

Ability to think critically and objectively and unbiased. Quickly learn/adapt to healthcare industry standards, codes, data, and business practices.

Computer Skills:    

MS Office Productivity Tools (Word, Excel, Outlook, PowerPoint), Internet, SQL & Data Objects, various report writing tools. Programming skills preferred in C# or other related languages.

Other Skills and Abilities:     

High accuracy and extreme confidentiality a MUST. Highly detail-oriented and must possess a very high degree of organization.

Physical Demands:

While performing the duties of this Job, the employee will have a combination of standing, sitting, bending and reaching. May work at computer monitors for prolonged periods. The employee may lift and/or move up to 10 pounds.