Analyst 1

Job Title: Analyst I
Location: Melvindale MI 481222
Contract: 12 month
Pay: $25-29.03 per hour (DOE)

The Data Reporting and Analytics Analyst supports daily, weekly, and annual reporting, forecasting, and workload management activities. This role is responsible for maintaining reporting processes, monitoring key metrics, identifying opportunities for improvement, and providing recommendations to support business operations. The analyst develops and maintains analytical reports, creates data collection processes, supports business systems, and conducts research to identify trends, resolve issues, and improve operational efficiency. The position requires strong analytical, technical, and problem-solving skills, along with the ability to work independently and recommend effective solutions.

Job Responsibilities

• Develop, maintain, and execute routine and ad hoc reporting processes, including generating reports, dashboards, and performance metrics.
• Conduct project-based and ad hoc analyses by gathering, validating, and reviewing data to identify trends, evaluate performance, and provide actionable recommendations.
• Perform follow-up activities related to analytical projects, including scheduling meetings, updating datasets, conducting additional analyses, and implementing reporting changes.
• Write, execute, and optimize SQL queries to retrieve, analyze, and manipulate data from databases.
• Create clear and effective visual representations of datasets using data visualization tools to communicate findings and support data-driven decision-making.
• Gather, analyze, and document business requirements for reports, projects, and analytical initiatives.
• Support daily, weekly, and annual forecasting, reporting, and workload management processes to ensure accuracy, consistency, and timely delivery.
• Develop and maintain data collection processes, reporting workflows, and analytical systems to improve efficiency and data quality.
• Research business issues, perform detailed analyses, and prepare reports that support operational planning and management decisions.
• Identify process improvement opportunities and recommend solutions to enhance reporting accuracy, workflow efficiency, and business performance.
• Provide ongoing support for reporting systems, data processes, and business applications while ensuring adherence to established procedures.

Minimum Qualifications

• Bachelor's degree in Data Science, Data Analytics, Computer Science, Information Systems, Business Administration, or a related field.
• Experience with Microsoft Power Platform tools, including Power BI, Power Apps, and Power Automate.
• Working knowledge of SQL Server, including database querying, data retrieval, and fundamental database management principles.
• Strong analytical, problem-solving, and data interpretation skills.
• Ability to gather business requirements, conduct research, analyze complex issues, and recommend appropriate solutions.
• Strong written and verbal communication skills, with the ability to present analytical findings clearly to business stakeholders.
• Ability to work independently, manage multiple priorities, and deliver accurate reports within established deadlines.

Preferred Qualifications

• Experience with Microsoft Azure Data Factory and Azure Data Explorer tools for data integration, processing, and analytics.
• Exposure to Databricks and cloud-based data processing environments.
• Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data analysis, and reporting.
• Experience developing automated reporting solutions, interactive dashboards, and data visualization tools.
• Familiarity with data governance, data quality management, and reporting process optimization.