Local to Sacramento, CA Candidates only.
Position: Data Visualization & Dashboard Developer (Only W2 Position, No C2C)
Location: Sacramento, CA 95811
Duration: 6+ Months
Project Scope/Tasks:
The Enterprise Analytics and Data Services team requires (1) a consultant proficient in the design and development of Power BI development, Power Automate, Power Apps, Semantic Layer, Data Visualization and Data Integration data. This consultant must have advanced experience interpreting business data requirements and developing complex SQL queries, Power BI, Power BI Visualization, and have experience in Pension, Health Insurance, Customer Service, Finance, and/or Risk.
This should include a strong understanding and experience with information technology, business intelligence development, change management best practices, project management, and system development lifecycle fundamentals.
The consultant will develop logical dimensional models, business layer transformation solutions and provide expert in Power BI data visualization.
These services include software changes and environment maintenance and operations. Key solutions to be supported are (a) Pension self-service, (b) report to Power BI Migration, (c) Automate ACFR reports, (d) HAMD Open enrollment Dashboard, and (e) production Business Intelligence Dashboard solutions.
Deliverable 1: Design and development of Business Intelligence reports, dashboards and BI sematic layer.
- Design and development of Business Intelligence reports and dashboards. The report and dashboard requests are received from the department business areas. Fulfillment includes requirement interpretation, working with the business requester to confirm requirements, design and development of the report or dashboards, testing and deployment of the report or dashboard to department business users.
- 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 department 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.
Deliverable 2: 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 department 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 department 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 Required:
- 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 and Health Insurance
Never miss an opportunity! Create an alert based on the job you applied for.
