> Markdown version of [/jobs/ext/1697511-data-and-reporting-analyst](https://www.wearedevelopers.com/jobs/ext/1697511-data-and-reporting-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data and Reporting Analyst - **Company:** AFSCME - **Location:** Lansing, MI, United States - **Experience:** Experienced - **Salary:** $75,962.0 - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Excel, Data Analysis, Information Systems, Databases, Data Systems, Data Visualization, Relational Databases, Document-Oriented Databases, Pivot Tables, Power BI, SQL Databases, Tableau (Software), Enterprise Software Applications, Powerquery, Data Analytics - **Published:** July 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=cfe56339be8a8400 ## About the Role · Bachelor's Degree in Data Analytics, Information systems, Statistics, Accounting, Finance, Business Administration, or a related field; or an equivalent combination of education and experience. · Three (3) or more years of experience in data analysis, reporting, business intelligence, database administration, or a related field. · Experience working with large relational databases and reporting systems. · Advanced proficiency in Microsoft Excel, including PivotTables, lookup functions, Power Query, and data analysis tools. · Strong analytical, problem-solving, organizational, and project management skills. · Ability to translate complex data into meaningful and actionable information. · Excellent written and verbal communication skills. · Ability to work independently, collaboratively, and maintain confidentiality. PREFERRED QUALIFICATIONS: · Experience with UnionWare or similar membership management systems. · Experience serving as a system administrator, power user, or subject matter expert for a database or enterprise system. · Experience with SQL, Microsoft Access, Power BI, Tableau, or similar reporting and business intelligence tools. · Experience creating automated reporting, dashboards, and data visualizations. · Experience working with labor unions, membership organizations, nonprofits, or public-sector organizations. PHYSICAL REQUIREMENTS: The physical demands described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. · Must be able to work at a desk/computer for extended periods of time. · Must be able to have repetitive wrist/hand/finger movement to work on computer and/or related office equipment. · Position requires continual mental concentration and specific attention to detail. · May be required to reach, bend, stoop, and handle objects with hands and/or fingers, talking and/or hearing, and seeing. · Position requires light to moderate work with 20 (twenty) pounds maximum weight to lift and carry. ## Description SystemsThe Data and Reporting Analyst is responsible for maintaining the integrity of Council data systems and transforming data into meaningful information that supports membership growth, operational effectiveness, and strategic decision-making. This position serves as the primary resource for reporting, analytics, data quality, and technical support related to membership, dues, bargaining unit, and organizational data systems., · Maintain and support the Council's membership, dues, bargaining unit, and organizational databases, including UnionWare and related systems. · Monitor, validate, reconcile, and maintain membership, dues, employer, and payroll deduction data to ensure accuracy and completeness. · Develop, maintain, and automate recurring and ad hoc reports, dashboards, and performance metrics for leadership staff for strategic decision-making. · Analyze membership, operational, workforce, and organizational data to identify trends, risks, opportunities, and key performance indicators. · Serve as the Council's data steward by promoting data governance standards, data quality controls, and reporting consistency. · Document data definitions, reporting procedures, and business processes. · Provide technical assistance, training, and user support related to UnionWare and other organizational data systems. · Identify opportunities to improve reporting efficiency, automate manual processes, and enhance data quality. · Assist with Unionware implementations, upgrades, testing, and enhancements. · Maintain the confidentiality, security, and integrity of organizational data and information. · Perform other duties as assigned. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Beyond Gut Feelings: The Rise of Data-Driven HR](https://www.wearedevelopers.com/videos/1326-beyond-gut-feelings-the-rise-of-data-driven-hr) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Your organization as a Graph](https://www.wearedevelopers.com/videos/2051-your-organization-as-a-graph) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)