> Markdown version of [/jobs/ext/575541-sigma-business-intelligence-analyst-departmental](https://www.wearedevelopers.com/jobs/ext/575541-sigma-business-intelligence-analyst-departmental). 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). --- # SIGMA Business Intelligence Analyst - Departmental... - **Company:** State of Michigan - **Location:** Lansing, MI, United States (Remote available) - **Experience:** Experienced - **Salary:** $53,768.0 - $90,958.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Extract Transform Load (ETL), Power BI, SQL Databases, Custom Reports - **Published:** June 21, 2026 - **Apply:** https://www.juju.com/job/00000000g9oc86 ## About the Role JOB SPECIFICATION - Dept Analyst 9-12 (https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/D/DepartmentalAnalyst.pdf), Possession of a bachelor's degree in any major. Applicants that will earn a bachelor's degree at the end of the current semester/school year may be considered with unofficial transcripts. Please note, the final offer of employment is made once official transcripts are received and approved., Applicants who possess a degree from a foreign college or university must have their academic credentials evaluated or converted into U.S. educational equivalents unless the degree has been recognized by the Council on Higher Education Accreditation (CHEA). Go to evaluators (https://www.naces.org/members) for a list of accepted organizations that evaluate foreign credentials. Failure to provide this evaluation at the time of application may result in you being screened out of the process., Departmental Analyst 9 No specific type or amount is required. Departmental Analyst 10 One year of professional experience. Departmental Analyst P11 Two years of professional experience, including one year of experience equivalent to the intermediate (10) level in state service. Departmental Analyst 12 Three years of professional experience, including one year of experience equivalent to the experienced (P11) level in state service. The "Salary" listed is a range that reflects the minimum rate through the maximum rate of the position. Based on education and experience, candidates will be reviewed to determine what level they are qualified for. Note: Experience is considered professional if the job required a bachelor's degree. Alternate Education and Experience Departmental Analyst 9 - 12 Educational level typically acquired through completion of high school and the equivalent of at least two years of full-time active-duty experience at or above the E-6 level in the uniformed services may be substituted for the education requirement., DEPTALT - Do you possess one of the following? A bachelor's degree or higher in any major. If so, a copy of your official college transcripts* is required. *Official transcripts provide the name of the institution, confirmation that a degree was awarded and on what date, and the registrar's signature. Scanned copies of official transcripts are attached to your application. OR at least one year of professional level experience in the state classified service. OR the Educational level typically acquired through completion of high school and the equivalent of at least two years of full-time active-duty experience at or above the E-6 level in the uniformed services may be substituted for the education requirement. Please attach a copy of your DD214., + One to two years of professional experience. + Two to three years of professional experience. + At least three years of professional experience. 03 How many years of experience do you have acting as a liaison between technical and business teams?, If you indicated that you have experience as a liaison between technical and business teams, please describe. If no experience, please answer N/A. 05 How many years of experience do you have working with Microsoft Excel?, How many years of experience do you have performing data analysis or facilitating business requirements analysis?, If you indicated that you have experience performing data analysis or facilitating business requirements analysis, please describe. If no experience, please answer N/A., How many years of experience do you have designing and implementing Power BI queries and/or reports?, If you indicated that you have experience designing and implementing Power BI queries and/or reports, please describe. If no experience, please answer N/A. 11 How many years of experience do you have creating SQL-Based reports?, If you indicated that you have experience creating SQL-Based reports, please describe. If no experience, please answer N/A. ## Description State Budget Office is responsible for coordinating all aspects of the state budget, including development of the Governor's Executive Budget recommendation, monitoring of the budget to ensure continued fiscal balance, and other budgetary analysis functions. Learn more atwww.Michigan.gov/budget., Statewide Integrated Governmental Management Applications (SIGMA) is housed within State Budget Office and is the backbone for the State of Michigan government operations, supporting budget, financial management, procurement, timekeeping and labor cost allocation, inventory management, and grant/project accounting. The role of SIGMA support staff is to support the daily operations of the system, working towards continuous improvement of SIGMA's functionality, providing training and help desk resources to users. As a SIGMA Business Intelligence Analyst, you will: + Evaluate existing baseline or custom reports to recommend if either can be leveraged to address new requests for reports and queries. + Assist with documenting reporting requirements and coordinating these efforts with SIGMA Functional Centers of Excellence. + Develop estimates and project plans to implement approved work requests. + Assist in building SIGMA queries and reports in SIGMA Advantage Insight with Power BI. + Make recommendations to correct problems related to Power BI that arise such as determining why data is missing or corrupted and determining a solution for resolving the problem. + Assist or build queries and reports for various projects. + Build and modify Power BI queries used by SOS End User Support Security staff, Agency Security Administrators, Departmental Security Administrators, Agency Report Coordinators, and central control staff to monitor and manage system access. + Execute and maintain report distribution, ETL and system assurance/data assurance processing through coordination with managed services functions and, where applicable, through direct processes. + Work with the Centers of Excellence and End User Support to address changes to the reports, report distribution schedules, ETL (Extract, Transfer, and Load) schedules, and system assurance and data assurance processes., Did you attach a cover letter, resume and your official college transcripts to your application? Or if a student expected to graduate within the current semester/school year unofficial transcripts to your application? Ensuring requested supporting documents are attached to the application aids in the credential's evaluation process. ## 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) - [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) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Best practices: Building Enterprise Applications that leverage GenAI](https://www.wearedevelopers.com/videos/1513-best-practices-building-enterprise-applications-that-leverage-genai) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Starter Kit For Job Applications For Developers](https://www.wearedevelopers.com/magazine/7-starter-kit-for-job-applications-for-developers)