With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

Position:

Power BI Support

Entity/Business Unit

(BU) Assignment:

Arch Reinsurance IT

Job Description

This role provides operational support for Microsoft Power BI and Microsoft Fabric, ensuring platform reliability, performance, security, and governance. Key responsibilities include platform administration, monitoring, troubleshooting, capacity and gateway management, and user access control.

The position also supports Power BI reports, semantic models, and data refresh processes while resolving platform, deployment, and performance issues. You will collaborate with business users, data engineers, and platform administrators to uphold governance, security, and operational standards. The role also helps improve the platform by assessing new Microsoft Fabric capabilities, maintaining operational procedures, and promoting best practices across the organization.

Tasks/Responsibilities

·         Provide day-to-day operational support for Microsoft Power BI and Microsoft Fabric services, ensuring platform availability, reliability, and performance.

·         Monitor tenant health, Fabric capacities, workspaces, gateways, refresh schedules, usage, and activity to proactively identify service risks and performance issues.

·         Investigate and resolve incidents involving report access, data refresh failures, semantic models, gateways, deployment pipelines, permissions, and platform connectivity.

·         Administer Power BI workspaces, applications, user and group access, licenses, data gateways, data source connections, and capacity assignments in accordance with approved controls.

·         Support the development, maintenance, and optimization of Power BI reports, dashboards, semantic models, DAX measures, Power Query transformations, and data refresh processes.

·         Analyze and improve report, semantic model, DAX query, visual, refresh, and capacity performance using available monitoring and diagnostic tools.

·         Support controlled deployment of Power BI and Fabric solutions across development, test, and production environments, including release validation, rollback coordination, and post-deployment checks.

·         Apply and promote governance, security, naming, data classification, sharing, endorsement, workspace, and lifecycle management standards.

·         Partner with business users, report developers, data engineers, security teams, and platform administrators to diagnose issues and deliver sustainable solutions.

·         Manage support requests through the incident and service request process, maintain accurate records, meet agreed service levels, and communicate status and resolution details to stakeholders.

·         Develop and maintain operational procedures, support guides, troubleshooting playbooks, knowledge articles, configuration records, and platform documentation.

·         Automate repeatable administration, monitoring, reporting, and remediation tasks using PowerShell, REST APIs, SQL, Power Automate, or other approved tools.

·         Review Microsoft Fabric and Power BI updates, assess operational impact, test relevant capabilities, and recommend improvements to platform services and support processes.

·         Provide guidance and technical assistance to report creators and consumers on platform usage, security, performance, deployment, and governance best practices.

Requirements Skills/Experience

·         Practical experience building Power BI reports, dashboards, and semantic models.

·         Advanced DAX expertise, including complex measures, filter and row context, time intelligence, performance tuning, and calculation optimization.

·         Proficiency in Power Query.

·         Sound knowledge of data modeling, including dimensional models, star schemas, and fact and dimension tables.

·         Experience connecting Power BI to SQL Server, Microsoft Fabric, SharePoint, Excel, REST APIs, cloud storage, and other data sources.

·         Experience diagnosing and optimizing data refreshes, semantic models, DAX queries, and report visuals.

·         Strong knowledge of Power BI governance, including tenant administration, workspaces, gateways, capacities, security, and deployment pipelines.

·         Ability to resolve Power BI platform, refresh, access, security, and deployment issues.

·         Experience with Azure data services, such as Azure SQL Database, Azure Data Lake Storage, and Azure Synapse Analytics.

·         Experience working with Snowflake.

·         Experience implementing CI/CD processes for Power BI and Microsoft Fabric.

·         Experience with Microsoft Power Platform—Power Apps, Power Automate, and Copilot Studio—and integrating these solutions with Power BI and Microsoft Fabric.

·         Experience with Microsoft Fabric components, including Lakehouse, Warehouse, Data Factory pipelines, and semantic models.

·         Experience using PowerShell, REST APIs, and SQL for platform administration and automation.

Education

Bachelor’s degree on any of the following courses: Computer Science, Mathematics, Statistics, Accounting or Finance, Engineering or Information Technology

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.