Enterprise Data Reporting Specialist

Company: Zetanium Global LLC
Location: Sacramento
Posted on: May 22, 2025

Job Description:

Job Title: Enterprise Data Reporting Specialist

Considering applying for this job Do not delay, scroll down and make your application as soon as possible to avoid missing out.
Location: Sacramento, CA (Hybrid)


Key Responsibilities:
Deliverable 1 - Report & Dashboard Development:
Collaborate with stakeholders to gather requirements and perform business analysis.

Develop report specification documents and write complex SQL/PL-SQL queries.

Design and deliver reports and dashboards using IBM Cognos and Power BI.

Integrate external systems with Cognos using the Cognos SDK for automated report execution.

Conduct unit testing, user acceptance testing, and package all deliverables in compliance with internal standards.

Maintain technical documentation and ensure compliance with data security protocols.


Deliverable 2 - Reporting Systems Support & Administration:
Provide functional administration for Cognos and Power BI platforms across production and non-production environments.

Perform performance tuning of reports and dashboards, and maintain existing reporting packages and architecture.

Create new Framework Manager packages and manage metadata layers as needed.

Extract data from CalPERS databases and data warehouses, ensuring efficient and secure delivery.

Enhance system maintainability and recommend architectural improvements.


Deliverable 3 - Knowledge Transfer:
Maintain and deliver clear documentation, including status reports, incident triage logs, meeting notes, test plans, and results.

Ensure ongoing knowledge sharing with CalPERS staff throughout the contract duration.



Key Responsibilities:
Design, develop, and maintain reports and dashboards using IBM Cognos Analytics and Microsoft Power BI

Write complex SQL/PL-SQL queries to support reporting needs

Perform functional administration and maintenance of Cognos and Power BI platforms

Optimize report and dashboard performance, ensuring data security compliance

Apply report meta modeling techniques including conformed dimensions and data security rules

Collaborate with CalPERS teams for effective knowledge transfer and documentation

Preferred domain experience in pension, health insurance, finance, or risk

Keywords: Zetanium Global LLC, North Highlands , Enterprise Data Reporting Specialist, Advertising , Sacramento, California