Must Be MI Residents || Data Warehouse Business Analyst

Top Skills & Years of Experience: - 5+ years of SQL experience - 5+ years of experience as a Business Analyst (BA) - 5+ years of experience in Agile Methodology’s Duration: 1 year with possible extension. Remote or On-site: Accepting local candidates within 2 hours of Lansing, MI ONLY. Position will be hybrid, in office 2 days a week upon start and there is NO REMOTE ONLY option. Tasks: • Collaborate with the Agency program staff and technical teams to gather and document business requirements. • Assist stakeholders in defining reporting/ETL requirements and provide guidance on data interpretation. • Perform data quality checks and troubleshoot reporting issues to ensure accuracy and compliance. • Support ongoing enhancements and integrations related to data reporting and analytics. • Participate in process improvement initiatives, gap analysis, and change management activities. • Provide training and technical support to end users for reporting tools and processes. • Assist in differentiating between defects and new requirements. • Develop training content. • Design, develop, and implement test plans for applications or subsystems. • Create or collect test data and execute approved tests to determine the accuracy of program logic to produce desired results. • Identify security requirements and standards. • Develop and execute ad hoc SQL queries to extract, analyze, and validate data. • Create and maintain reports and dashboards using SQL-based tools to meet reporting needs. Question 1: Describe a time when you gathered and documented business requirements for a data or reporting project. How did you ensure the requirements were clear, complete, and aligned with stakeholder expectations? Question 2: Have you worked in an Agile or Scrum environment within a public sector or state agency setting? If so, describe your role in planning activities such as sprint planning or backlog refinement, and how you ensured compliance with organizational standards and timelines. Question 3: Explain your experience writing SQL queries for data analysis or reporting. What steps do you take to validate your query results and ensure data accuracy before delivering them?