ATC · 10 hours ago
Datawarehouse Business Analyst
Lansing, MI
Contract
Hybrid
Entry, Mid LevelATC is focused on supporting public assistance programs through accurate data management. The Business Analyst will liaise between stakeholders and technical teams to ensure effective data analysis and reporting for eligibility determinations and compliance with federal and state requirements.
AnimationInformation TechnologyMobile AppsSoftware
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
Experience in participating in artifact reviews with peers and system specialists
Knowledge of identifying 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
ATC
Founded in the wake of the 2008 Great Recession, ATC has evolved into a dynamic tech company, known for its ability to adapt quickly to the ever-changing business landscape.
Founded in 2007
201-500 employees
H1B Sponsorship
ATC 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 (24)
2024 (12)
2023 (13)
2022 (7)
2021 (23)
2020 (38)
Funding
Current Stage
Growth StageLeadership Team
Zainab (Ameera) A
Director of Partnerships & Training Departments/Senior Agile Specialist
Company data provided by crunchbase