Data Visualization Consultant

Overview
This role sits within the Compliance organization and is focused on building, stabilizing, and scaling internal data visualization capabilities. The consultant will take ownership of transforming manual, Excel-based reporting into structured, repeatable dashboards while also upskilling internal team members.

This is not a traditional BI ?ticket-taker? role. The ideal candidate will operate in ambiguity, build lightweight data structures, and teach non-technical stakeholders how to work with data and visualization tools.

Key Responsibilities

Take raw data exports (primarily Excel) and design structured, repeatable datasets for reporting and trending
Build and enhance dashboards in Tableau or Power BI (Tableau preferred)
Establish lightweight data pipelines (manual ? semi-automated) to enable week-over-week trending and historical tracking
Partner with business users to translate loosely defined needs into actionable dashboards and insights
Upskill team members through hands-on training, pairing, and knowledge transfer
Document data structures, workflows, and visualization best practices to enable long-term self-sufficiency
Improve data quality by identifying gaps, inconsistencies, and governance opportunities
Introduce best practices around data management, organization, and visualization design
Deliver MVP-level dashboards quickly, then iterate and enhance over time
Serve as a thought partner on how to scale reporting capabilities across the broader compliance organization
What Success Looks Like (First 5?6 Weeks)

Core datasets established and organized in a repeatable structure
Initial dashboards built and actively used by the team
One primary team member fully ramped and capable of continuing development
Documentation in place for ongoing usage and maintenance
Foundation laid for broader compliance reporting expansion
Required Experience

3+ years in data visualization / BI / analytics roles
Hands-on experience building dashboards in Tableau or Power BI
Strong experience working with messy or unstructured data (Excel-heavy environments)
Experience creating datasets, not just consuming them
Proficiency with SQL and/or data manipulation techniques
Experience building reports from scratch (data ? structure ? visualization)
Strong communication skills with ability to work directly with business stakeholders
Core Competencies

Ability to operate in ambiguity with minimal requirements
Strong teaching and mentoring mindset
Product-oriented thinking (MVP ? iterate ? scale)
Pragmatic approach (avoids over-engineering)
Strong data storytelling ability
Growth mindset and flexibility in approach
Nice to Have

Experience in healthcare, PBM, or regulated environments
Experience building lightweight data marts or shared data environments
Exposure to governance and data quality frameworks
Experience working in consulting or advisory-style roles


Benefits:

York Solutions Offers a generous benefits package for eligible full-time employees:

• BCBS Medical with 3 Plans to choose from (PPO and High deductible PPO plans with Health Savings Program)
  
• Delta Dental plan with 2 free cleanings and insurance discounts
  
• Eye Med Vision with annual check-ups and discounts on lens
  
• Life and Accidental Death Insurance paid by company
  
• John Hancock 401(k) Retirement Plan with discretionary company match
  
• Voluntary Insurance programs such as: Hospital Indemnity, Identity Protection, Legal Insurance, Long Term Care, and Pet Insurance.
  
• Flexible work environment with some remote working opportunities
  
• Strong fun and teamwork environment
  
• Learning, development, and career growth