Job description

Job Title: Data Visualization & Dashboard Developer Location: Hybrid – Sacramento, CA Duration: 12 Months Contract Type: Deliverables-Based Contract Project Overview: We are seeking an experienced Data Visualization & Dashboard Developer to support a 12-month initiative focused on business intelligence modernization, reporting automation, and dashboard development using Power BI. This is a deliverables-based contract—not hourly—requiring self-motivation, clear communication, and commitment to timely completion of work products. The role supports ongoing analytics efforts across business areas including Pension, Health Insurance, Customer Service, Finance, and Risk. Responsibilities: Deliverable 1: Dashboard & Semantic Layer Development • Design and develop interactive dashboards and reports using Power BI • Interpret business requirements and translate them into actionable data visuals • Build and maintain the BI semantic layer, translating complex data structures into user-friendly formats • Visualize business metrics, trends, and patterns using charts, tables, maps, and more • Modernize the BI platform with automation and data integration best practices Deliverable 2: Maintenance & Functional Administration • Maintain and enhance existing BI report inventory • Troubleshoot performance and system issues • Coordinate server maintenance and report promotion across environments • Administer user access, roles, and reporting environments (production/non-production) • Update documentation for ongoing report changes Deliverable 3: Knowledge Transfer • Ensure all work is documented and shared regularly with internal staff • Participate in scheduled knowledge transfer sessions • Maintain clear project records, meeting notes, and solution documents in shared repositories Required Skills & Experience: • 5+ years experience in Power BI development (DAX, Power Query, Dataflows, Semantic Layer) • 4+ years functional admin experience with Power BI (access, promotion, documentation) • 3+ years in BI metadata modeling (conformed dimensions, hierarchies, data dictionaries) • Advanced SQL skills for data querying and transformation • Experience working in pension, healthcare, customer service, finance, or risk domains • Strong data modeling and ETL background • Experience working in Agile environments • Excellent UI/UX design skills for dashboards • Strong documentation, communication, and presentation skills Nice-to-Have: • Familiarity with DevOps pipelines, Git, or Azure DevOps • Prior experience working with state government or public pension systems Evaluation Criteria: QualificationPoints 2+ successful BI projects (1 over $1M) 10 5+ years of Power BI/report development 20 4+ years Power BI admin experience 20 3+ years metadata modeling 10 3+ years domain experience (Pension, etc.) 10 Important Notes: • All work must be completed on schedule and approved to trigger payment. • Developer is responsible for managing deliverables, deadlines, and documentation. • Strong communication and independent project execution are essential.

Requirements