Business Intelligence Specialist - Sacramento, CA

The Position 

To develop overall implementation strategy and approach that is aligned to Enterprise Data Management Strategy, Enterprise Information Reference Architecture and Strategy and Enterprise Data warehouse, Analytics and Reporting Strategy. 

Responsibilities 

Lead/perform designing, developing, and implementing data models for BI reporting systems. These data models must be architected: conceptual, logical, and BI reporting systems. The specialist will act as the primary advocate of data modeling methodologies and best practices for delivering business value to the Program by architecting effective BI data mart solutions that address the Program’s business problems, needs and opportunities. 

Evaluate current system and determine the reporting needs of the current users and consolidate existing reports and identify any obsolete reports. 

Lead for gathering requirements, designing, and rolling out BI solutions to end users. The specialist is also responsible for ensuring high levels of BI availability and scalability through support functions and implementation and support Microsoft BI software and reporting systems, including integration with databases and data marts, and report writing. 

Review existing practices and define/develop the Custom application development and deployment processes (Dev - > Test - > Staging - > Production). Set standards and practices for Distributed Application development for new applications. Review existing standards and amend the standards and procedures wherever applicable. 

Interview/meet current business users to inventory their current and future reporting requirements, examining, evaluating and proactively make strategic and tactical recommendations for improvement, and provide procedures to convert the 500+ select reports on a timely basis and complete with recommended improvements to business processes, operational procedures, and corresponding BI reporting environments (including JAD sessions). 

Promote best practices for tool use and develop and document processes and procedures, technical documentation and operations manuals for ongoing support. 

Lead in data design walk-throughs to communicate data warehouse and Data Mart table designs to ETL and report developers. 

Perform Data Modeling. 

Define best practices and standards for the data modeling process. 

Identify critical integration issues and develop corrective solutions. 

Define Datamart and ETL architecture 

Establish ETL requirements for data load from the Department’s data warehouse. 

Perform performance and capacity planning. 

Perform Performance Tuning of Datamarts, ETL Processes and Reports 

Implement ETL process. 

Develop ETL test cases and test data and perform ETL testing 

Document Reports requirements. 

Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports. 

Develop reports. 

Develop Test Cases for Reports Testing. 

Perform Reports Testing. 

Define Test Strategy and Test Plan. 

Deliver End User Training. 

Develop a health checklist, performance KPIs, Dashboards and change management procedures, including project documentation and test scripts. 

Establish and implement standards and strategies for data management, lifecycle, and data quality. 

Continuously improve upon existing approaches by seeking opportunity to creatively transform current business practices into alternative solutions. 

Create data mapping between reports data elements and Department’s data warehouse data elements and other existing data sources. 

Contribute to the quality of the project by partnering with staff and other project team members to deliver a solution that is consistent with quality assurance best practices and aligns with the requirements for the project. 

Work collaboratively with the testing teams to maintain product and solution quality by adhering to and improving quality frameworks, methods and practices. 

Prepare, review and execute test cases and test scripts aligned to functional and non-functional requirements. 

Contribute to the functional and non-functional project schedules and associated testing effort project schedules. 

Identify defects associated with the execution of test cases and test scripts. 

Support the effort to integrate project test tools with enterprise test tools. 

Work with stakeholders, other contract staff, and/or and IT staff in support of all integration activities. 

Communicate with State IT staff, management, other contract staff (at all levels), both written and orally. 

Complete knowledge transfer to State IT staff. Develop MS BI training material to train the trainers, state staff, and Programs’ Power Users

Apply Now