Power BI / Microsoft Fabric Architect (Hybrid)

Signet Jewelers; Cleveland (OH); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Competitive healthcare, dental & vision insurance

401(k) matching after one year of employment

Generous time off + company holidays

Merchandise discount

Learning & Development programs

Job summary

Signet Jewelers is looking for an experienced Power BI / Microsoft Fabric Architect to lead analytics solutions design and implementation. This role involves optimizing reporting architectures and building scalable semantic models.

The ideal candidate will have over 5 years of relevant experience and a strong educational background in Computer Science. Benefits include competitive insurance, 401(k) matching, and generous time off.

Qualifications

• 5+ years of experience in enterprise BI architecture and data analytics.
• Expertise in data governance and security controls.
• Proficiency in building scalable semantic models and high-performance dashboards.

Responsibilities

• Lead design and implementation of enterprise analytics solutions.
• Architect reporting and analytics solutions leveraging Microsoft Fabric and AWS Redshift.
• Establish best practices for semantic modeling and enterprise reporting.

Skills

Enterprise BI architecture

Power BI

Microsoft Fabric

AWS Redshift

Education

Bachelor's degree in Computer Science or related field

Tools

DAX

Microsoft Fabric capabilities

Dataflows Gen2

Job description

Signet Jewelers is the world's largest retailer of diamond jewelry, operating more than 2,800 stores worldwide under the iconic brands: Kay Jewelers, Zales, Jared, H.Samuel, Ernest Jones, Peoples, Banter by Piercing Pagoda, Rocksbox, JamesAllen.com and Diamonds Direct. We are a people‑first company and this core value is at the heart of everything we do, from empowering our valued team members, to collaborating with our customers, to fostering the communities in which we live and serve. People – and the love their actions inspire – are what drive us. We’re not only proud of the love we inspire outside our walls, we’re especially proud of the diversity, inclusion and equity we’re inspiring inside. There are dynamic career paths awaiting you – rewarding opportunities to impact the lives of others and inspire love. Join us!

Power BI / Microsoft Fabric Architect

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

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

Enterprise Analytics Architecture

• Architect enterprise reporting and analytics solutions leveraging Microsoft Fabric, Power BI, AWS Redshift, OneLake, and 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, cost optimization, 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.
• Implement hybrid architectures leveraging DirectQuery, Import, Composite Models, 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), and 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, and 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

• Bachelor's degree in Computer Science or related field is preferred.
• 5+ years of experience in enterprise BI architecture and data analytics.

BENEFITS & PERKS

• Competitive healthcare, dental & vision insurance
• 401(k) matching after one year of employment
• Generous time off + company holidays
• Merchandise discount
• Learning & Development programs
• Much more!