Power BI/Microsoft Fabric Architect

Signet Jewelers; United States; On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

401(k) matching after one year of EMP

Job summary

Signet Jewelers is seeking an experienced Power BI / Microsoft Fabric Architect to lead enterprise analytics using Fabric, Power BI, and AWS Redshift. The role focuses on scalable semantic models, governance, and hybrid-cloud architectures.

Responsibilities include designing DirectQuery/Direct Connect architectures, optimizing performance, and guiding BI modernization across the organization.

Qualifications

• Bachelors degree in Computer Science or related field is preferred.
• 5+ years experience in enterprise BI analytics architecture and implementation.

Responsibilities

• Architect enterprise reporting and analytics solutions leveraging Microsoft Fabric, Power BI, and AWS Redshift.
• Design scalable hybrid-cloud analytics architectures integrating Microsoft Fabric with AWS data platforms.
• Define enterprise semantic layer strategies with consistent KPIs and business definitions.
• Establish standards for enterprise reporting, governance, and performance optimization.
• Lead BI modernization transitioning legacy reporting to Power BI and Fabric.
• Design DirectQuery/Direct Connect reporting architectures against AWS Redshift and optimize performance.
• Collaborate with data engineering to optimize Redshift schemas and materialized views.
• Define data access patterns between Fabric, Power BI, and Redshift with minimal data movement.

Skills

Enterprise BI architecture

Semantic modeling

Governance & security

DAX calculations

Cross-team collaboration

Performance optimization

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft Fabric

Power BI

AWS Redshift

OneLake

DirectQuery/Direct Connect

Fabric Semantic Models

Job description

Location: Dallas, TX or Akron, OH (Hybrid) Preferred

Open to remote

Position Summary

We are seeking an experienced Power BI / Microsoft Fabric Architect to lead the design, implementation, and optimization of enterprise analytics solutions leveraging Microsoft Fabric, Power BI, and AWS Redshift as the primary enterprise data platform.

This role will focus heavily on building scalable semantic models and enterprise reporting solutions using Direct Connect/DirectQuery connectivity patterns to AWS Redshift while enabling governed, high-performance self-service analytics across the organization.

The ideal candidate will possess deep expertise in enterprise BI architecture, semantic layer design, cloud data platforms, and cross-platform integration between Microsoft and AWS technologies.

Responsibilities

• Architect enterprise reporting and analytics solutions leveraging:
• Microsoft Fabric
• Power BI
• AWS Redshift
• OneLake
• Fabric Semantic Models
• Design scalable hybrid-cloud analytics architectures integrating Microsoft Fabric with AWS-based enterprise data platforms.
• Define enterprise semantic layer strategies that provide consistent KPIs, metrics, hierarchies, and business definitions.
• Establish standards and best practices for enterprise reporting, semantic modeling, governance, and performance optimization.
• Lead enterprise BI modernization initiatives transitioning legacy reporting platforms to Power BI and Microsoft Fabric.

AWS Redshift & Connectivity Architecture

• Design and optimize DirectQuery/Direct Connect reporting architectures against AWS Redshift.
• Develop strategies for balancing:
• query performance,
• concurrency,
• scalability,
• and user experience.
• Partner with data engineering teams to optimize Redshift schemas, sort keys, distribution styles, and materialized views to support Power BI workloads.
• Define data access patterns between Fabric, Power BI, and Redshift while minimizing unnecessary data movement.
• DirectQuery,
• Import,
• and Direct Lake capabilities where appropriate.
• Optimize gateway, networking, authentication, and refresh strategies across AWS and Microsoft ecosystems.

Semantic Modeling & Data Design

• Architect enterprise semantic models supporting large-scale analytics and reporting workloads.
• Design dimensional models, star schemas, and reusable reporting structures aligned with enterprise business processes.
• Develop governed datasets, KPIs, calculations, and reusable business logic using DAX and Power BI semantic models.
• Implement:
• Row-Level Security (RLS)
• Object-Level Security (OLS)
• Data governance controls
• Ensure semantic models support enterprise scalability, maintainability, and self-service reporting.

Microsoft Fabric & Power BI Development

Lead implementation of Microsoft Fabric capabilities including:

• Lakehouse
• Warehouse
• Dataflows Gen2
• Semantic Models
• OneLake
• Real-Time Analytics

Design high-performing Power BI dashboards and enterprise reporting solutions.

Optimize:

• dataset performance,
• DAX calculations,
• query folding,
• caching strategies,
• and report rendering performance.

Establish Dev/Test/Prod deployment pipelines and CI/CD processes for Power BI and Fabric assets.

Position Qualifications

• Bachelors degree in Computer Science or related field is preferred
• 5+ years experience

Benefits & Perks

• 401(k) matching after one year of employment