Data Analyst
- Taylor, MI, United States
$29 to $32 USD / hour
Applications open in a new tab.
Job details
- Pay
- $29 to $32 USD / hour
- Apply by
- Posting language
- English
- Posted
Original job description
Description Job SummaryUnder the general direction of the Data Analyst Assistant Manager, the Data Analyst supports SEMCA’s workforce development programs. The Data Analyst maintains and enhances Power BI dashboards, fulfills recurring and ad hoc reporting requests using SQL and Salesforce, and investigates data and system issues. The role combines technical problem-solving with the ability to understand program operations, clarify stakeholder needs, and communicate accurate, useful findings. Functions Essential Functions
- Gathers, consolidates, transforms, and analyzes data from SEMCA workforce development systems to evaluate program performance, data quality, and trends.
- Maintains and enhances Power BI dashboards, data models, and visualizations that help program staff and decision makers monitor operations, assess progress toward goals, and identify improvements.
- Develops recurring and ad hoc reports using SQL and Salesforce; tests report logic and validates results against source data and agreed definitions.
- Consults with staff, contractors, and other stakeholders to understand business questions, clarify data requirements, and translate specifications into queries, reports, or code; manages expectations about priorities, timelines, and limitations.
- Independently investigates data anomalies and reporting discrepancies; identifies and tests possible causes, documents findings, and develops or coordinates solutions with MIS colleagues.
- Condenses complex data into clear reports, presentations, charts, and written or verbal findings; explains trends and limitations to support program decisions, strategies, and goals.
- Documents data definitions, query logic, and reporting procedures; identifies opportunities to improve accuracy, consistency, and efficiency through scripting, automation, or process improvements.
- Assists team members with tasks or projects with vigilance and attention to detail and communicating potential risk factors to support the well-being of the organization.
- As directed, assists SEMCA contractors and sub-awardees in interpreting reports, addressing data quality issues, and improving program performance and data accuracy.
- Represents SEMCA at internal and external meetings and communicates analytical findings and reporting needs to technical and nontechnical audiences.
- Assists in developing departmental policies and procedures to support compliance with State and Federal regulations.
- Assists team members with tasks and projects, coordinates competing priorities, and communicates potential risks affecting data accuracy, reporting deadlines, or program operations.
- Maintains confidentiality and safeguards participant, employee, and organizational information through diligent protection of data and systems in accordance with SEMCA policies.
Non Essential Functions
- Other duties as assigned.
Qualifications
Required QualificationsAll SEMCA team members are expected to be technically competent and committed to developing their skills.
- Associate’s degree in computer science, information technology, data analytics, or another technical field, or equivalent experience pursuant to SEMCA’s Experience in Lieu of Education policy.
- Working proficiency in SQL, including joins, filtering, aggregation, and validation of query results.
- One to three years of relevant experience in reporting, data analysis, or technical problem-solving.
- Programming, scripting, or reporting automation experience, preferably using Python and AI tools.
- Demonstrated ability to problem-solve and apply solutions, including identification of potential causes; judgment about when to seek assistance or escalate.
- Effective listening skills, communication of ideas outside the immediate team, and ability to recognize impact of communication style on others; may have to communicate management initiatives, instructions, and policies in a consistent, effective, and timely manner.
- Ability to maintain reasonable and responsible use of resources.
- Ability to positively impact the organization in assigned area and through contributions to program delivery.
- Strong interpersonal and listening skills; ability to clarify requests, manage stakeholder expectations, and explain technical findings clearly.
- Ability to learn program rules, business processes, and unfamiliar technical tools and apply them to reporting and analysis.
- Experience using Microsoft Office and Excel formulas and pivot tables to review and validate data.
- Attention to detail; ability to prioritize requests, meet agreed deadlines, communicate changes, and use organizational resources responsibly.
Preferred Qualifications
- Bachelor’s degree in computer science, information technology, data analytics, or relevant field of study.
- Experience with one or more of the following: Power BI dashboard development or maintenance, Salesforce reporting, or Oracle databases and Oracle APEX applications.
- Workforce development experience, or experience in nonprofit or government settings.
Supplemental Information Physical DemandsDuties require sufficient mobility to work in a normal office setting and use standard office equipment including a computer, vision to read printed materials on an LCD screen and smartphone, hearing and speech sufficient to communicate in person and over the telephone. These requirements may be accommodated for otherwise qualified individual requiring and requesting and/or needing additional accommodations.
Benefits
This position is not eligible for benefits.
More about this job
Skills
- Microsoft Power BI
- SQL
- Salesforce
- Problem solving
- Data models
- Monitor operations in the leather industry
- Reporting
- MIS
- Presentation skills
- Attention to detail
- Regulatory compliance
- Confidentiality
- Data protection
- Computer science
- Computer technology
- Data analysis
- Communication skills
- Business processes
- Microsoft Office
- Microsoft Excel
- Oracle
- Office equipment