Data Analyst Administrator III

Introduction

When you join the Maryland Department of Human Services (DHS), you join a team of more than 5,000 employees across the state dedicated to positively changing the lives of more than 1 million Marylanders each year. We do this by providing economic support, preventive services, and caring for children and adults. We aim to deliver services so that we more quickly meet the needs of the people we serve.

At DHS, we grapple with hard questions to find new ways to foster a culture of bold innovation, ensuring that in Maryland we leave no one behind.

18

Maryland Department of Human Services, Data Office, 25 S. Charles Street, Baltimore, MD, 21202

The main purpose of the position is to collate, organize, analyze, and present/report the department’s performance metrics and indicators for strategic management decisions to enhance and improve the department’s performances and reporting in compliance with federal and state regulations, laws and policies governing the various programs administered by the department, such as Social Service, Family Investment, and Child Support programs.

• Utilize Microsoft Power BI and other BI tools (Tableau, Qlik Sense, Looker, Zoho Analytics) to develop interactive dashboards and data visualizations. Translate raw data into actionable information for strategic policy decisions, evaluations, and improvements.
• Analyze complex datasets from various sources using statistical tools. Use Microsoft Excel and Google Sheets (employing advanced features such as VLOOKUPs, macros, and pivot tables) to identify trends, patterns, and actionable insights.
• Coordinate data extraction and collection from multiple state systems.
• Share these data with programmatic partners and provide information on important strategic objectives as needed.
• Respond to critical data requests from DHS leadership and various stakeholders and partners, including the Governor’s office, Maryland General Assembly, legislative auditors, and relevant federal agencies.

• Education:
  
  Graduation from an accredited high school or possession of a high school equivalency certificate.
• Experience:
  
  Six years of administrative staff or professional work.

• Candidates may substitute 30 college credit hours from an accredited college or university for each year up to four years of the required experience.
• Candidates may substitute the possession of a Bachelor's degree from an accredited college or university and two years of experience in administrative staff or professional work for the required experience.
• Candidates may substitute the possession of a Master's degree from an accredited college or university for the required experience.
• Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer involving staff work related to the administration of rules, regulations, policy, procedures and processes, or overseeing or coordinating unit operations or functioning as a staff assistant to a higher ranking commissioned officer on a year-for-year basis for the required experience.

• One year of experience with SQL, Athena AWS, QLIK or Quicksight.

• One year experience using Business Intelligence (BI) tools, such as Microsoft Power BI, Tableau, Qlik Sense, Looker, or Zoho Analytics, to develop interactive dashboards and data visualizations.
• One year experience preparing data reports and responding to critical data requests for executive leadership, legislative bodies, or other external government stakeholders.
• One year experience analyzing complex datasets to identify trends or patterns.

Employees in this classification may be assigned duties which require the operation of a motor vehicle. Employees assigned such duties will be required to possess a motor vehicle operator's license valid in the State of Maryland.

Contractual employees who work for an agency covered under the State Employee and Retiree Health and Welfare Benefits Program, have a current employment contract and work 30 or more hours a week (or on average…