To be considered applicants must complete and submit applications online. Successful applicants are required to complete and pass applicable background checks.
This Data Analyst position conducts research and analysis to support management decision-making for establishing rules, policies, and practices using statistical and qualitative analysis, information systems and database management. This position researches information needed and performs statistical analysis to determine program benefit levels, and whether programs are achieving the desired outcomes.
Analysis of Qualitative and Quantitative Data
Serves as subject matter expert for division-wide data and statistics.
Monitors data analytic trends and creates reports to share findings and recommendations with the internal team and other stakeholders.
Assesses quality of data by monitoring data reporting completeness and timeliness and recommends changes to program staff to improve data quality.
Manipulates, manages and analyzes large amounts of data, utilization data, population data, demographic data and program reported data.
Performs statistical analysis of data to assess the impact of services, the efficacy of program interventions, and adherence to service requirements.
Performs quantitative and qualitative methods to analyze the impact of proposed program changes; and analyzes trends in program data to assess the need for program changes to occur and may include case study analyses.
Designs and generate reports based on established requirements for a variety of audiences as well as on an ad hoc basis as needed.
Develops new databases and other systems for data collection and represents the bureau in meetings and workgroups involving data shared with other departments.
Information Systems and Database Management
Uses the department's information systems to extract information for ad-hoc reporting and statutorily mandated reports to the Federal government state legislature, and other customers (internal and external).
Performs standardized merging on multiple relational databases to allow data from separate sources to be combined and modeled together.
Serves as subject matter expert for Tableau reporting and dashboard development.
Partners with management and program teams to identify and prioritize reports and dashboard needs.
Develops and maintains interactive Tableau reports and dashboards that are user friendly.
Coach team members on Tableau development and best practices.
Other Duties as Assigned
Physical and Environmental Demands: Typical office environment. Travel is limited (5% or less).
Knowledge, Skills and Abilities (Behaviors):
Required for the first day of work:
Knowledge of research design techniques, tools and methods to collect and analyze quantitative and qualitative data.
General knowledge of budgeting, financial, and fiscal processes and procedures.
Knowledge of computer data management and data network systems.
Excellent written and oral communication skills.
Advanced skills in Microsoft Excel (formulas, pivot tables and graphs) and proficient in other Microsoft Office Suite (Outlook, Word, PowerPoint).
Ability to query multiple databases and compile data to generate reports.
Ability to work under pressure in fast-paced situations with a calm demeanor and collaborative attitude.
Ability to operate a personal computer, databases, statistical software, including general office equipment as necessary to complete essential functions.
Bachelor's degree in statistics, economics, mathematics, or related field.
Three years of analyst, or business data management experience including at least two years of research design, data collection, management and analysis; information system design, report design and presentation.
Preferred two years of hands-on experience with Tableau (reporting and dashboard development).
Preferred knowledge of Geographical Informational Systems (GIS).
Preferred experience with public assistance and/or government computer systems and programs.
Equivalent combinations of education and experience may be considered on a case-by-case basis.
State Of Montana