IT Reporting & Analytics Consultant-L2 (6 month contract)
Location: Vancouver, BC / Hybrid - Remote
Staffing Placement Opportunity
General Description
The IT Reporting and Analytics Consultant Level 2 is responsible for the integration, design, development and implementation of reporting and analytics solutions to support business operations and organizational objectives. The role focuses on translating business requirements into sustainable technical solutions, developing reporting capabilities, analyzing data and providing insights to support financial and operational decision-making, including cloud and AI cost management.
Experience And Role Accountabilities
- A minimum of five (5) years of consulting experience in reporting and analytics, business intelligence or a related field, or an equivalent combination of relevant experience and training.
- Lead or contribute to the integration, design and implementation of reporting and analytics solutions by gathering business requirements, evaluating technical options and recommending appropriate solutions.
- Review functional specifications and present proposed technical designs to development leads and stakeholders, ensuring alignment with business requirements and technical standards.
- Design, develop and maintain sustainable reporting solutions in accordance with approved architectural direction and technical design standards.
- Develop dashboards, analytical reports and data models to support financial analysis, operational reporting and business decision-making.
- Perform ongoing maintenance and operational support of reporting solutions, ensuring accuracy, reliability and timely delivery.
- Collaborate with business, functional and technical teams to validate information requirements, translate business needs into conceptual data models and troubleshoot development issues.
- Analyze financial, operational, cloud consumption and AI usage data to identify trends, cost drivers, anomalies and opportunities for optimization.
- Support cloud and AI cost management reporting, including cost allocation, consumption analysis, forecasting, showback and chargeback models.
- Monitor solution development activities and provide regular progress updates, identifying risks, issues and dependencies to ensure alignment with project timelines and standards.
- Document technical solutions, reporting processes and operational procedures through process flows, user guides, job aids and standard operating procedures.
- Apply data quality, performance optimization and change management practices to ensure the accuracy, efficiency and sustainability of reporting solutions.
Required Qualifications And Skills
- Bachelor's degree or technical diploma in Computer Science, Engineering, Information Technology or a related discipline, or equivalent practical experience.
- Minimum five (5) years of experience in reporting and analytics, business intelligence or data consulting.
- Proficiency in Microsoft Excel and Power BI, including dashboard development, data analysis and reporting.
- Strong analytical, financial modelling and problem-solving skills.
- Knowledge of Microsoft Azure cloud services and cloud consumption models.
- Understanding of generative AI services, AI consumption metrics and emerging token-based pricing concepts.
- Experience working with data models, dashboards, analytical reporting and business intelligence solutions.
- Knowledge of data architecture, data integration and information management principles.
- Understanding of change management procedures and technical documentation standards.
- Strong communication and presentation skills, with the ability to explain technical concepts and analytical findings to business and technical stakeholders.
- Self-motivated with strong attention to detail, data quality and accuracy.
Preferred Qualifications
- FinOps Certified Practitioner or another recognized FinOps certification.
- Experience with Azure Cost Management, Microsoft Cost Management exports or the FinOps Open Cost and Usage Specification (FOCUS).
- Experience analyzing AI consumption and cost data from services such as Azure OpenAI, Azure AI Foundry, Microsoft Copilot, Copilot Studio or GitHub Copilot.
- Experience designing and implementing cloud or AI cost allocation, showback and chargeback models.
- Experience with cloud financial management, cost optimization, forecasting and financial reporting.
- Experience developing performance-optimized reporting solutions and integrated analytics dashboards.
Key Technical Requirements
Must Have
- Microsoft Excel and Power BI proficiency.
- Strong analytical, financial modelling and problem-solving capabilities.
- Knowledge of Microsoft Azure cloud services.
- Understanding of generative AI services and token-based pricing concepts.
- Strong attention to data quality, accuracy and detail.
- Ability to independently develop and maintain reporting and analytics solutions.
Nice to Have
- FinOps Certified Practitioner or equivalent certification.
- Azure Cost Management and Microsoft Cost Management exports.
- Familiarity with the FinOps Open Cost and Usage Specification (FOCUS).
- Experience with Azure OpenAI, Azure AI Foundry, Microsoft Copilot, Copilot Studio or GitHub Copilot consumption and cost reporting.
- Experience developing cloud and AI cost allocation, showback and chargeback models.
Note: this is an opportunity with a Microserve client.