JSM Consulting Inc. · 2 days ago
155608 Programmer Analyst 6
Lansing, MI
Full-time
Onsite
Senior LevelJSM Consulting Inc. is focused on supporting public assistance programs through accurate data management. The Programmer Analyst will work with the Eligibility Data Warehouse Team to ensure data accuracy and compliance for eligibility determinations, acting as a liaison between business stakeholders and technical teams.
Business DevelopmentConsultingInformation TechnologyProject ManagementTechnical Support
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
Experience in gathering and documenting business requirements
Ability to assist stakeholders in defining reporting/ETL requirements
Experience in performing data quality checks and troubleshooting reporting issues
Knowledge of data reporting and analytics enhancements and integrations
Participation in process improvement initiatives, gap analysis, and change management activities
Experience in providing training and technical support to end users for reporting tools and processes
Ability to differentiate between defects and new requirements
Experience in developing training content
Knowledge of 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 and system specialists
Knowledge of identifying security requirements and standards
Experience in developing and executing ad hoc SQL queries
Ability to create and maintain reports and dashboards using SQL-based tools
Company
JSM Consulting Inc.
We focus on improving our client’s assets performance and optimizing the operations through our industry best practices and asset management capabilities.
Founded in 2011
11-50 employees
H1B Sponsorship
JSM Consulting Inc. 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 (18)
2024 (7)
2023 (11)
2022 (12)
2021 (20)
2020 (19)
Funding
Current Stage
Early StageCompany data provided by crunchbase