Analyst 1

Job Title: Analyst I

Location: Detroit MI 48226

Contract: 12 month

Pay: $31-34.53 per hour (DOE) Workforce Planning and Data Analyst

Position Overview

We are seeking a detail-oriented and analytical Workforce Planning and Data Analyst to support workload management, workforce planning, reporting, and data-driven decision-making. This role is responsible for collecting, analyzing, and interpreting data to identify trends, monitor performance, improve operational efficiency, and provide actionable recommendations to stakeholders.

The ideal candidate has strong analytical and organizational skills, proficiency in Microsoft Office, and the ability to translate complex datasets into clear, meaningful reports and visualizations. Experience with Power BI, SQL Server, and programming languages is preferred but not required.

Key Responsibilities

Workforce Planning and Workload Management

• Support workload management and workforce planning activities, including maintenance planning, recommendations, tracking, and follow-up.
• Monitor workload trends, resource utilization, and operational metrics to support planning and decision-making.
• Maintain and update tracking systems and standard processes to ensure accurate and timely information.
• Identify opportunities to improve reporting processes, data accuracy, and operational efficiency.

Reporting and Data Visualization

• Develop and maintain routine and ad hoc reports, dashboards, performance metrics, and analytical summaries.
• Create clear, accurate, and easy-to-understand visual representations of data to communicate trends, findings, and performance indicators.
• Validate data and ensure reports accurately reflect the underlying datasets.
• Respond to reporting requests and modify existing reports to meet evolving business needs.

Data Analysis and Project Support

• Conduct ad hoc and project-based analyses by gathering, reviewing, and interpreting relevant data.
• Identify trends, discrepancies, and opportunities for improvement and provide data-driven recommendations.
• Support project execution through follow-up analysis, meeting coordination, data updates, reporting modifications, and tracking of action items.
• Collaborate with stakeholders to understand business needs and translate them into analytical requirements and deliverables.
• Gather and document requirements for reports, dashboards, and analytical projects.
• Track recommendations and follow-through activities to support successful implementation.

Database Querying and Technical Support

• Write and execute database queries to retrieve, organize, and analyze information.
• Extract and manipulate data from relevant systems to support reporting and business analysis.
• Support the development and maintenance of automated reporting solutions and analytical tools.
• Identify opportunities to streamline data collection, reporting, and analysis through technology and process improvements.

Minimum Qualifications

• Bachelor's degree in Business Analytics, Data Analytics, Information Systems, Computer Science, Engineering, Mathematics, or a related field.
• Experience using Microsoft Office applications, particularly Excel, Word, and PowerPoint.
• Strong analytical, problem-solving, and critical-thinking skills.
• Ability to collect, organize, validate, and interpret data accurately.
• Strong attention to detail and commitment to data quality.
• Effective written and verbal communication skills.
• Ability to translate business requirements into reports, analyses, and actionable recommendations.
• Strong organizational skills and the ability to manage multiple requests and priorities.

Preferred Qualifications

• Experience developing dashboards and reports using Microsoft Power BI.
• Experience writing SQL queries and retrieving data from SQL Server databases.
• Familiarity with programming or scripting languages such as M, R, JavaScript, PHP, or C++.
• Experience with data visualization, dashboard development, and performance metric reporting.
• Familiarity with workforce planning, workload management, resource tracking, or operational analysis.
• Experience automating reporting processes and improving data workflows.
• Ability to communicate analytical findings effectively to technical and nontechnical stakeholders.