Smith Johnson Tech · 5 hours ago
Data Warehouse Business Analyst
Lansing, MI
Full-time
Hybrid
Senior Level
5+ years expSmith Johnson Tech is a company focused on providing essential support to individuals and families through public assistance programs. The Data Warehouse Business Analyst will serve as a liaison between business stakeholders and technical teams, ensuring accurate data analysis and reporting to support eligibility determinations for DHHS assistance programs.
Information TechnologyProfessional ServicesRecruitingStaffing Agency
Hiring Manager
Karalee Hughes
Responsibilities
Collaborate with DHHS 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
Participate in artifact reviews with peers, system specialists, Enterprise Security and other DTMB entities to ensure IT solutions adhere to DTMB and agency policies, standards or guidelines
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
Qualification
Required
Must be currently living within 90 mins of Lansing, Michigan; no exceptions or relocation
Must be willing and able to interview in-person, onsite (Lansing, Michigan)
5+ years of SQL experience
5+ years of experience as a Business Analyst (BA)
5+ years of experience in Agile Methodology's
Benefits
Medical
Dental
Life
Disability
PTO/holiday accrued monthly
3% retirement matching plan
Company
Smith Johnson Tech
SJT is an employee owned company with 30 years of experience in the Information Technology Staffing & Recruiting industry.
51-200 employees
H1B Sponsorship
Smith Johnson Tech has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (1)
2020 (3)
Funding
Current Stage
Growth StageLeadership Team
Dennis Johnson
Chief Executive Officer
Company data provided by crunchbase