Data Analyst in Taylor, Michigan at Southeast Michigan Community Alliance (SEMCA)
Job Description
Under 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.
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.
- Other duties as assigned.
Required Qualifications
All 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.
- 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.
Physical Demands
Duties 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.
Scan to Apply
Just scan this QR code to apply from your phone.
- Fast
- Easy
- Apply on the go