Programmer Analyst 6 Data Warehouse Business
Share
Job Location:
Lansing, IL - USA
Monthly Salary:
Not Disclosed
Posted on:
2 hours ago
Vacancies:
1 Vacancy
Job Summary
Roles/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.
Mandatory Skills:
- 5 years of SQL experience
- 5 years of experience as a Business Analyst (BA)
- 5 years of experience in Agile Methodologys
Desirable Skills: N/A
Key Skills
- Cyber Security
- Business Administration
- LTE
- Content Management
- Archicad
