What are the responsibilities and job description for the Programmer Analyst/Data Analyst position at Careers Integrated Resources Inc?
Job Title: Programmer Analyst/Data Analyst
Location: Richmond, VA - Hybrid
Duration: 12 Months
Job Description:
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
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
