DRS IT Solutions Inc · 4 hours ago
Data Warehouse Analyst
DRS IT Solutions Inc is focused on supporting public assistance programs through accurate data management. The Data Warehouse Analyst will collaborate with stakeholders to ensure data accuracy for eligibility determinations and reporting, while also providing training and technical support for reporting tools.
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 within 2hrs of Lansing, MI
Must be open to 1099/W2 (NO C2C)
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
Company
DRS IT Solutions Inc
DRS IT Solutions Inc is a Women-Owned boutique recruiting firm, headquartered in Novi, Michigan.
H1B Sponsorship
DRS IT Solutions 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
2023 (1)
2022 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase