Fresh Listing

Posted: February 24, 2026 (1 day ago)

This job was posted recently. Fresh listings typically have less competition.

Data Warehouse Specialist 2-OSA-Management Information Services-Kanawha Co.

State of West Virginia

OSA - MANAGEMENT INFORMATION SERVICES

Fresh

Location

West Virginia, 25305

Salary

$48,098 - $84,558

per year

Closes

March 11, 2026

SES Pay Grade

Base salary range: $147,649 - $221,900

Typical requirements: Executive-level leadership experience. Senior executive qualifications required.

Note: Actual salary includes locality pay (15-40%+ depending on location).

Job Description

Summary

This job involves creating interactive dashboards and visual reports for government data systems, optimizing data flows to make information easy to access, and working closely with teams to ensure everything runs smoothly and accurately.

It's ideal for someone with a background in data analysis and design who enjoys turning complex information into user-friendly tools.

Good fits include tech-savvy professionals who can handle both creative design and technical data work in a team setting.

Key Requirements

  • Bachelor's degree from an accredited four-year college or university, or equivalent substitutions like an associate degree plus two years of relevant experience, four years of experience alone, or a certification program
  • Two years of full-time paid experience in report design using specialized SQL reporting tools
  • Proficiency in building and deploying dashboards with tools like DAX or LOD expressions, interactive filters, and UI components
  • Skills in data engineering, including designing data structures, optimizing pipelines, and documenting data lineage
  • Experience in stakeholder engagement, such as leading meetings, creating wireframes in Figma, and conducting training sessions
  • Ability to perform quality assurance through testing, resolving data discrepancies, and developing standard operating procedures

Full Job Description


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.

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.

Check your resume before applying to catch common mistakes

Browse Similar Jobs

Posted on NEOGOV: 2/24/2026 | Added to FreshGovJobs: 2/25/2026

Source: NEOGOV | ID: neogov-wv-5243896