Organization

Primary Care Coalition of Montgomery County, Maryland was founded in 1993 when a group of physicians and health care officials imagined a Montgomery County where every resident had access to high-quality health services. They envisioned a dependable source of primary care for low-income, uninsured individuals in our community and created a framework that shared the responsibility for providing that care across the public and private sectors. The Primary Care Coalition (PCC) was formed to help make their vision a reality.

The mission of PCC is to be the catalyst for developing and coordinating a community-based healthcare system that strives for universal access and health equity for underserved community members. The vision of PCC is that all community members have the opportunity to live healthy lives, and that Montgomery County will be the healthiest community in the nation and a model for providing access to high quality and efficient care for all.

Position Summary

The Data Analyst position provides data management support for various programs and targeted projects for the Primary Care Coalition and a network of safety-net organizations.  The Data Analyst is responsible for writing SQL queries for the automation, maintenance, reconciliation and ongoing analysis of health care information, obtained from a variety of sources, including patient care, demographic, specialty care and medicine management data.  This position will work with all departments and projects in recommending, preparing and interpreting quarterly and ad hoc reports, specifically of clinical measures, comparing the performance of participating clinics, and HEDIS benchmarks.

This position requires the ability to analyze health data from the conceptualization to final presentation. Knowledge of data analysis methodology, use of presentation software and a strong commitment to and affinity for timely delivery of assignments and follow-through are also required. The ability to effectively utilize additional analytical and presentation tools such as Excel, Access (including VBA) and PowerPoint is essential.

Specific Duties

• Perform simple and complex data extraction and analysis in support of both ad-hoc and standing requests with accurate and appropriate data interpretation.
• Review and update monthly and quarterly performance metrics for areas related to programs and projects. 
• Responsible for creating data systems for external clinics to trouble-shoot inconsistencies with data entry and designing systems for file management.
• Work with external clinic organizations to ensure accuracy of submitted data and reports and collaborate with appropriate internal staff to identify reporting problems and develop solutions.
• Internally support database applications and analytical tools to evaluate data quality and applications.
• Make visual presentations at management meetings regarding indicators.
• Participate fully and collaboratively in staff and team management work groups.
• Research new data analysis tools and provide recommendations for use.
• Make recommendations for improved database designs.

Skills and Abilities

• Knowledge of relational database design and data warehouse concepts is required.
• Understanding of healthcare performance indicators (HEDIS), quality health measures, with ability for visual presentation of those indicators. 
• Hands on experience with CRISP data is preferred.
• Excellent analytical and problem solving skills.
• Proven data management skills including attention to detail, with a focus on total project completion.
• Strong interpersonal skills.  Ability to interact effectively and build collaborative relationships with diverse clients, stakeholders and staff members at all levels.
• Excellent organizational skills and the ability to manage time effectively.
• Ability to prioritize work and allocate limited resources resulting in high quality, customer-focused projects, meetings, forums and outreach efforts.

• Bachelor’s degree or equivalent in Computer Science, Mathematics, Economics, Public Health, Health Administration or Social Science.
• 1-3 years related work experience.  Health care experience is preferred.
• Advanced skills with MySQL, database structures and MS Applications such as MS Access (including VBA), Power point, Excel and Word is required. 

This job operates in a professional office environment.  The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Disclaimer
 

This job description indicates in general the nature and levels of work, knowledge, skills, abilities and other essential functions (as covered under the Americans with Disabilities Act) expected of an incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of an incumbent. An incumbent may be asked to perform other duties as required.