The Business Intelligence Analyst, Sr. will act as an expert in understanding the organizations data, working with stakeholder groups to create dashboards, visualizations, algorithms, and business tools for use across the organization. This includes aiding various teams in drawing insight from our data by researching, compiling, and analyzing data and preparing various reports for distribution. This analyst will act as an Epic subject matter expert for front/back-end Epic reporting development.

This position is considered remote, which means that individuals in this position may work at their place of residence; however, they may be required to occasionally visit the CommUnityCare administrative office in Austin, Texas. 

Essential Duties (at least 5 that are non‐negotiable duties and are absolutely pertinent to successfully completing the job without accommodations):

Duties/Responsibilities:
• Support the organization by gathering, organizing, formatting, and analyzing various forms of clinical and organizational data.
• Assist in creating and maintaining data gathering systems for demographic and clinical data.
• Gather data from various internal and external data sources.
• Analyze data to determine trend, discrepancies or other project-specific information.
• Interpret research findings and assist in preparing recommendations, as needed, in support of upper management decision making.
• Compile reports for various internal customers, grantors and external agencies.
• Works with the Cogito project manager, Radar administrator, and Reporting Workbench administrator to complete reporting build. Works with the Cogito project manager and business intelligence developer ﴾BID﴿ to identify appropriate solutions for various reporting needs.
• Works with the Reporting Workbench administrator to review and approve existing Reporting Workbench templates and create any needed additional templates.
• Builds Radar dashboards for report consumers with the support of the Radar administrator
• Builds Reporting Workbench reports, templates, and extracts for the application.
• Develops reports and dashboards to support clinical and revenue initiatives long-term.
• Completes Radar setup for custom SQL metrics.
• Perform other duties as assigned.

Knowledge/Skills/Abilities:
• Advanced SQL query writing skills required. Experience working in a Microsoft SQL Server environment.
• Advanced front/back end Epic experience including developing SQL-based DMCs and Cogito/Radar/RW report building and dashboard/maintenance.
• Experience analyzing data, drawing conclusions and making recommendations to support senior leadership.
• Advanced Microsoft Office Suite skills, with strong focus on Excel.
• Demonstrated knowledge and experience working with large data sets, including design survey instruments, data collection processes, data analysis, and writing reports on findings of the research.
• Demonstrated experience with relational and dimensional databases, data queries, and data extraction techniques including the ability to import, merge, and export files between applications, perform analyses, and prepare reports.
• Significant experience with creating and presenting management dashboards and reports.
• Significant experience with data visualization/business intelligence tools (e.g. PowerBI, Tableau, etc.)
• High level of skill in data collection and data manipulation utilizing tools such as Excel and Microsoft SQL Server Management Studio.
• Proficiency in other statistical analysis tools beneficial.
• Requisite skill and ability to connect data from various systems.
• Ability to interpret and articulate research findings.
• Strong organizational skills with a strong attention to detail and accuracy.
• Excellent verbal and written communication skills.
• Ability to work independently to complete a projec

MINIMUM EDUCATION:

Bachelor’s degree in Management Information Systems, Finance, Mathematics, Economics, Computer Science, Engineering or related quantitative discipline. Experience of 5 years or more in a related field (healthcare, statistics, experimental research, data science, economics or public health) will be considered in lieu of degree.

MINIMUM EXPERIENCE:
• Minimum of three (3) years of experience in healthcare, statistics, experimental research, data science, reporting and analytics, economics, or public health.

REQUIRED CERTIFICATIONS/LICENSURE:
• Epic certification required within 6 months of hire or within six months of completing Epic training.
• Must meet CommUnityCare’s Epic pre-assessment criteria.