Senior BI Analyst – IBM Cognos & Power BI

Vinsys Information Technology Inc; California; On-site; USD 95,000 - 140,000; Full time

Job summary

Vinsys Information Technology Inc. is seeking a Senior BI Analyst to lead reporting analysis and migration from Cognos to Power BI. The role combines hands-on report development with requirements analysis, SQL validation, QA, troubleshooting, and user enablement.

You will convert existing Cognos reports into intuitive Power BI dashboards while maintaining business logic and data accuracy. The position emphasizes collaboration with stakeholders, data quality, and delivering scalable BI solutions

Qualifications

• Experience migrating Cognos reports to Power BI.
• Strong SQL validation and data accuracy focus.
• Ability to analyze requirements and translate into dashboards.

Responsibilities

• Analyze Cognos audit logs and Framework Manager models to assess migration complexity.
• Conduct stakeholder interviews and document current gaps and future requirements.
• Develop report inventories, complexity assessments, and traceability docs.
• Consolidate reports and create reusable reporting templates.
• Extract Cognos SQL logic and recreate reports as needed.
• Develop and optimize Power BI reports and dashboards.
• Lead reconciliation against legacy reports and support UAT.
• Troubleshoot Cognos and Power BI issues and assist with upgrades.
• Prepare technical documentation and deliver user training.

Skills

IBM Cognos

Power BI

SQL Server

Job description

Mandatory Background Security And CJIS/CLETS Requirements

Candidates must be able to successfully complete required background security screening, including applicable state and federal fingerprint-based criminal history checks, and satisfy all applicable CJIS/CLETS requirements before accessing ARJIS SANDAG systems or data. Continued eligibility requires annual security reviews and applicable training or certification renewals. Existing clearance is not required to apply.

Seeking a Senior BI Analyst with strong IBM Cognos, Microsoft Power BI, and SQL Server experience to lead reporting analysis and complex report migration activities. The role combines hands-on report development with requirements analysis, SQL validation, quality assurance, troubleshooting, and user enablement.

The Senior Analyst will help convert the existing Cognos reporting environment into intuitive Power BI reports and dashboards while maintaining business logic, data accuracy, and reporting performance.

Responsibilities

• Analyze Cognos audit logs, report specifications, Content Store information, and Framework Manager models to assess usage and migration complexity.
• Conduct stakeholder interviews, analyze user surveys, and document current reporting gaps and future requirements.
• Develop report inventories, complexity assessments, prioritization matrices, and requirements traceability documentation.
• Consolidate similar reports and develop reusable reporting templates.
• Extract and validate Cognos SQL logic and recreate reports where existing formatting cannot transfer.
• Develop and optimize Power BI reports, dashboards, and supporting SQL views.
• Lead reconciliation against legacy reports and source data, investigate discrepancies, and support user acceptance testing.
• Troubleshoot Cognos and Power BI reporting issues, engage IBM Support, and assist with Cognos version upgrades and validation.
• Prepare technical documentation and deliver virtual training and knowledge transfer to users and ARJIS staff.