Position: Senior Programmer Analyst (Cognos, Power BI)
Location: Richmond, VA 23219 (Hybrid Schedule (1 week at office, 1 week remote
Duration: 12+ Months Contract
Job Description:
- Senior Programmer Analyst
- 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
What are the top (at least 3 if possible) "must have" skill sets (technical/functional) which are required?
- Communication Skills
- Cognos Reporting and Transformer Cube
- Power BI Dashboarding
Pay Range: $60 - $62 Hourly
The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.