Data Visualization & Dashboard Developer

Title: Data Visualization & Dashboard Developer - (Only w2 candidates- local only)

Job Id: 2025-0953

Client: CalPERS

Duration: 6+ months

Location: Sacramento, CA 95811 Onsite

Description:

Design and development of Business Intelligence reports and dashboards. The report and dashboard requests are received from the client's business areas.

• Design and development of the BI semantic layer. The semantic layer is a complex component of each BI environment that translates:
• Complex database table structures
• relationships between database tables
• data types (example: numbers, characters)
• grains (example: monthly, weekly, and daily data records)
• centralized business calculations (example: real time pension account balance calculation) and data records into business-oriented data fields with business-friendly labels that are used to create reports, dashboards and analyses without the need for users to learn computer. programming languages or the need to understand complex database tables.
• Modernization of the BI data platform with integrated automation, along with providing the necessary data and technology support to enable client's to achieve its BI related business objectives. Data visualization of business metrics, patterns, trends, transactions in the form of charts, graphs, maps, tables and other forms to effectively tell data stories and provide information to business users in intuitive and clear formats.

Maintenance, Operations Support and Functional administration of Business Intelligence Reporting systems.

• Maintenance of the existing data reporting inventory and Provide data and technology support necessary to enable client's to meet BI related business objectives. Ensure the continued upkeep and enhancement of the existing data reporting inventory, including regular updates, troubleshooting, and performance optimization to maintain seamless functionality and reliability.
• Update design and technical specification documents for on-going report modifications. Research, analyze, design, and implement appropriate reporting solutions for business; enhance and maintain my client's and Business Intelligence (BI) Production Reporting systems. Functional administration of the BI dashboarding environments (accounts, roles, server maintenance coordination, promotion of code from one environment to another, etc.) in production and non-production servers.

Skills:

• Individuals must have participated in at least two (2) successful Business Intelligence and/or Analytics projects, one of which with a budget of at least $1 million
• At least five (5) years of experience in developing reports, diagnosing and resolving issues with BI & Analytics tools such as Microsoft Power BI
• At least four (4) years of experience performing tasks pertaining to Microsoft Power BI functional Administration including promotion of changes, access provision, and documentation of procedures and best practices
• At least three (3) years of experience in report meta modeling, including logically grouping business element functions in the form of conformed dimensions and hierarchies, measures, data security rules, and user-friendly attributes and data dictionary definitions
• At least three (3) years of experience in some or all areas of Pension, Health Insurance, Customer Service, or Finance.