SIGMA Business Intelligence Analyst - Departmental Analyst 9-12 - State Budget Office Salary $25.85 - $43.73 Hourly Location Lansing, MI Job Type Permanent Full Time Remote Employment Flexible/Hybrid Job Number 0701-26-30-51NG Department Technology, Management and Budget Bargaining Unit NON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE) Job 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 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 POSITION DESCRIPTION - Dept Analyst 12 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. Required Education and Experience Education Possession of a bachelors 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 Registrars signature and/or seal. A scanned, photo, or electronic copy is acceptable if it contains the elements listed above. Experience 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 bachelors 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. Additional Requirements and Information 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. 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 registrars 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. State employment also offers rewarding careers where you can help Michiganders enjoy better lives. Many State of Michigan jobs offer alternate work schedules and remote-work options that can help give the flexibility you need. The State of Michigan has been recognized as a leading U.S. employer by new graduates from 2021-2023 and a best large U.S. and state employer. Recognized on the international stage for fostering positive employee engagement, the State of Michigan is a past recipient of a North America Government Agency Employees Engagement Award. More details on benefits for our new hires are below: Rewarding Work: State of Michigan jobs allow you to serve Michiganders in many different ways depending on your interests and skills. Help preserve and protect our environment and the public health; enforce state laws and regulations; advocate for children, families, and victims of discrimination; support our state's military and veterans; rebuild our state's infrastructure; or support other state agencies through our fiscal, IT, and HR systems. Insurance Benefits: The State of Michigan offers health, mental health, dental, and vision insurance to eligible career employees, their spouses, and their children. The state also covers a life-insurance benefit of two times employees' annual salary (up to $200,000). The state also offers long-term-disability insurance that can provide continuing benefits if an injury or illness prevents employees from working. More information is available at www.mi.gov/employeebenefits. Retirement Programs: The State of Michigan offers 401(k) and 457 plans for new hires to save for retirement. The state will automatically contribute an amount equal to 4% of your pay to a 401(k) account. The state will also match up to 5% of your pay if you contribute to your 401(k) account. Your contributions vest immediately, and the state's contributions fully vest after just 4 years. More information is available at http://www.mi.gov/orsstatedc. Vacation and Sick Leave: Eligible full-time employees receive between 15 and 35 personal days and 13 sick days per year that may be rolled over to the following year if not used. Eligible employees also receive an additional day each year for community service or school functions. Paid Parental Leave: Eligible employees can take 12 weeks of paid leave immediately after a birth or adoption to allow needed time together at home with a new child. Paid Holidays: Eligible employees receive 13 or 14 paid holidays each year including New Year's Eve and Day, Martin Luther King Jr. Day, Presidents' Day, Memorial Day, Juneteenth, the Fourth of July, Labor Day, Election Day, Veterans Day, Thanksgiving, Thanksgiving Friday, Christmas Eve and Day. Bonus Programs: Eligible employees with five years of service also receive annual longevity bonuses that grow as seniority increases. Some positions also may qualify for recruitment, retention, and performance bonuses or other special pay premiums. Military Pay Differential: Employees in the guard or reserves may also qualify for supplemental pay benefits if miliary pay during qualifying duty is less than normal state pay. Prior military service may also allow seniority credits to accelerate eligibility for longevity bonuses and additional personal leave accrual. Tax-Advantaged Programs: In addition to 401(k) and 457 retirement accounts, the state also offers flexible spending account (FSA), health savings account (HSA), and qualified transportation fringe benefit (QTFB) programs that can help you save money by reducing your taxable income. Student Loan Forgiveness: Working for the State of Michigan may allow you to participate in programs that forgive the balance of qualifying student loans. Please view Student Loan Information to help determine if you could qualify is available from the U.S. Department of Education. Tuition Reduction: Some colleges and universities offer savings to eligible employees and family members to further their education while working for the State of Michigan. Professional Development: To help develop your career, programs are available to apply for reimbursement of up to $2,000 a year for education and training for college course credits and non-degree programs. Alternative and Remote Work Schedules: Depending on the nature of their duties, many state jobs offer flexible work schedules and remote or hybrid telecommuting options that can help obtain the work-life balance that you seek. Great Lakes and Great Times: Michigan boasts four Great Lakes, 11,000 inland lakes, 36,000 miles of rivers and streams, 20 million acres of forests, 100 state and national parks and recreation areas, 1,300 miles of bike trails, 6,500 miles of snowmobile trails, the second-most ski areas in the nation, 650 public golf courses, 600 campgrounds, and an international dark-sky park-just for starters. Our cities offer concerts and cultural events, storied sports teams, education hubs, vibrant downtowns, one-of-a-kind craft beverages, and renowned restaurants for every appetite. From urban centers to beach towns to the great outdoors, the opportunities are endless. With your state salary and benefits and Michigan's affordable cost of living, you can explore all that Michigan has to offer. Updated: 2/28/24 01 DEPTALT - Do you possess one of the following? A bachelors 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 registrars 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. - Yes - No 02 DEPTALT - Please select your level of experience. - None to one year of professional experience. - 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? - None - Less than 1 year - 1-5 years - 5-10 years - More than 10 years 04 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? - None - Less than 1 year - 1-5 years - 5-10 years - More than 10 years 06 Indicate your level of expertise using Excel. - Expert - Advanced - Proficient - Intermediate - Begginner 07 How many years of experience do you have performing data analysis or facilitating business requirements analysis? - None - Less than 1 year - 1-5 years - 5-10 years - More than 10 years 08 If you indicated that you have experience performing data analysis or facilitating business requirements analysis, please describe. If no experience, please answer N/A. 09 How many years of experience do you have designing and implementing Power BI queries and/or reports? - None - Less than 1 year - 1-5 years - 5-10 years - More than 10 years 10 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? - None - Less than 1 year - 1-5 years - 5-10 years - More than 10 years 12 If you indicated that you have experience creating SQL-Based reports, please describe. If no experience, please answer N/A. 13 Do you understand this job will require working onsite at least 1 day per week at the official work location in Lansing, MI? - Yes - No 14 To collect SBO recruitment effort data, please select from below how you learned of this job opportunity. We appreciate the feedback! - College/University Career Services Office - College/University Career Fair - Employee Referral - Govern For America - Handshake - LinkedIn - Michigan Civil Service Office of Career Services - Michigan Works! Agency - Other Job Posting Site (Indeed, ZipRecruiter) - Pure Michigan Talent Connect - State of Michigan website/NEOGOV job alert - Veterans Organization - State of Michigan Career Fair - X (previously Twitter) 15 If you selected Other Job Posting, Veteran's Organization, or Employee Referral in the previous question, please identify the source or employee name for which you learned of this opportunity. 16 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. - Yes - No