Business Intelligence / Reporting Specialist (ID#5587)

Job summary

Design, develop, test, and maintain enterprise reporting solutions, dashboards, data models, and analytical tools using platforms such as Power BI, Cognos, and SSRS. Integrate and validate data from multiple systems, optimize reporting performance, collaborate with technical and business stakeholders, and support platform modernization and documentation.

Job details

New Value Solutions is recruiting experienced Senior Business Intelligence and Reporting Specialists to support Government of Canada IT consulting engagements focused on enterprise reporting, business intelligence, data analytics, information management, and digital transformation. We are seeking accomplished BI and Reporting Specialists with demonstrated experience designing, developing, implementing, and maintaining enterprise reporting solutions, dashboards, data visualizations, and analytical tools within large, complex technology environments. Responsibilities: Design, develop, test, and maintain enterprise business intelligence solutions, operational reports, analytical dashboards, and data visualization products. Develop and enhance reporting solutions using technologies such as Microsoft Power BI, SQL Server Reporting Services (SSRS), IBM Cognos Analytics, or comparable enterprise BI platforms. Analyze business requirements, reporting needs, and data sources to develop reporting specifications and analytical solutions. Develop complex SQL queries, stored procedures, views, and data extraction routines to support reporting and analytics requirements. Design and implement data models, datasets, calculations, measures, and reporting structures to support accurate and efficient analysis. Develop interactive dashboards, key performance indicators (KPIs), scorecards, and management reports to support operational and strategic decision-making. Integrate information from multiple enterprise systems, databases, and data sources into consistent reporting solutions. Support data extraction, transformation, validation, and preparation activities for business intelligence and reporting environments. Collaborate with business analysts, data architects, database administrators, application developers, and business stakeholders to deliver reporting solutions. Optimize report performance, data queries, refresh processes, and analytical models. Conduct report testing, data reconciliation, quality assurance, and troubleshooting to ensure the accuracy and reliability of reporting outputs. Support reporting platform upgrades, migration initiatives, modernization activities, and the transition from legacy reporting technologies. Prepare technical specifications, report documentation, data definitions, user guides, and knowledge transfer materials. Requirements: Extensive professional experience in business intelligence development, enterprise reporting, or data analytics within large IT environments. Strong hands-on experience developing reports, dashboards, and analytical solutions using enterprise BI platforms such as Microsoft Power BI, IBM Cognos Analytics, SSRS, or comparable technologies. Demonstrated experience translating business and reporting requirements into technical specifications, data models, and reporting solutions. Advanced SQL skills, including complex queries, joins, aggregations, views, and stored procedures. Experience working with relational databases such as Microsoft SQL Server, Oracle, PostgreSQL, or comparable platforms. Strong understanding of data modelling, reporting datasets, data relationships, and data transformation principles. Experience developing KPIs, performance dashboards, operational reports, and management reporting solutions. Knowledge of data quality, validation, reconciliation, and reporting accuracy requirements. Experience integrating and analyzing data from multiple enterprise applications and information systems. Experience optimizing reporting queries, data models, and dashboard performance. Knowledge of software development lifecycle practices, testing, documentation, and change management. Strong analytical, problem-solving, communication, stakeholder engagement, and technical documentation skills. Relevant post-secondary education in Computer Science, Information Technology, Business Intelligence, Data Analytics, or a related discipline, or an equivalent combination of education and experience. Preferred Qualifications: Previous experience providing business intelligence or reporting services to Government of Canada departments or agencies. Experience supporting large-scale public sector enterprise reporting, performance measurement, analytics, or digital transformation initiatives. Advanced Microsoft Power BI experience, including Power Query, DAX, semantic models, and Power BI Service. Experience with IBM Cognos Analytics, including report development, data modules, Framework Manager, or enterprise reporting administration. Experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), or comparable data integration and analytical technologies. Experience developing reporting solutions using Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, or Azure Databricks. Experience with dimensional data modelling, star schemas, data warehouses, and enterprise reporting architectures. Experience migrating reports and dashboards from legacy BI platforms to modern reporting technologies. Experience implementing reporting security, role-based access controls, data governance, and information protection requirements. Experience with Python, R, or other scripting and analytical technologies. Relevant certifications in Microsoft Power BI, Microsoft Fabric, IBM Cognos, or comparable business intelligence technologies. Experience working within formal government information management, documentation, security, and change management frameworks. Existing Government of Canada Reliability Status or Secret security clearance. About New Value Solutions New Value Solutions is a Canadian IT consulting and professional services firm with extensive experience supporting public sector organizations across Canada. We specialize in connecting experienced technology and business professionals with consulting engagements involving enterprise systems, digital transformation, cybersecurity, and IT modernization. Engagements are available across Canada, with remote, hybrid, and onsite arrangements, start dates, and assignment details determined by individual client requirements as contracts are secured. If you have the necessary expertise and are legally authorized to work in Canada, please submit your resume. We thank all applicants for their interest; however, only those shortlisted will be contacted. ID # 5587

What you’ll do

Design, develop, test, and maintain enterprise reporting solutions, dashboards, data models, and analytical tools using platforms such as Power BI, Cognos, and SSRS. Integrate and validate data from multiple systems, optimize reporting performance, collaborate with technical and business stakeholders, and support platform modernization and documentation.

Requirements

Requires extensive experience delivering business intelligence, enterprise reporting, or analytics in large IT environments, along with advanced SQL skills and hands-on experience with enterprise BI platforms and relational databases. Candidates should be skilled in data modeling, requirements analysis, data quality, performance optimization, testing, documentation, and stakeholder communication; relevant post-secondary education or equivalent experience is required.

Listed skills

• Data visualization · Preferred
• Technical Documentation · Preferred
• SQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Business Intelligence
• Enterprise Reporting
• Microsoft Power BI
• SQL
• Data Modeling
• Dashboard Development
• Data Analytics
• IBM Cognos Analytics
• SQL Server Reporting Services
• Data Quality Assurance
• Data Integration
• Performance Optimization
• Stakeholder Engagement
• Technical Documentation
• Data Visualization
• Requirements Analysis

Job areas

• Data & Analytics
• Technology
• Software
• Government & Public Sector
• Consulting

More jobs from New Value Solutions