Senior Database Analyst/PowerBi Developer

About the Role

Key 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.
• 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, dashboards, and workflows to enable informed decision-making and operational efficiency.
• Drive the adoption of best practices for Power Platform development to ensure scalability, reliability, and maintainability.
• Conduct testing and debugging to resolve issues and ensure high-quality solutions.
• Work with training departments to document processes, instructions, and best practices.
• Provide training and guidance to end-users on Power Platform solutions.
• Manage data collection, cleaning, and analysis, producing regular monitoring reports.
• Coordinate data collection for multiple projects to ensure consistency and quality.
• Develop evaluation designs, goals, and instruments for evaluation projects.
• Create reports, presentations, and dashboards of evaluation findings.
• Train new research assistants and staff on procedures and policies.
• Conduct literature reviews, qualitative data collection and analysis, and other research duties as needed.

Requirements

• Bachelor's degree required, preferably in Health Informatics, Data Analytics, Computer Science, or related field.
• At least 3 years experience with data visualization tools (e.g., Power BI, Tableau, R Shiny).
• Experience with PowerApps and Power Automate.
• Proven track record as a Power Platform Developer with a strong portfolio.
• Advanced proficiency in Power Apps, Power Automate, and Power BI, including canvas and model-driven apps, flows, connectors, data modeling, DAX, and Power Query.
• Advanced SQL skills for complex queries and data manipulation.
• Experience working with electronic health record systems and databases.
• Experience in data mining from multiple sources to identify key data elements.
• Experience managing large data sets in Excel, Access, and SPSS/SAS/R.
• Strong analytical skills and ability to transform raw data into useful insights.
• Strong interpersonal, communication, and written skills.
• Ability to work in a fast-paced environment with changing priorities.
• Knowledge of HIPAA and other relevant regulations.
• Proficiency in MS Office (Word, Excel, PowerPoint, TEAMS).
• Strong quantitative analysis skills.
• Ability to work independently and collaboratively.

Nice to Have

• Experience in a healthcare setting, call center, and patient services.
• Experience with qualitative research methods (e.g., focus groups, interviews).

Qualifications

• Valid driver's license and insurable driving record.

Benefits & Perks

• Regionally competitive salary, above average health benefits at reduced costs.
• Company paid life insurance and long-term disability insurance.
• Additional voluntary retirement plan with company match and no vesting schedule.
• Paid bereavement and jury duty leave.
• 11 paid holidays per year.
• Paid time off and sick leave.
• Flexible Spending Program.
• Company paid malpractice insurance for all providers.
• Professional development hours offered annually.