Senior Business Intelligence Solution Architect/Developer

BI Solution Architect / Developer

Location: 100% Remote — Nearshore

Rate: Up to USD $30/hr

Important: Fluent English is required

We are looking for a senior-level Business Intelligence professional with deep expertise in the Microsoft Fabric platform, combining strong reporting delivery skills with an architectural and administrative mindset.

The ideal candidate will be capable of designing, governing, and scaling BI solutions that support enterprise analytics needs.

Key Qualifications

Core Platform and Technical Skills

The candidate must have extensive hands-on experience with Microsoft Fabric, including:

• Power BI, OneLake, semantic models, dataflows, and Fabric workspaces
• Fabric capacity management, security, governance, and deployment patterns
• Understanding of how Fabric components interact across ingestion, modeling, and consumption layers
• Knowledge of Snowflake, SQL Server, and Oracle connections to Power BI for composite models

The candidate should also have advanced Power BI reporting and modeling skills, including:

• Semantic model design with strong dimensional and analytical modeling principles
• DAX optimization, performance tuning, and report scalability
• Applying best practices for usability, accessibility, and maintainability
• Experience with Paginated Reports, including best-practice guidance on when to use paginated reporting versus interactive analytical reports in Power BI

BI Architecture and Administration

The ideal candidate will bring a strong BI architecture and administration mindset, including:

• Defining workspace strategies, dataset reuse, and environment separation such as Dev, Test, and Prod
• Implementing governance, security, Row-Level Security, and lifecycle management standards
• Supporting enterprise-grade BI solutions rather than one-off reports
• Architecting end-to-end solutions and producing clear, actionable documentation
• Translating business requirements into scalable technical designs that can be built independently or handed off to other team members for execution

Embedded Analytics and Automation

The candidate should have solid understanding of embedded analytics patterns within Fabric and Power BI, including:

• Evaluating different embedding options based on internal versus external consumption use cases
• Designing scalable and secure embedded reporting solutions
• Leveraging the Power BI REST APIs for deployment automation and environment promotion
• Supporting CI/CD pipelines into Fabric
• Managing datasets, reports, workspaces, and refresh operations programmatically

AI and Copilot Enablement

The candidate should have working knowledge of AI capabilities within Microsoft Fabric, including Copilot, such as:

• Identifying where Copilot can improve development efficiency, model exploration, and reporting workflows
• Understanding how BI assets can be designed to best leverage Copilot and AI-assisted insights

Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.

• Familiarity with responsible AI and governance considerations in analytics environments

Domain Knowledge

Experience in the Healthcare and/or Insurance domain is highly valuable, including:

• Understanding of business concepts such as claims, members, providers, eligibility, policies, and financial metrics
• Awareness of regulatory, compliance, and data privacy considerations common to the industry

Communication and Collaboration

The candidate must be able to engage directly with business stakeholders to:

• Gather and refine reporting and analytics requirements
• Translate business needs into scalable BI and semantic model designs
• Advise on solution architecture and appropriate analytic approaches
• Collaborate effectively with Data Engineering, platform, security, product, operations, and leadership teams
• Communicate technical concepts clearly to both technical and non-technical audiences

Overall Mindset

We are looking for someone with a BI delivery and architectural mindset, focused on:

• Building reusable, governed, and scalable BI assets
• Balancing speed of delivery with long-term platform sustainability
• Treating Power BI and Fabric as enterprise platforms rather than isolated tools