| Data Warehouse Business Analyst || Location - Lansing, MI, Hybrid || F2F Interveiw || at Lansing, Michigan, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3110412&uid=1525ed4e08904781b11e5a89c1ee3318 From: Anuj, Vyze inc [email protected] Reply to: [email protected] Job Description - Job Title: Data Warehouse Business Analyst / Reporting Analyst Location: Lansing, MI( need local only) must have LinkedIn Interview Process: Candidates submitted must be willing to come onsite (Lansing, MI) for interviews. A screenshot photo of candidate will be required for any interviews as well as a vendor representative present at beginning of any MS Teams interview to validate candidate. Also fill the three pre screening question along with the submission mention below Position Overview An enterprise organization supporting large-scale social service and benefits programs is seeking a Data Warehouse Business Analyst to support a mission-critical eligibility and reporting data environment. This team plays a key role in ensuring that accurate, timely, and reliable data is available to support eligibility determinations, operational reporting, compliance, and program oversight. The Business Analyst will partner closely with business stakeholders and technical teams to analyze data needs, translate requirements into actionable reporting solutions, and deliver SQL-based queries, reports, and dashboards. This role requires strong analytical skills, comfort working with complex datasets, and the ability to clearly communicate insights to both technical and non-technical audiences. Job Scope & Responsibilities Collaborate with program stakeholders and technical teams to elicit, analyze, and document business and reporting requirements. Act as a liaison between business users and data/technical teams to ensure reporting solutions align with operational and regulatory needs. Assist stakeholders in defining reporting and ETL requirements, including guidance on data interpretation and usage. Develop and execute ad hoc SQL queries to extract, analyze, and validate data from the data warehouse. Create, maintain, and enhance reports and dashboards using SQL-based reporting tools to support decision-making and oversight. Perform data quality checks, investigate anomalies, and troubleshoot reporting issues to ensure accuracy and reliability. Support ongoing reporting enhancements, integrations, and analytics-related initiatives. Participate in process improvement efforts, including gap analysis and change management activities. Differentiate between defects and new requirements, working with stakeholders to prioritize and document outcomes. Design, develop, and execute test plans for reporting solutions, applications, or subsystems. Create or source test data and execute approved test scenarios to validate logic and outputs. Develop training materials and provide guidance or support to end users on reporting tools and processes. Participate in peer and cross-functional reviews to ensure solutions align with enterprise standards, security requirements, and governance guidelines. Identify and document security, data protection, and compliance requirements relevant to reporting solutions. Required Qualifications & Experience 5+ years of hands-on experience writing and optimizing SQL queries for reporting, analysis, and data validation. 5+ years of experience working as a Business Analyst supporting data, reporting, or analytics initiatives. 5+ years of experience working in Agile delivery environments, including backlog refinement, sprint planning, and iterative delivery. Strong experience translating business needs into clear reporting and data requirements. Proven ability to work with large, complex datasets and explain findings to non-technical stakeholders. Experience performing data quality analysis, validation, and troubleshooting. Strong documentation, communication, and stakeholder engagement skills. 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 Keywords: active directory microsoft mississippi Michigan Data Warehouse Business Analyst || Location - Lansing, MI, Hybrid || F2F Interveiw || [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3110412&uid=1525ed4e08904781b11e5a89c1ee3318 |
| [email protected] View All |
| 05:37 AM 05-Feb-26 |