Power BI Engineer

Software Guidance & Assistance, Inc., (SGA), is searching for a Power BI Engineer for a direct placement assignment with one of our premier Computer Software services clients in Ann Arbor, MI.

Job Duties and Responsibilities:
We are looking for an experienced Power BI Engineer to drive the development and administration of business intelligence capabilities within our multi-tenant SaaS platform. This role focuses on creating, securing, and managing Power BI workspaces, reports, and datasets-while also supporting embedded analytics, tenant-level access control, and integration with modern cloud platforms like Microsoft Fabric and AWS.
Successful Candidates Will Demonstrate:
Power BI Development:

• Design, develop, and publish Power BI reports, dashboards, and datasets tailored to internal and external users.
• Build reusable, scalable data models with a focus on performance, usability, and data governance.
• Implement row-level security (RLS) and user-based permissions in a multi-tenant setup.
• Optimize Power BI performance through proper modeling, DAX tuning, and query optimization.

Power BI Administration:

• Manage workspaces, deployment pipelines, dataset refresh schedules, and gateway configurations.
• Build administrative dashboards to monitor report usage, tenant access, and overall platform health.
• Support tenant onboarding/offboarding processes with Power BI provisioning and access automation.
• Collaborate with security and IT teams to enforce governance, compliance, and data privacy standards.

Cloud Integration - Microsoft Fabric & AWS:

• Leverage Microsoft Fabric for Power BI dataflows, pipelines, and OneLake-based data management.
• Integrate Power BI Embedded within a cloud-hosted (AWS) environment, ensuring secure identity management, tenant isolation, and seamless access through services and custom authentication layers.
• Contribute to the SaaS architecture by ensuring secure, isolated, and cost-effective Power BI deployment models.

Collaboration:

• Work closely with business stakeholders, product managers, and data engineers to translate requirements into visual insights.
• Partner with DevOps and QA to enable CI/CD practices for Power BI artifacts.
• Provide documentation and knowledge sharing across internal teams and client-facing support.

Preferred (Nice to Have):

• Experience embedding Power BI dashboards into custom web applications using JavaScript SDK or Power BI REST APIs.
• Familiarity with Tomcat or Spring-based applications is a bonus.
• Experience with automation tools for report deployment, governance monitoring, or provisioning.
• Exposure to building custom admin portals for BI usage tracking and role/user management.

Required Qualifications:

• 5+ years of experience developing Power BI reports, dashboards, and data models.
• Strong experience with Power BI service administration, workspace configuration, and security models.
• Hands-on experience with Microsoft Fabric, including dataflows, pipelines, and OneLake.
• Understanding of multi-tenant BI strategies, including tenant-level data isolation and access control.
• Proficient with DAX, Power Query (M), and Power BI desktop.
• Familiarity with cloud platforms such as AWS or Azure, and general understanding of SaaS architectures.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.