Data Analyst ADMINISTRATOR III

Main Purpose of Job

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.

Position Duties

• 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.
• Using tools such as Microsoft Excel and Google Sheets (employing advanced features like VLOOKUPs, macros, and pivot tables) to identify trends, patterns, and actionable insights.
• Cook up 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.

Minimum Qualifications

• 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.

Selective Qualifications

• 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.