Business Intelligence Consultant

Job Summary: The contractor will be responsible for the ongoing maintenance and enhancement of sustainability technology solutions, including Microsoft Fabric, Microsoft Sustainability Manager (MSM), and Environmental Resilience Analytics (ERA). This role will support the seamless operation of ESG reporting tools, data pipelines, and dashboards, while also supporting compliance, data governance, and infrastructure optimization. Key Responsibilities • Application Management • Own and resolve data and metric calculation issues across MSM and ERA. • Maintain dashboards and reports for internal and external stakeholders. • Manage system interfaces and integrations, both upstream and downstream. • Support compliance with sustainability regulations and standards. • Support data analysis and insights generation. • Maintain and update configurations in MSM, SDSF, and Fabric. • Apply updates and patches from Microsoft Git to MSM and related Power Platform applications. • Infrastructure Management • Oversee license management and renewals. • Manage data ingestion, transformation, and storage pipelines in Fabric. • Implement and monitor security protocols and data governance controls in Power Platform and Fabric environments. • Integrate systems and tools across the Microsoft sustainability technology stack. • Optimize cloud resources and support system uptime and backups in Power Platform Admin Center and Fabric Admin Portal. • Solution Utilization and Enhancements • Lead change management for new data flows and notification systems. • Maintain internal knowledge base and training materials. • Manage backlog of feature enhancements and prioritize updates. • Enhance methodologies, reporting templates, and dashboard visualizations. • Re-run data jobs and upload remediated data during error handling. • Perform manual data runs outside scheduled freeze dates, as needed. • Required Experience and Capabilities Technical Skills • Proficiency in Microsoft Power Platform, including Power BI, Power Automate, Power Apps, Dataverse, and Fabric Compute. • Experience with Microsoft Fabric, Lakehouse, Delta Lake, Azure SQL, Azure Blob Storage, and OneLake architecture. • Familiarity with MSM, ArcGIS, and ESG data schemas. • Strong understanding of data governance, compliance, and security protocols. • Experience with cloud resource monitoring and optimization. • Analytical and Reporting Skills • Ability to analyze ESG data and generate actionable insights. • Experience in dashboard design and report automation. • Knowledge of sustainability frameworks, including CSRD, TCFD, CDP, and ISSB. • Project and Change Management • Experience managing data change in data collection and reporting processes. • Ability to prioritize and manage a backlog of enhancements. • Strong documentation and knowledge base management skills. Soft Skills • Excellent communication and stakeholder engagement skills. • Strong problem-solving and troubleshooting abilities. • Collaborative mindset with cross-functional teams, including IT, ESG, and data owners.