DataWarehouse Analyst

Job Summary

The Data Warehouse Reporting Analyst Sr. collaborates with the Information Technology Services (ITS) and Data Warehouse (DW) teams to develop and support organization-wide reporting. The incumbent participates in gathering and documenting report requirements and is responsible for designing, building and administering reporting solutions for requesting departments. Assistance will be provided to departmental Business/Data Analysts in developing reports using the available Business Intelligence (BI) tools. The incumbent will develop ad-hoc reports for business users as applicable and participates in the design and development of the reporting infrastructure using Structured Query Language (SQL) Server technologies and BI reporting tools. The incumbent is responsible for administering report security and deployment within CalOptima Health ITS and data security policies as well as future environment upgrades

Position Responsibilities

Participates in a mission-driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability

Assists the team in carrying out department responsibilities and collaborates with others to support short- and long-term goals/priorities for the department

Leads the development of business and functional requirements for reports

Designs, develops, tests and implements reports/dashboards and Extraction, Transformation and Loading (ETL) to fulfill business requirements as needed

Serves as a subject matter expert across the organization and assists users with reporting (including ad-hoc reporting) and analysis activities and tools

Supports user training, testing, documentation and the roll-out of reports and end-user reporting tools

Maintains effective working relationships with the DW Team, other Information Services teams and the other business departments within CalOptima Health

Maintains knowledge of business processes and application design and understand cross-functional business relationships and their use of information

Completes other projects and duties as assigned