Job Details

Salary: $48,098.00 - $84,558.00 Annually
Location : Kanawha County, WV
Job Type: Full-Time Permanent
Job Number: MIS260202 PSA
Department: OSA - MANAGEMENT INFORMATION SERVICES
Opening Date: 02/24/2026
Closing Date: 3/10/2026 11:59 PM Eastern
LOCATION OF VACANCY: KANAWHA

Nature of Work
1 Vacancy
Kanawha County

As a Data Warehouse Specialist 2 working in the Office of Management Information Services, your core responsibilities will include:

Dashboard Development and Design
- Build and deploy production-ready dashboards by translating validated wireframes into functional visual analytics.
- Create complex DAX or Level of Detail (LOD) expressions, configure interactive filters, and optimize canvas backgrounds.
- Develop low-to-high fidelity wireframes and interactive prototypes in Figma to define layouts and navigation paths.
- Maintain a library of reusable UI components to ensure consistent branding across all enterprise dashboards.

Data Engineering and Optimization
- Design and maintain specialized data structures tailored to wireframe requirements.
- Optimize back-end data pipelines to support high-performance, responsive visuals without processing lag.
- Document data lineage from source systems to the final visual layer to support long-term maintenance.

Stakeholder Engagement and Project Management
- Lead stakeholder meetings to develop Statements of Work and clarify technical requirements.
- Use Figma's collaborative features to secure stakeholder approval on blueprints before initiating coding or data modeling.
- Conduct walkthroughs and training sessions for stakeholders on dashboard features and usage.

Quality Assurance and Documentation
- Implement automated validation scripts and manual testing protocols to ensure data integrity and accuracy.
- Identify and resolve discrepancies between source systems and the warehouse to prevent "bad data" from reaching end users.
- Develop and maintain comprehensive Standard Operating Procedures (SOPs) defining the end-to-end workflow from discovery to final deployment.
Click The APPLY Link To Apply Online.

Minimum Qualifications

Training: A Bachelor Degree from an accredited four-year college or university.
Substitution:
(1) An Associate Degree in a related field and two years of full-time or equivalent part-time paid experience in report design with one or more current specialized reporting tools may substitute for the required training.
OR
(2) Four years of full-time or equivalent part-time paid experience in report design with one or more current specialized SQL reporting tools may substitute for the required training.
OR
(3) Successful completion of an authorized certification program emphasizing in the capabilities and functionality of the specialized reporting tools may substitute for two years of experience listed in (1) and (2) above.

Experience:
Two years of full-time or equivalent part-time paid experience in report design with one or more current specialized SQL reporting tools.
State employment offers a variety of benefits.