Senior Cognos/Power BI Developer (Ref: 5874)

Estrada Consulting, Inc; San Diego (CA); Hybrid; USD 83,000 - 152,000; Part time

Job summary

Estrada Consulting, Inc. seeks a Senior IBM Cognos / Power BI Developer to migrate ~1,500 Cognos reports to Power BI and support a transition from on-prem SQL to Azure cloud services.

The role requires Cognos Analytics and Framework Manager expertise, advanced Power BI, and strong SQL Server/T-SQL skills, with Python for data processing and documentation duties.

Qualifications

• Experience with IBM Cognos Analytics and Framework Manager is required.
• Advanced Power BI experience including Desktop, Report Server, and Service.
• Strong SQL Server and T-SQL development skills.
• Experience migrating reports from Cognos to Power BI.
• Experience with SQL views, data models, and dashboards.
• Experience with Azure cloud data services or cloud BI migrations.
• Python development for data processing and automation.
• Excellent documentation and communication skills including technical writing.
• Ability to complete background checks, fingerprinting, and CJIS/CLETS security requirements.

Responsibilities

• Analyze, inventory, and migrate Cognos reports to Power BI Report Server.
• Extract and validate SQL queries and reporting logic.
• Develop Power BI reports, dashboards, and data models.
• Support Cognos Framework Manager models and troubleshoot issues.
• Assist with migration to Azure cloud services.
• Perform data validation, reconciliation, and performance tuning.
• Develop Python processes to support data activities.
• Collaborate with analysts, developers, and stakeholders to gather requirements.
• Prepare documentation and knowledge transfer materials.

Skills

BI analysis

Problem solving

Technical communication

Background checks clearance

Tools

IBM Cognos Analytics

Framework Manager

Power BI

SQL Server

T-SQL

Azure SQL / cloud BI

Python

Job description

Senior IBM Cognos / Power BI Developer (Ref: 5874)

Location: California / Remote or Hybrid TBD
Employment Type: Contract
Project Duration: Long-term, anticipated 12 months

Position Overview

Estrada Consulting, Inc. is seeking an experienced Senior IBM Cognos / Power BI Developer to support a large-scale business intelligence modernization initiative for a public-sector client. The consultant will support the existing IBM Cognos reporting environment while migrating approximately 1,500 reports to Microsoft Power BI and supporting a future transition from on-premises SQL Server reporting to Azure cloud services.

Key Responsibilities

• Analyze, inventory, and migrate IBM Cognos reports to Microsoft Power BI Report Server.
• Extract, validate, and convert existing SQL queries and reporting logic.
• Develop Power BI reports, dashboards, SQL views, and optimized data models.
• Support IBM Cognos Framework Manager models and troubleshoot reporting issues.
• Assist with migration of on-premises reporting and SQL data models to Microsoft Azure.
• Perform data validation, report reconciliation, performance tuning, and quality assurance.
• Develop Python-based processes to support data processing and reporting activities.
• Collaborate with business analysts, developers, and stakeholders to gather reporting requirements.
• Prepare technical documentation, data dictionaries, entity relationship diagrams, and knowledge transfer materials.

Required Qualifications

• Strong hands-on experience with IBM Cognos Analytics and Framework Manager.
• Advanced Microsoft Power BI experience, including Power BI Desktop, Report Server, and Power BI Service.
• Strong Microsoft SQL Server and T-SQL development skills.
• Demonstrated experience migrating reports from IBM Cognos to Power BI.
• Experience developing SQL views, complex queries, reporting data models, and dashboards.
• Experience with Azure SQL databases, Azure data warehousing, or cloud-based BI migrations.
• Python development experience for data processing and automation.
• Strong troubleshooting, testing, data reconciliation, and performance optimization skills.
• Excellent technical documentation and communication skills.
• Ability to successfully complete required background checks, fingerprinting, and applicable CJIS/CLETS security requirements.

Preferred Qualifications

• Experience supporting public-sector or law enforcement reporting systems.
• Experience with large-scale BI report migration and modernization projects.
• Familiarity with criminal justice data reporting environments.
• Experience working with IBM technical support.
• Experience mentoring technical staff and providing knowledge transfer.