SIGMA Business Intelligence Analyst - Departmental Analyst 9-12 - State Budget Office

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 at www.Michigan.gov/budget.

About this position: 

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. 
• Work with CGI’s Managed Advantage team to address report and ETL issues and defect resolution.

_____________________________________________________________________________________

For more information about this position, please review the duties listed in the provided links:  

POSITION DESCRIPTION - Dept Analyst 9-P11

JOB SPECIFICATION - Dept Analyst 9-12

______________________________________________________________________________________

Office location is Lansing, MI, however, SIGMA Operations and Support currently offers a hybrid work option (combination of remote/office) which requires one day working on-site at the official workstation with the potential of up to four days remote work per week.

Candidates should confirm work location and schedule at the time of interview. Work must be performed in the state of Michigan. If you currently reside outside of Michigan, you must relocate to Michigan to perform the duties of this position. Relocation expenses are not reimbursed.

_______________________________________________________________________________________

Education
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 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.

Please attach a cover letter, detailed resume, and a copy of your official college transcript(s) to your application. For our purposes, "official college transcripts" must contain the college/university name and address, the degree conferred, and date granted, coursework completed, and the Registrar's signature and/or seal. A scanned, photo, or electronic copy is acceptable if it contains the elements listed above. 

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.

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.

Serve Michigan with a Career in State Budget Office 

Accounting / Auditing / Budgeting / Finance / Systems Data and Research

State Budget Office is committed to providing an inclusive work environment that encompasses a culture of empathy, understanding, and respect with diversity of thought, perspective, and experiences. 

Why join the team at Statewide Integrated Governmental Management Applications (SIGMA)? Working for SIGMA is both challenging and rewarding. Our team members work together, problem solving and collaborating, enabling them to support each other in providing resolution to those we serve. We are dedicated to creating an equitable workplace that provides continuous opportunities for personal and professional growth. We celebrate individual and team successes often, creating a culture of inclusion and teamwork. 

• SIGMA is a great environment to be a part of, with phenomenal teamwork and communication. 
• You will have access to training, resources, and experienced staff to help you meet professional goals.
• We are committed to making a different for the citizens of Michigan.
• We encourage idea sharing/formation to support continued growth throughout our SIGMA team.

For more information on benefits, visit www.mi.gov/employeebenefits.

Don’t miss out on this opportunity to come work with us!

To be considered for this position you must:

• Apply for this position online via NEOGOV; click on "Apply" in the job posting for instructions on submitting your electronic application. Hard copy applications are not accepted.
• Relevant experience and/or education referred to in the supplemental questions must be documented in the resume, transcripts, and application to allow for accurate screening.
• Attach a resume identifying specific experience and dates of employment. Dates of employment should include month and year and hours per week.
• Attach a cover letter.
• If applicable, attach a copy of official transcript(s). We accept scanned, photos, or electronic copies of official transcripts if they contain the following elements: college/university name and address, degree conferred, date granted, coursework completed, and registrar's signature and/or seal. 

Failure to complete any of the above items may result in your application not being considered and screened out. See instructions for attaching files here:  Instructions(Download PDF reader)

Your application for any position does not guarantee that you will be contacted by the Department/Agency for further consideration.  Only those applicants interviewed will be notified of the results.

Visit the Michigan Civil Service Commission State Employment website for useful information about the job search and application process.

In accordance with federal law, all new employees must provide proof of identity and eligibility to work in the United States within three business days of beginning employment. DTMB Human Resources uses E-Verify in conjunction with the federal I-9 form to verify authorization of employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States. DTMB does not offer employment sponsorship and DTMB does not participate in STEM-OPT.

Accommodations
If you require a reasonable accommodation to participate in the application or selection processes, please contact the ADA coordinator for the agency that posted this position vacancy.