Job Details

Client is seeking consulting services to assist with completing a priority project to migrate IBM Cognos reports to Microsoft Power BI, along with additional Power BI dashboard development work within the Enterprise Data Management and Analytics (EDMA) team.

Below are the core areas the consultant will work on:

The first priority is to migrate all production Cognos reports to Power BI. The Cognos reports are used to support data collections managed by the EDMA team and self-service reports supporting the organization. The consultant will be responsible for migrating Cognos reports by developing equivalent or enhanced Power BI dashboards.

All development work will follow established EDMA development practices and frameworks, organizational data governance policies, and meet ADA Title II compliance requirements.

Local candidates strongly preferred, but 100% remote is acceptable.

Responsibilities

• The consultant will be responsible for additional Power BI dashboard and report development and maintenance as assigned.
• The consultant will provide production support for dashboards and reports including, but not limited to, data analysis, testing, issue resolution, and enhancements.
• The consultant will be responsible for creating consolidated Power BI usage reports and related metrics to support departmental and organizational needs.
• The consultant will work with internal and external customers, business analysts, and team leads to analyze and evaluate user business problems, confirm and substantiate functional, technical, and ADA Title II accessibility designs in Power BI, provide recommendations, and develop solutions to meet requirements.
• The consultant will be involved in Power BI workspace architecture, security architecture, as well as versioning and documentation processes.

• Expert problem-solving skills, including debugging skills, identifying sources of issues in unfamiliar code or systems, and the ability to recognize and solve recurring problems and errors.
• Advanced experience working with Oracle DBMS, PL/SQL, and SQL.
• Extensive experience with Microsoft Power BI, including designing and building lists, crosstabs, graphs, scorecards, metrics, filters, prompts, standard reports, and dashboards.
• Experience with IBM Cognos.
• Experience working with Microsoft Fabric.
• Knowledge of current and emerging data management and analytics technologies.
• Ability to handle multiple tasks, balance priorities, and meet competing deadlines.
• Excellent oral and written communication skills, including the ability to explain technology solutions in business terms, establish team and customer rapport, and work collaboratively with others to achieve project objectives.
• Knowledge of higher education data with experience in student information systems preferred.