Data Analyst (Research Analyst 3)

About the role

The Oregon Department of Human Services is seeking a Data Analyst (Research Analyst 3) to join the Office of Training, Investigations and Safety (OTIS) team in Salem. This position involves assisting ODHS and OHA programs in developing systems to organize, manage, and track data that supports informed decision-making regarding the abuse of vulnerable children and adults in Oregon.

Responsibilities

• Analyze data through compiling reports, dashboards, graphs, and tables to support performance and data-driven decision making.
• Organize, summarize, and present information, conclusions, and recommendations to individuals and groups in writing and orally.
• Utilize approved software packages to retrieve, edit, and tabulate data from various databases and files.
• Produce visualizations, dashboards, and reports that support performance management; apply forecasting techniques to historical and current data to predict fiscal or program impact; present information to display trends, patterns, and progress.
• Plan projects within OTIS and across programs to provide agency leadership with accurate and timely information that supports data-informed decision making.
• Initiate and manage projects by identifying and gathering pertinent information using existing ODHS and OHA computer systems and reports.
• Interact with ODHS/OHA staff and partners to gather and review technical information including state statute and rules related to project planning and implementation.
• Provide oversight of the distribution of work within the unit; assist with the prioritization of work; provide coaching and mentoring to other team members.
• Maintain quality assurance and process improvement activities to maintain accurate and complete data sets.

Requirements

A valid driver’s license and acceptable driving record are required for this position. A Bachelor's Degree in any discipline that included six-quarter units in statistics or quantitative analysis methods and procedures, and one year experience using computerized applications to independently gather, compile, and analyze data and prepare narrative or statistical reports. OR Four years of research experience using computerized applications to independently gather, compile, and analyze data and prepare narrative or statistical reports. In addition to the above requirements, some positions require one or more of the following:

• Experience working with heterogeneous data sources NOT associated with automated pipelines or machine learning.
• Demonstrated experience building custom queries using SQL across heterogeneous data sources to merge data.
• Advanced proficiency using Excel, including Power Query and Power Pivot, for accessing, modeling, and conforming data for analysis.
• Strong experience using Power BI for creating visualizations and dashboards to communicate data.
• Strong critical thinking and problem-solving skills to assist in making data-driven decisions and address data quality issues.
• Demonstrated communication and collaboration skills with diverse data consumer groups that include individuals with varying levels of comfort and experience interpreting and using data.
• Experience assigning and directing work and managing priorities across a team.

Qualifications

Minimum Qualifications:

• A valid driver’s license and acceptable driving record are required for this position.
• A Bachelor's Degree in any discipline that included six-quarter units in statistics or quantitative analysis methods and procedures, and one year experience using computerized applications to independently gather, compile, and analyze data and prepare narrative or statistical reports. OR Four years of research experience using computerized applications to independently gather, compile, and analyze data and prepare narrative or statistical reports.

Essential Attributes:

• Experience working with heterogeneous data sources NOT associated with automated pipelines or machine learning.
• Demonstrated experience building custom queries using SQL across heterogeneous data sources to merge data.
• Advanced proficiency using Excel, including Power Query and Power Pivot, for accessing, modeling, and conforming data for analysis.
• Strong experience using Power BI for creating visualizations and dashboards to communicate data.
• Strong critical thinking and problem-solving skills to assist in making data-driven decisions and address data quality issues.
• Demonstrated communication and collaboration skills with diverse data consumer groups that include individuals with varying levels of comfort and experience interpreting and using data.
• Experience assigning and directing work and managing priorities across a team.