|
Search Jobvertise Jobs
|
Jobvertise
|
Data Analyst Des Moines IA REMOTE Location: US-IA-Des Moines Email this job to a friend
Report this Job
The client is seeking a Data Analyst This position is for a Data Analyst within the Bureau of Services, Planning and Performance in the Office of Data Analytics and Reporting. This position will be responsible for data quality of the Iowa (IBHRS) database. The main duties will consist of analyzing trends in data reporting, working with providers on the integrity of the data submitted, and working with stakeholders to understand the data. In addition, this position will be responsible for preparing SSRS reports for use by internal and external stakeholders, reviewing existing reports for integrity, streamlining and combining reports for ease of access and use, and preparing dashboards using various data visualization tools. Skills We are looking for a self-starter who is willing to learn. An ideal candidate will have a positive attitude and strong communication skills. The needs of this position are as follows: Coordinate people and resources required to accomplish objectives without the use of supervisory authority. Responsible for data quality of the substance use, problem gambling and mental health data reported into the system. Possess the skills required to provide actionable recommendations based on data analysis. Able to understand and assess the quality of source data; Gain knowledge of the system to validate the data being reported by providers and prepared for use by stakeholders. Collect metrics for trends in data reported. Review data reported for outliers. Provide technical assistance and guidance to providers to clean data and prepare it for analysis. Able to use a relational database, reporting software, and data analytic software to create simple to complex ad hoc queries, write reports and create dashboards against the data reported from IBHRS. Uses data visualization tools such as Microsoft Excel and Power BI or Tableau. Set up and maintain executive dashboards so all stakeholders (internal and external) view the same data in the same way. Reviews existing reports for integrity. Works with stakeholders to explain the data being reported. Provide guidance to programs on how to access available reports. Works with business user, data stewards to review data with the business to evaluate data quality and trace data lineage from source systems. Provide data expertise to other Bureau staff and acts as a liaison between business users and technical staff. Daily/Weekly Time Allocation 25% - Develop new reports, respond to ad hoc requests for data, check integrity of existing reports, review data submitted by providers (link removed) /> 20% - Work with reporting providers to correct data reporting issues. 15% - Meet with agency programs on a regular basis (monthly to quarterly) to review data trends and assess ongoing needs for reports from the programs. 15% - Create and maintain dashboards for internal and external stakeholders. 15% - Participate in division meetings related to data. 10% - Technical testing of the Iowa Behavioral Health Reporting System. Required/Desired Skills Skill | Required /Desired | Amount | Experience Needed | Experience you have | Experience with Data Analytics | Required | 3 | Years | | Experience in SQL Server Reporting Services (SSRS) / Microsoft Report Builder or similar reporting software | Required | 3 | Years | | Experience with Data Analytic Software (PowerBI, Tableau, etc) | Required | 3 | Years | | Experience with relational database queries, specifically writing subqueries, versioning and/or temp tables. SSMS experience a plus. | Required | 3 | Years | | Experience working with clinical data | Desired | 0 | | |
Brandon Consulting Associates, Inc.
|