Data Warehouse Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

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.

Business DevelopmentInformation TechnologySoftware
check
H1B Sponsor Likelynote
Hiring Manager
Sara RG
linkedin

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

SQLData analysisReporting toolsETL requirementsBusiness analysisData quality checksTechnical supportProcess improvement

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

twittertwitter
company-logo
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 Stage

Leadership Team

leader-logo
Rajee Nair
President & CEO
linkedin
Company data provided by crunchbase