Data Warehouse Analyst

- Collaborate with program staff and technical teams to gather and document business requirements - Assist stakeholders in defining reporting and ETL requirements, providing guidance on data interpretation - Conduct data quality checks and resolve reporting issues to ensure accuracy and compliance - Support ongoing enhancements and integrations related to data reporting and analytics - Engage in process improvement initiatives, gap analysis, and change management activities - Provide training and technical support to end users for reporting tools and procedures - Distinguish between defects and new requirements - Develop training materials - Design, develop, and implement test plans for applications or subsystems - Create or gather test data and execute approved tests to validate program logic - Participate in artifact reviews with peers, system specialists, and department entities to ensure compliance with policies and standards - Identify security requirements and standards - Generate and execute ad hoc SQL queries for data extraction, analysis, and validation - Create and maintain reports and dashboards using SQL-based tools to fulfill reporting needs