Prepare for and practice interview questions from State Of Michigan.

State Of Michigan Interview Questions

State Of Michigan Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

State Of Michigan Salaries by Position

Assessment and Accountability Data Analyst - Departmental Analyst 9-P11Print (https://www.governmentjobs.com/careers/michigan/jobs/newprint/4750195)Apply?Assessment and Accountability Data Analyst - Departmental Analyst 9-P11Salary$52,208.00 - $81,806.40 AnnuallyLocationLansing, MIJob TypePermanent Full TimeRemote EmploymentFlexible/HybridJob Number3103-24-123THDepartmentEducationOpening Date12/05/2024Closing Date1/5/2025 11:59 PM EasternBargaining UnitNON-EXCLUSIVE REPRESENTED EMPLOYEE (NERE)DescriptionBenefitsQuestionsJob DescriptionThe Michigan Department of Education (MDE)provides leadership, resources, support, and guidance to approximately 200,000 school district staff serving approximately 1.5 million students in public and non-public schools and 39,000 students in special education transition services. In addition, MDE provides administrative support and supervision for the Michigan School for the Deaf and the Library of Michigan.MDE is responsible for state education leadership in a local control state and works to implement state and federal education laws, disburse state and federal resources, license educators, develop state summative assessments and accountability systems, create state academic standards, and coordinate school health and nutrition programs. In addition, in developing and promoting the states Top 10 Strategic Education Plan, MDE works with partner education entities and stakeholders to improve public education for children across the state. MDEs role in the improvement of public education extends to providing information and feedback to public policy-makers, convening educators on public policy issues, recommending draft language on legislation, and developing guidance to districts on statutory changes adopted at the state and federal levels.Join a team of highly trained and educated individuals committed to supporting learners and learning in Michigan. Serving students, parents, families, educators, and communities within a culture that promotes excellence and respects diversity, our work is meaningful and impactful.As a State of Michigan employee, you will receive a competitive wage and benefit package that values your experience and skills. You will join a team of more than 400 professionals at the department and almost 50,000 in state government who are committed to excellence in public service.The Office of Educational Assessment & Accountability(OEAA ) is an office within the DESSS. The responsibilities of this office include:Developing, administering, and reporting on assessment programsJointly developing and maintaining content standards with OESElectronically housing the libraries of content standards developed jointly with OESDeveloping achievement standards (i.e., proficiency standards or cut scores) on the assessment programs for which it is responsibleOperating the Formative Assessment for Michigan Educators (FAME)Program and data management of all OEAA projectsManagement for all the OEAA systems (Secure Site, Item Bank System, etc.)Responding to assessment and accountability reports and state analysis requestsPrimary Physical Work Address - Position is located at the John Hannah Building, 608 West Allegan Street, Lansing, Michigan. Hybrid flexible schedule of in-person and remote work arrangement.Position Summary: This position functions as the Assessment and Accountability data analyst for the Accountability unit within the Office of Assessment and Accountability within the Michigan Department of Education (MDE). This position assists in the data-related processes used for the analysis of assessment and accountability data as well as other ad hoc projects. This position ensures the quality of data that are imported for use and confirms the file integrity and accuracy of all data that are used to determine school and student performance and success, and research results related to the state's assessment and accountability systems. This position creates analyses to support decision-making related to assessment and accountability system policies and procedures.Position Description (https://mcsc.state.mi.us/AgencyPDFs/24.123OEEAandAAnalyst.pdf)Departmental Analyst 9-P11 Job SpecificationRequired Education and ExperiencePlease review the job specification and the position description for the full list of responsibilities, required education and experience, and knowledge, skills, and abilities.Alternate Education and ExperienceEquivalent combinations of education and experience that provide the required knowledge, skills, and abilities will be evaluated on an individual basis.Additional Requirements and InformationYour submittal is considered complete with the following required documents:Completed ApplicationResume (entered or attached to the job posting)Official copy of transcriptsThe Michigan State Employees Retirement System (MSERS) is separate from the Michigan Public School Employees Retirement System (MPSERS). If you are currently a MPSERS retiree, there should be no impact to your MPSERS pension due to employment with the Michigan Department of Education. If you are currently eligible for a MPSERS retirement benefit and become the successful candidate for this position, you should contact the Office of Retirement Services (ORS) to determine any impact if you elect to immediately begin receiving your MPSERS retirement benefit.AccommodationsIf you require a reasonable accommodation to participate in the application or selection processes, please contact theADA coordinator (https://www.michigan.gov/ose/-/media/Project/Websites/ose/Contact/RACs.pdf) 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 states military and veterans; rebuild our states 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 states contributions fully vest after just 4 years. More information is available athttp://www.mi.gov/orsstatedc.Vacation and Sick Leave:Eligible full-time employees receive between15 and 35 personal daysand 13 sick daysper 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 leaveimmediately 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 Years 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. Information (https://studentaid.gov/manage-loans/forgiveness-cancellation) 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 parkjust 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 Michigans affordable cost of living, you can explore all that Michigan has to offer.Updated: 2/28/2401MDE1 - Do you understand that failure to provide all requested documentation (cover letter, resume, and transcripts) may result in elimination from the competitive process?YesNo02MDE2 - The State of Michigan is a drug free workplace. Prospective employees will be required to pass a pre-employment drug test. Do you understand this requirement?YesNo03MDE3 - Do you currently work at the Michigan Department of Education in one of the following capacities? (The Michigan Department of Education is a department within the State of Michigan government. Michigan Public School employees are not employees of the Michigan Department of Education.)Current State of Michigan Department of Education employeeTemporary Service employeeContractor Service employeeNone of the above04MDE4 - Please indicate how you learned of this Michigan Department of Education job posting (e.g., State of Michigan Job Opportunities web site, MASA website, etc.).05MDE5 - Please be aware the application review and determination of your eligibility for this position is based solely upon the information provided in your application packet, especially the Work Experience, Supporting Attachments (transcripts, certifications, etc.) and Supplemental Questions sections of your application. Therefore, it is imperative that you provide extensive detail and accurate dates of employment in the applicable sections of your application. It is the applicant's responsibility to attach official college transcripts to the application. For our purposes, an official college transcript must contain your name, the college name/address, the degree conferred/date granted, coursework completed (especially if no degree was granted) and the Registrar's signature and/or seal. A scanned or electronic copy is acceptable, as long as it contains the elements listed above. Web-based, internet, or unofficial transcripts are not acceptable. Failure to attach official transcripts may eliminate your application from the selection process. Information provided in your application, resume, transcripts, and any other documentation provided will be used to verify responses to the supplemental questions. Unsupported responses or applications without requested application materials may be eliminated from further consideration. Have you read and understood the process for submission and use of your application materials?YesNo06MDE6 - Are the responses to your supplemental questions reflected in your application supporting materials? Please note, if information is not reflected in the supporting materials, you could be screened out.YesNo07DEPTALT 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.08DEPTALT - Do you possess one of the following? A bachelor's degree or higher in any major. If so, please attach a copy of your official college transcripts. 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.YesNo09Do you have experience directly related to data analysis of large data sets, preferably in an educational setting related to large-scale testing (10,000 students or more), accountability, or evaluation processes?YesNo10Please describe your experience directly related to data analysis of large data sets, preferably in an educational setting related to large-scale testing (10,000 students or more), accountability, or evaluation processes.11How many years of experience with data querying language such as MS SQL do you have?NoneLess than 1 year1 to 3 years3 to 5 years5 or more years12How many years of experience using data analysis techniques using software such as MS Excel, SAS, or similar applications do you possess?NoneLess than 1 year1 to 3 years3 to 5 years5 or More years13How many years of experience creating and using data visualizations using software such as MS Excel, MS Power BI, SAS, Tableau, or similar applications do you have?NoneLess than 1 year1 to 3 years3 to 5 years5 or more years14Describe your experience in merging files of data and information, including the largest data set analyzed and software used.Required QuestionAgencyState of MichiganDepartmentEducationAddressMDE-Human-Resources@michigan.gov608 West Allegan StreetLansing, Michigan, 48933Websitehttps://www.michigan.gov/mdeApplyPlease verify your email addressVerify Email

This position provides data analytics and operational support to the Collection Services Bureau (CSB) staff and third-party collection vendors in alignment with legislative requirements. The primary duties of this position are as following: (1) oversight of data analysis programs and projects including related research, studies, surveys, statistical and trend analysis, and recommendations for data system parameters and thresholds; (2) business intelligence support (dashboards, scorecards, etc.) and reporting, including biannual reports to the legislature; and (3) service in the role of Data Steward with regard to Treasury and CSB interfaces, adherence to standards and procedures for the Treasury Data Governance Program, and liaison to the data warehouse.The employee in this position is a member of the Data Analytics and Governance team and, as such, participates in special projects, gives presentations, attends meetings on behalf of CSB, and works with peers and managers to resolve issues. This employee contributes to the continuous improvement of CSB by participating on committees as directed, tracking, and aligning Bureau metrics, and assisting in the development and implementation of strategic goals.

State Of Michigan Interview Questions

State Of Michigan Interview Guides

State Of Michigan Interview Questions

State Of Michigan Salaries by Position

State Of Michigan Opening Jobs