Job Details

Statement of Purpose:

The Data Specialist is responsible for delivering high quality data for a variety of projects and tasks. The Data Specialist position provides in-depth data & qualify analytics, data entry, optimization, reporting, financial, and other types of analysis under the direction of the Data Manager and the Senior Vice President-Chief Data Officer.

Primary Tasks:

1. Work with internal departments and external partners, as needed, to collect data related to various tasks and projects.
2. Interpret data from multiple sources and analyze results using statistical techniques and providing ongoing reports on programmatic metrics.
3. Evaluate and monitor data integrity for assigned projects.
4. Provide data entry and reportable analytics. Specific details may include: a. Monthly Program reporting (in Excel and/or PowerBI, b) Secure file transfers to external partners, c) Quantitative and qualitative analysis( in Excel and/or PowerBI d) Identifying trends and patterns (in PowerBI).
5. Responsible for following CAN policies and procedures established by the organization, ensures compliance with security and privacy framework (PHI, HIPAA, etc.), and maintains confidentiality of sensitive data.
6. Examine, interpret and report results of analytical initiatives.
7. Collaborating with the Data Manager and 340B Compliance Manager to ensure program QA/QI metrics are met.
8. Strong knowledge of clinical terminology including ICD10 codes, National Drug Codes, sig codes, pharmaceutical calculations, medications and other related terminology.
9. Data validation, cleansing and normalization across multiple data sources.
10. Supporting program projects to ensure operational efficiency targets via data analysis.
11. Organizing and reporting monthly data analysis across assigned projects to identify trends.
12. Developing short-and long-term goals that meet established objectives and contribute to the overall goals of the team/programs.
13. Constructs appropriate KPI metrics to access areas of improvement, under supervision of Data Manager and 340B Compliance Manager.
14. Applies comprehensive knowledge and thorough understanding of concepts, principles, and technical capabilities to perform tasks and projects.
15. May contribute to the development of policies and procedures.
16. Ability to mine clinical data from various EMR systems and other identified systems, while meeting and maintaining HIPAA standards and policies and procedures.
17. Promotes and practices CAN Community Health, Inc.'s mission, values and follows policies.

Reports To: Data Manager

Requirements

Skills & Abilities

1. Must be advanced with Microsoft Office Suite, specifically Excel (required).
2. Experience working within PowerBi (required)
3. Experience with Power Platform apps (preferred)
4. Experience writing macros within Excel (preferred)
5. Strong knowledge of healthcare data specifically pharmacy and grants (required).
6. Experience working with Electronic Health/Medical Record (EMR/EHR systems) (preferred).
7. Understanding of or experience with SQL coding and SQL Server database querying (preferred)
8. Experience working with STFP (preferred).
9. Highly detail oriented.
10. Demonstrates understanding of relational databases and data capture.
11. Excellent organizational skills.
12. Ability and willingness to work in a fast-paced and demanding environment.
13. Demonstrated problem solving, analysis and resolution at strategic and functional levels.
14. Proven customer service orientation with exceptional interpersonal and communication skills.
15. Functional understanding of online technology to learn and research.
16. Ability to travel for job-related activities as necessary.
17. Good oral/written communication skills.
18. Ability to utilize problem-solving techniques.
19. Ability to utilize decision-making techniques.
20. Ability to function autonomously and as a member in a multidisciplinary team.
21. Effectively use reports and other analytical tools to help target efforts for maximum program results.

Education/Professional:

1. Bachelor's degree (required) and/or 4 to 5 years of business equivalent experience.
2. Minimum 2-years of experience in data analytics, preferably in pharmacy or healthcare-related field.

Supervisory Responsibility: none

Physical Demands:

1. Neat, professional appearance.
2. SEDENTARY-Exerts up to 10 lbs. of force frequently, and/or a negligible amount of force frequently or constantly in lift, carry, push, pull or otherwise move objects. Involves sitting most of the time but may involve walking or standing for brief periods of time.
3. Requires expressing or exchanging ideas by means of spoken word, visual and auditory acuity.

Work Environment:

• This job operates in a professional office environment. This role routinely uses standard office equipment such as computers and various software programs, telephones, photocopiers, filing cabinets and fax machines.

Position Type/Expected Hours of Work:

• This position may require overtime and at times weekend work.

Travel:

• Travel is primary local during the business day, although some out of area and overnight travel may be expected

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of an employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

CAN is an equal opportunity employer that is committed to diversity and values the ways in which we are different. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other characteristics protected by applicable law.