OP Consulting Group LLC · 7 hours ago
Data Warehouse Business Analyst
Lansing, MI
Full-time
Hybrid
Entry, Mid LevelOP Consulting Group LLC is seeking a Data Warehouse Business Analyst to support the Eligibility Data Warehouse Team. This role involves serving as a liaison between business stakeholders and technical teams, focusing on data analysis and reporting to support eligibility determinations for assistance programs.
ConsultingInformation TechnologyStaffing AgencyTraining
Responsibilities
Collaborate with 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 entities to ensure IT solutions adhere to 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
Experience in data analysis and reporting using SQL-based tools
Ability to collaborate with program staff and technical teams to gather and document business requirements
Experience in defining reporting/ETL requirements and providing guidance on data interpretation
Ability to perform data quality checks and troubleshoot reporting issues
Experience in supporting ongoing enhancements and integrations related to data reporting and analytics
Participation in process improvement initiatives, gap analysis, and change management activities
Ability to provide training and technical support to end users for reporting tools and processes
Experience in differentiating between defects and new requirements
Ability to develop training content
Experience in designing, developing, and implementing test plans for applications or subsystems
Ability to create or collect test data and execute approved tests
Participation in artifact reviews with peers, system specialists, Enterprise Security and other entities
Ability to identify security requirements and standards
Experience in developing and executing ad hoc SQL queries to extract, analyze, and validate data
Ability to create and maintain reports and dashboards using SQL-based tools
Company
OP Consulting Group LLC
OP Consulting Group LLC, based in Michigan, USA, is a company owned and operated by women.
Founded in 2020
11-50 employees
H1B Sponsorship
OP Consulting Group LLC 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)
2024 (3)
Funding
Current Stage
Early StageLeadership Team
Venkata Surapaneni
Founder
Company data provided by crunchbase