Under the direction of the Business Intelligence Manager and in collaboration with the Business Operations and Intelligence Team, Medical Services Team and other departments, the Business Intelligence Coordinator will assist in developing and improving data solutions including monthly statistics, profitability analyses, performance metrics and compliance reports, using such programs as Microsoft Excel, Tableau, Microsoft SQL and Crystal Reports. The Business Intelligence Coordinator will assist in identifying and replicating best practices around key business processes and provide direct support to users of NextGen, the agency’s practice management (PM) and electronic medical records (EMR) software. Additionally, the Business Intelligence Coordinator will serve as an enthusiastic partner in launching and sustaining new large-scale business initiatives and ongoing business intelligence work. Through these efforts, the Business Intelligence Coordinator will support and promote a team-based, customer-focused, results oriented service model that achieves business, operational, clinical and financial goals.
Essential Functions: • Assist in creation and deployment of custom Business Intelligence solutions that enable leaders and key business users to link operational performance data to outcomes; Prepare high-value, professional written and oral presentations of key data and analyses • Prepare statistical reports in Tableau; using data from Practice Management and EMR reports, and MSSQL Queries • Assist in fulfilling internal and external data requests • Coordinate data systems integration across the agency; where possible, facilitate cross-departmental/cross-disciplinary applied use of data • Monitor and respond to issues and inquiries received on the helpdesks • Conduct comprehensive business audits of health centers and administrative staff to verify accuracy and compliance; review and clean-up NextGen data to improve data integrity • Produce and/or assist in production of monthly statistical reports for health center managers, the Medical Services and Senior Management teams, and other parties as required, using Tableau, Microsoft SQL, and other programs as needed • Ensure accurate and timely compliance reporting, in conjunction with the Manager of Medical Programs & QA, and other QA personnel • Through these activities demonstrate an understanding of and commitment to PPIL core values of access, activism, care, confidentiality, diversity, excellence, integrity, respect, self determination, and stewardship; practice these values in relations with internal and external customers
Other Responsibilities: • Serve as an advocate and spokesperson for new business operations initiatives/projects • Provide targeted, prompt ad-hoc training to business users as needs arise; proactively integrate this knowledge into standard training materials • Collaborate with the Business Operations and Intelligence team and other departments to develop and maintain a Data Reporting Methodology, Definitions & Standards handbook that captures all data definitions as they relate to BOI • Support the launch of new business operations initiatives/projects; support training, implementation, and monitoring/evaluation efforts • Support the planning, implementation, and monitoring/evaluation of health services to maximize cost-effectiveness, revenue, and customer service • Serve as core member of NextGen Implementation Team; support the testing and rollout of NextGen and Template updates: assist with troubleshooting, testing and training • Perform other duties as assigned
Physical demands/Work 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 these essential functions.
While performing the duties of this job, the employee is regularly required to sit, stand, walk, talk, hear and use the phone. The employee is frequently required to use hands and fingers to key in data, handle, or feel and reach. The employee must occasionally lift and/or move up to 25 pounds.
Supervisor: Business Intelligence Manager
Status: Full-time, non-exempt from the overtime provision of wage and salary regulations.
Education and Experience:
Bachelor’s degree required. Superior written and verbal communications skills required. Proficiency in Microsoft Excel and other common Windows programs is required. Experience using Tableau to create and package workbooks preferred. Ability to write Microsoft SQL queries required, and ability to create Crystal Reports preferred. Expertise in the preparation and analysis of data, with an ability to adapt to changing environments and demands, is essential. Experience conducting end user training in both classroom and one-on-one settings, including creation of training documents and tools for system implementation and upgrades, is preferred. Must possess an ability to handle sensitive information in a confidential manner.
Professional and Personal Qualities:
Demonstration of effective interpersonal and organizational skills, including ability to work with diverse groups of employees at all levels. Possess excellent customer service skills and commitment to providing the highest level of service to all internal and external customers. Must be able to problem solve and multi-task effectively, follow through with complex assignments, and work under time constraints. Have excellent verbal and written communication and presentation skills. Be proficient in Microsoft Office suite, with strong skills in Microsoft Excel; candidates may be asked to take a short assessment demonstrating proficiency. Be experienced in running Microsoft SQL queries, preparing Tableau workbooks, and creating Crystal Reports; or be able to learn quickly. Be independently motivated to meet project management goals and objectives. Be willing to participate as a team member and work a flexible schedule, including some evenings and weekends as required. Must be willing to travel throughout the Illinois area to all PPIL sites. Planned Parenthood works affirmatively to include diversity among its workforce and does not discriminate in the selection of its staff based on factors including but not limited to race, color, religion, sex, national origin, age, sexual orientation, gender identity, disability, income, marital status or any other characteristic protected under federal, state or local law. We encourage diverse candidates to apply for this position.
About Planned Parenthood of Illinois
We are a trusted health care provider, an informed educator and a passionate advocate. Planned Parenthood of Illinois' 17 health centers throughout the state deliver vital health care services, sex education, and sexual health information to more than 60,000 women and families each year.
For nearly 90 years, building healthy communities has been Planned Parenthood's mission. Everyday, Planned Parenthood of Illinois helps all kinds of people get the health tools and information—and above all the care and compassion they need—to prevent unintended pregnancies or to plan for families when they are ready.