The State Of Michigan Business Intelligence interview guide, interview questions, salary data, and interview experiences.

State Of Michigan Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at State Of Michigan? The State Of Michigan Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for State Of Michigan Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at State Of Michigan.</li>
<li>Practice real State Of Michigan Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the State Of Michigan Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at State Of Michigan? The State Of Michigan Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for State Of Michigan Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at State Of Michigan.
- Practice real State Of Michigan Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the State Of Michigan Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

State Of Michigan Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

State Of Michigan Business Intelligence Interview Questions

The Department of Technology, Management and Budget supports the business operations of state agencies through a variety of services, including building management and maintenance, information technology, centralized contracting and procurement, budget and financial management, space planning and leasing, construction management, motor vehicle fleet operations, and oversight of the state retirement systems. This position is with the Agency Services area of DTMB.

As a Senior IT Business Analyst, the employee performs a complete range of information system analyst assignments including, but not limited to, designing, developing, testing, and implementing computer systems and applications for the Michigan Department of Health and Human Services (MDHHS) in support of Medicaid. This individual will be looked upon to provide technical support to other team members and evaluate new development tools and agency systems. Evaluate, document, and inform DTMB management and supported client agency of impact and risks, including disaster recovery planning, to our solutions due to proposed legislation, enhancement requests, or changes in governmental processes or procedures. Actively participate in the development and implementation of assigned client agency’s IT strategic direction/plan. Mentors other DTMB staff to resolve client agency IT issues.

In accordance with federal law, all new employees must provide proof of eligibility to work in the United States within three business days of beginning employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States.

SIGNING BONUS:
This position may be eligible for a sign-on bonus up to $2,500. Up to $1,250 to be paid upon new hire and the remainder to be paid after satisfactory completion of the initial probationary period (12-month period). This does not apply to current state employees.

Classifications for the $2,500 bonus are:
Information Technology Infrastructure Analyst
Information Technology Programmer/Analyst
Information Technology Project Coordinator
Information Technology Project Manager
Information Technology Specialist

The state of Michigan offers a competitive work experience that includes a tuition reduction program at several key higher education institutes if you would like to advance your education, good benefits, excellent vacation, and sick time policies, and an ability to successfully juggle your work and family life. We would like the opportunity to share with you more about the benefits of working for the state and joining the state of Michigan employee family if you are interested. Please consider sending in your application today.

Position Location/Remote Office:  The office location is Lansing, MI. The State of Michigan is not able to offer employment to out-of-state applicants that do not plan to relocate. The Department of Technology Management and Budget currently offers a hybrid work option which requires two days working on-site at the official work location and three days of remote work per week.

DTMB is proud to be a Michigan Veteran’s Affairs Agency (MVAA) Gold Level Veteran-Friendly Employer.

Education

Information Technology Programmer/Analyst 12
Possession of a Bachelor's degree with 21 semester (32 term) credits in one or a combination of the following: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, information assurance, IT project management or mathematics.

Experience

Information Technology Programmer/Analyst 12
Two years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11.

Information Technology Programmer/Analyst 12
Possession of an associate's degree with 16 semester (24 term) credits in computer science, information assurance, data processing, computer information, data communications, networking, systems analysis, computer programming, IT project management, or mathematics and two years of experience as an application programmer, computer operator, or information technology technician; or two years (4,160 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.

OR

Educational level typically acquired through completion of high school and four years of experience as an application programmer, computer operator, information technology technician, or four years (8,320 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.

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, transcript and/or 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 an official transcript(s). We accept scanned copies of official transcripts. We do not accept web-based, internet, or copies of unofficial transcripts. Official transcripts provide the name of the institution, confirmation that a degree was awarded and on what date, and the registrar's signature.

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.

The Office of Career Services offers current State Employees and interested applicants access to the job application process and a variety of career planning resources.

In accordance with federal law, all new employees must provide proof of eligibility to work in the United States within three business days of beginning employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States.

Certain positions may require certification in specific information technology programs.

View the job specification at:  https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/I/InformationTechnologyProgrammerAnalyst.pdf

#J-18808-Ljbffr

<p>The Department of Technology, Management and Budget supports the business operations of state agencies through a variety of services, including building management and maintenance, information technology, centralized contracting and procurement, budg Business Analyst, Information Technology, Business Operations, Senior, Analyst, Computer Science</p>

The   Center for Educational Performance and Information   (CEPI)  is housed within State Budget Office and is responsible for coordinating the management, collection, and reporting of all education data, including the electronic exchange of student records between preschool, K-12, and postsecondary education.
CEPI is recruiting to fill an Analytics Manager position in the PK-12 Data Unit in the Office of Analytics and Reporting responsibilities of the unit include analyzing data extracts produced from CEPI and external systems; Evaluating the level of data reliability and accuracy; Loading data into the Michigan Statewide Longitudinal Data System (MSLDS; Designing and delivering content that meets recurring and ad hoc data needs; Advising stakeholders on appropriate data use; and Making recommendations to improve the validity and accuracy of data across the full cycle. This position directs and oversees the work of other professional staff in this area, organizing and reviewing work assignments, coordinating activities, and resolving work-related issues, as well as working closely with other Office of Analytics and Reporting (OAR) managers and staff in other CEPI work units to promote a positive team environment. The ideal candidate will possess strong written and verbal communication, planning, critical thinking, team building, analytics, and liaison skills. If you are passionate about using data to enhance education and thrive in a collaborative environment, apply to join a team that is making a meaningful impact across Michigan’s education landscape.
As the Analytics Manager your primary responsibilities include:
Serve as a first-line manager for analytics methods being applied against Michigan educational data collected and utilized in CEPI's data systems. Directing and supervising the work of unit analysts including the planning/scheduling/tracking of assignments in alignment with other CEPI units.
The position maintains a staff of trained analysts by coordinating the hiring, training and evaluation of new resources.  Responsible for providing direction and guidance to resources that align with CEPI’s goals for timely, accurate information published through various CEPI systems.
Oversee the creation of analytics processes that are designed, documented, implemented and maintained. This includes performance monitoring, measurement and feedback functions to ensure the accuracy and reliability of the data with other CEPI units.  Communicate with CEPI teams to ensure that quality standards are met during transition of data between teams.
Serve as a champion for team projects within the unit involving critical thinking while serving as a positive role model for the team and organization.
_________________________________________________________________________
For more information about this position, please review the duties listed in the provided links:
POSITION DESCRIPTION
JOB SPECIFICATION
__________________________________________________________________________
The CEPI office is in Lansing, Michigan, however a hybrid work option (combination of remote/in-office) is currently offered 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.
__________________________________________________________________________
This position is being filled as limited term.
Limited Term is an appointment which has an expiration date. For this position, the Limited Term assignment will begin on the date of hire and expire two years from the date of hire. Limited-Term employees are encouraged and supported in seeking permanent employment within SBO/the State of Michigan prior to the appointments’ end.
Education
Possession of a bachelor's degree in any major.
Experience
Four years of professional experience, including two years equivalent to the experienced (P11) level or one year equivalent to the advanced (12) level.
Serve Michigan with a Career in State Budget Office
Accounting / Auditing / Budgeting / Finance / Systems Data and Research
State Budget Office/Center for Educational Performance and Information is committed to providing an inclusive work environment that encompasses a culture of empathy, understanding, and respect with diversity of thought, perspective, and experiences.
Working for the Center for Educational Performance and Information is both rewarding and challenging.
Our team members work together through problem solving, collaborating, and supporting one another.
Idea sharing and formation is encouraged to support continued growth throughout our teams.
Staff are provided access to training, resources, and experienced team members.
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 current cover letter and detailed resume identifying specific experience and dates of employment.
If applicable, attach a copy of official transcript(s). We accept scanned or electronic copies of official transcripts if they contain the following elements: college/university name and address, degree conferred, date granted, coursework completed, and the registrar's signature and/or seal.
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.
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 and the State Budget Offices do not offer employment sponsorship and does not participate in STEM-OPT.

#J-18808-Ljbffr

Join to apply for the  ITPA12 - Intermediate Software Engineer  role at  State of Michigan
1 week ago Be among the first 25 applicants
Join to apply for the  ITPA12 - Intermediate Software Engineer  role at  State of Michigan
Job Description

The Department of Technology, Management and Budget supports the business operations of state agencies through a variety of services, including building management and maintenance, information technology, centralized contracting and procurement, budget and financial management, space planning and leasing, construction management, motor vehicle fleet operations, and oversight of the state retirement systems. This position is with the Agency Services area of DTMB.
Job Description

The Department of Technology, Management and Budget supports the business operations of state agencies through a variety of services, including building management and maintenance, information technology, centralized contracting and procurement, budget and financial management, space planning and leasing, construction management, motor vehicle fleet operations, and oversight of the state retirement systems. This position is with the Agency Services area of DTMB.

This position functions as a Senior Application Developer and will perform a complete range of information system analyst assignments including, but not limited to, designing, developing, testing, implementing computer systems, applications and upgrade technologies as needed for DTMB Agency Services supporting MDHHS. This individual will be looked upon to provide technical support to other team members and evaluate new development tools and agency systems.

DTMB does not participate in STEM-OPT.

Signing Bonus

This position may be eligible for a sign-on bonus of up to $2,500. Up to $1,250 to be paid upon new hire and the remainder to be paid after satisfactory completion of the initial probationary period (12-month period). This does not apply to current state employees.

The state of Michigan offers competitive work experience that includes a tuition reduction program at several key higher education institutes if you would like to advance your education, good benefits, excellent vacation, and sick time policies, and an ability to successfully juggle your work and family life. We would like the opportunity to share with you more about the benefits of working for the state and joining the state of Michigan employee family if you are interested. Please consider sending in your application today.

ITPA 12 -   Position Description

DTMB is proud to be a Michigan Veteran’s Affairs Agency (MVAA) Gold Level Veteran-Friendly Employer.

Position Location/Remote Office: The office location is Lansing, MI. The State of Michigan is not able to offer employment to out-of-state applicants that do not plan to relocate. The Department of Technology Management and Budget currently offers a hybrid work option which requires two days working on-site at the official work location and three days of remote work per week.

Required Education And Experience

Education

Information Technology Programmer/Analyst 12

Possession of a Bachelor's degree with 21 semester (32 term) credits in one or a combination of the following: computer science, data processing, computer information systems, data communications, networking, systems analysis, computer programming, information assurance, IT project management or mathematics.

Experience

Information Technology Programmer/Analyst 12

Two years of professional experience equivalent to an Information Technology Infrastructure or Programmer/Analyst P11.

Alternate Education And Experience

Information Technology Programmer/Analyst 12

Possession of an associate's degree with 16 semester (24 term) credits in computer science, information assurance, data processing, computer information, data communications, networking, systems analysis, computer programming, IT project management, or mathematics and two years of experience as an application programmer, computer operator, or information technology technician; or two years (4,160 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.

OR

Educational level typically acquired through completion of high school and four years of experience as an application programmer, computer operator, information technology technician, or four years (8,320 hours) of experience as an Information Technology Student Assistant may be substituted for the education requirement.

Additional Requirements And Information

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, transcript and/or 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 an official transcript(s). We accept scanned copies of official transcripts. We do not accept web-based, internet, or copies of unofficial transcripts. Official transcripts provide the name of the institution, confirmation that a degree was awarded and on what date, and the registrar's signature.

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.

The Office of Career Services offers current State Employees and interested applicants access to the job application process and a variety of career planning resources.

In accordance with federal law, all new employees must provide proof of eligibility to work in the United States within three business days of beginning employment. If selected for employment, you must be able to submit proof of your legal right to work in the United States.

Certain positions may require certification in specific information technology programs.

View the job specification at: https://www.michigan.gov/mdcs/-/media/Project/Websites/mdcs/JOBSPECS/I/InformationTechnologyProgrammerAnalyst.pdf

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.
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Engineering and Information Technology
Industries Government Administration
Referrals increase your chances of interviewing at State of Michigan by 2x
Sign in to set job alerts for “Intermediate Software Engineer” roles.  Programmer 6 - Full-Stack Java Developer  SDET with Playwright_Okemos, MI_Only on W2_No 1099/C2C  Lansing, MI $60,000.00-$70,000.00 6 hours ago
Senior Application Developer (Full Stack)  We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

State Of Michigan Business Intelligence Interview Guide

Overview

State Of Michigan Business Intelligence Interview Process

State Of Michigan Business Intelligence Interview Questions

State Of Michigan Business Intelligence Jobs