Programmer Analyst/Data Analyst

Job Title: Programmer Analyst/Data Analyst
Location: Richmond, VA - Hybrid
Duration: 12 Months+
 
Job Description:

• Cognos 11 reporting, Cognos Transformer Cube, Power BI, and advanced SQL writing abilities.
• The Cognos to Power BI Report Conversion Specialist will be responsible for migrating reports from IBM Cognos to Microsoft Power BI. This role involves understanding the existing Cognos
• reports, converting them to Power BI, and ensuring that the new reports meet the business requirements and performance standards.

 
Report Conversion:
• Convert existing Cognos reports to Power BI, ensuring that the new reports match the look, feel, and functionality of the original reports
• Implement data-level security mechanisms in Power BI reports, if defined in the Cognos reports

Data Integration:
• Ensure seamless integration with existing data sources, including databases and data warehouses
• Enable real-time data access and updates in Power BI, similar to the current Cognos setup

Performance and Scalability:
• Optimize Power BI reports and dashboards for performance, with fast load times and responsiveness
• Design the Power BI environment to be scalable, accommodating future growth and increased data volumes

User Access and Permissions:
• Implement role-based access controls in Power BI, mirroring the current user permissions in Cognos
• Ensure secure user authentication and authorization mechanisms are in place

Testing and Validation:
• Conduct thorough testing of all migrated reports, cubes, and models to ensure accuracy and performance
Facilitate user acceptance testing (UAT) to validate that the migrated reports meet business requirements

Documentation and Training:
• Provide user manuals, technical guides, and troubleshooting documentation
• Conduct training sessions for the team on the new Power BI reports and functionalities

Skills:
1. Communication Skills
2. Cognos Reporting and Transformer Cube
3. Power BI Dashboarding