Senior Database Analyst / Powerbi Developer

Senior Database Analyst / PowerBi Developer

Department: Informatics/NextGen

Reports to:  Associate Director of Informatics

Status: Full-Time

FLSA: Exempt
 

Organization Information

WellSpace Health believes that everyone deserves to be seen, no matter who you are, where you come from, where you work or what place you call home. We see you and are here for you. To that end, we have committed ourselves to finding solutions for our community’s health and wellbeing to achieve regional health through high quality comprehensive care.

Our focus has always been to offer a full range of quality medical care, dental care, mental health and behavioral health services, and enabling services to underserved people.  We do this by placing ourselves within the communities we serve and employing outstanding healthcare professionals who are devoted to our mission.

We are a Federally Qualified Health Center (FQHC) and are accredited by the Joint Commission for Ambulatory Care and Behavioral Health. We are also certified by the Joint Commission as a Primary Care Medical Home and a Behavioral Health Home.

Position Summary

The Senior Database Analyst / PowerBi Developer’s role is to support the information needs of WellSpace Health through the administration and design/development of Power Bi dashboards.  The Senior Database Analyst / PowerBi Developer will assist the Informatics / Business Intelligence team(s) with data management, monitor trends and troubleshoot potential issues with the data collections and databases, implement and evaluate quality improvement metrics, produce performance monitoring reports, and support various research and evaluation projects within the program.

Required Qualifications

• Bachelor’s degree required. Health Informatics, Data Analytics, Computer Science or in related field (preferred).
• At least 3 years experience with data visualization tools (e.g. Power BI, Tableau, R Shiny, etc.) required
• PowerApps and Power Automate experience
• Proven track record as a Power Platform Developer, with a strong portfolio showcasing your ability to build robust applications and automation solutions.
• Advanced proficiency in Power Apps, Power Automate, and Power BI, with expertise in canvas and model-driven apps, flows, connectors, data modeling, DAX, and Power Query.
• Advanced SQL skills, with the ability to write complex queries and manipulate data effectively.
• Experience in a health care setting, call center and patient services preferred.
• Superior analytical skills and proven ability to transform raw data into accurate and useful analytics.
• Strong interpersonal, knowledge-sharing, and written/oral communication skills.
• Experience in mining data from multiple data sources to quickly identify important data elements and solve pain points.
• Superior ability to identify trends, correlations, and patterns in data and present findings to stakeholders.
• Experience collecting, cleaning, and managing large data sets in Excel, Access, and SPSS/SAS/R required.
• Experience working with and maintaining multiple databases for the purpose of research and evaluation projects.
• Experience working with electronic health record systems and other databases.
• Experience troubleshooting and problem-solving issues with data collection and data quality.
• Experience with qualitative research (e.g. focus groups, interviews, qualitative analysis) is preferred but not required.
• Ability to distill results into a few key points and present them clearly, in written, oral and graphical formats to program staff and management.
• Proficiency in MS Office (Word, Excel, PowerPoint, TEAMS).
• Strong quantitative analysis skills (e.g. descriptive and inferential statistics).
• Ability to work in a fast-paced environment with changing priorities by being flexible, collaborative, responsive, and adaptable.
• Strong organizational, communication (verbal and written), and problem-solving skills with the ability to prioritize assignments, meet required deadlines, and reprioritize as needed.
• Ability to work both independently when needed and collaboratively as a team member.
• Know and comply with agency policies and procedures, HIPPA, and other state and federal regulations as they apply to this position.
• Adherence to infection control procedures, including but not limited to, standard precautions of temperature monitoring, hand washing, symptom self-monitoring, masking and social distancing.
• Assist and support the Center/Department/Program to meet agency standards of High Reliability.
• Must have a valid driver’s license and insurable driving record.
• If requested, must be able to provide sample of work to demonstrate skillset and related experience.

Essential Responsibilities

• Collect, analyze, and interpret quantitative data related to the evaluation of the agency’s program to create clear and actionable narratives about the operations of the program and patient behaviors.
• Create presentations with analysis and insights for both technical and non-technical audiences.
• Collaborate across teams, senior management, business partners and clients at multiple projects simultaneously in facilitating the design, build and automation of reports / dashboards that provide insight into program operations.
• Administer and own the Power BI Cloud infrastructure
• Collaborate with teams across the organization to understand business requirements and translate them into effective Power Platform solutions.
• Design, develop, and deploy business intelligence and automation solutions using the Power Platform suite (Power Apps, Power Automate, Power BI).
• Utilize SQL skills to query and manipulate data from various sources, ensuring data accuracy and integrity.
• Create and maintain comprehensive data models, interactive reports, intuitive dashboards, and streamlined workflows to enable informed decision-making and enhance operational efficiency.
• Drive the adoption of industry-leading best practices and standards for Power Platform development, ensuring scalability, reliability, and maintainability of applications.
• Conduct rigorous testing and debugging to identify and resolve issues, ensuring the delivery of high-quality and error-free solutions.
• Work closely with training department to document processes, instructions, and best practices related to Power Platform development and usage.
• Provide training and guidance to end-users on how to utilize Power Platform solutions effectively, empowering them to optimize their workflows and productivity.
• Stay at the forefront of Power Platform advancements and features, actively seeking opportunities to propose innovative solutions that align with business objectives and drive continuous improvement.
• Responsible for data management (e.g. Importing and exporting data in various applications, cleaning data and resolving data inconsistencies, restructuring and/or merging data sets, running queries on data sets, and preparing data sets for analysis).
• Coordinate data collection for multiple projects to ensure consistency and quality. This includes producing regular monitoring reports to monitor data collection and data entry across multiple projects.
• Produce periodic performance monitoring reports for several programs and services, which include data cleaning, management, and analysis in R and/or Excel.
• Manage and prioritize workload between multiple departments while meeting deliverables and expectations in a timely manner.
• Coordinate continuous data quality improvement projects related to data collection and data entry.
• Interpret and convey quantitative data related to the program through Microsoft PowerPoint/Excel and/or other data visualization tools to enhance the ability of staff to make operational decisions within the program.
• Coordinate with team members to design, manage, and conduct evaluation projects, including development of evaluation designs, goals, objectives, and instruments.
• Develop written reports, presentations, and data dashboards of evaluation findings for internal and external audiences.
• Train new research assistants on procedures and policies.
• Participate in training staff on administering and collecting outcome measures.
• Consult with individual program staff regarding administration and scoring of various outcome measures.
• Other tasks include: conducting literature reviews, qualitative data collection and analysis, and other research duties as needed.

Benefits

Successful candidate will receive regionally competitive salary, above average health benefits at reduced costs, company paid life insurance & long-term disability insurance, additional voluntary retirement plan with company match and no vesting schedule requirement.

• Paid bereavement and jury duty leave
• 11 paid holidays per year
• Paid time off
• Paid sick leave
• Flexible Spending Program
• Company paid malpractice insurance for all providers
• Professional development hours offered annually

Physical Demands and Work Environment

The work environment is characteristic of a medical clinic 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. While performing the duties of this job, the employee is frequently required to sit; use hands and arms to reach.  The employee is also required to stand; walk; and reach with hands and arms. The employee must occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision, distance vision, and the ability to adjust focus.   The employee must also possess hearing and speech to communicate in person and over the phone.  The noise level in the work environment is usually quiet.

The employee may be in contact with individuals and families in crisis who may be ill, using substances and/or not attentive to personal health and safety for themselves or their homes. The employee may experience a number of unpleasant sensory demands associated with the client’s use of alcohol and drugs, and the lack of personal care.  The employee may also be exposed to bodily fluids (blood, urine) and hazardous chemicals.

WellSpace Health is committed to the principals of equal employment.  We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.  It is the intent of WellSpace Health to maintain a work environment free of harassment, discrimination, or retaliation because of age, race, religious creed, color, national origin, ancestry, physical disability, medical condition, genetic information, marital status, sex (including pregnancy, childbirth, breastfeeding and/or related medical conditions), gender, gender identity, gender expression, sexual orientation, military or veteran status, or any other status protected by federal, state or local laws.  WellSpace Health is dedicated to the fulfillment of this policy in regard to all aspects of employment, including but not limited to recruiting, hiring, placement transfer, training, promotion, rates of pay, and other compensation, termination, and all other terms, conditions, and privileges of employment.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

                                                                                      WellSpace Health is an Equal Opportunity Employer