Power BI / Microsoft Fabric Architect (Hybrid)

Signet Jewelers Limited; Akron (OH); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Competitive healthcare, dental & vision insurance

401(k) matching after one year of employment

Generous time off and company holidays

Merchandise discount

Learning & Development programs

Job summary

Signet Jewelers Limited is seeking an experienced PowerBI / Microsoft Fabric Architect in Akron, Ohio, to lead the design and optimization of enterprise analytics solutions. This role will enhance reporting solutions using Microsoft Fabric and AWS Redshift while enabling high-performance self-service analytics.

The ideal candidate should have a Bachelor’s degree in Computer Science or a related field and over 5 years of experience in enterprise BI architecture. Benefits include competitive healthcare and 401(k) matching after one year.

Qualifications

• 5+ years of experience in enterprise BI architecture, semantic modeling, and cloud data platforms.

Responsibilities

• Design and implement enterprise reporting and analytics solutions leveraging Microsoft Fabric, PowerBI, AWS Redshift, and OneLake.
• Define enterprise semantic layer strategies that provide consistent KPIs, metrics, hierarchies, and business definitions.
• Implement security and governance controls such as Row-Level Security, Object-Level Security, and other data governance measures.
• Lead Microsoft Fabric and PowerBI development.

Skills

Enterprise BI architecture

Semantic modeling

Microsoft Fabric

PowerBI

AWS Redshift

DAX

Education

Bachelor’s degree in Computer Science or related field

Tools

Microsoft Fabric

PowerBI

AWS Redshift

Job description

Position Summary

We are seeking an experienced PowerBI / MicrosoftFabric Architect to lead the design, implementation, and optimization of enterprise analytics solutions leveraging Microsoft Fabric, PowerBI, and AWS Redshift as the primary enterprise data platform. The role will focus 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.

Responsibilities

• Enterprise Analytics Architecture: design and implement enterprise reporting and analytics solutions leveraging Microsoft Fabric, PowerBI, AWSRedshift, and OneLake.
• Define enterprise semantic layer strategies that provide consistent KPIs, metrics, hierarchies, and business definitions.
• Establish standards, best practices for enterprise reporting, semantic modeling, governance, and performance optimization.
• Lead BI modernization initiatives, transitioning legacy reporting platforms to PowerBI and MicrosoftFabric.
• Design and optimize AWSRedshift connectivity architecture for DirectQuery / DirectConnect reporting, including schema design, sort keys, distribution styles, and materialized views.
• Implement hybrid architectures using DirectQuery, Import, Composite Models, and Direct Lake to balance query performance, concurrency, scalability, cost, and user experience.
• Design and maintain enterprise semantic models supporting large‑scale analytics: dimensional models, star schemas, reusable reporting structures, governed datasets, KPIs, and calculations using DAX.
• Implement security and governance controls such as Row‑Level Security, Object‑Level Security, and other data governance measures.
• Lead Microsoft Fabric and PowerBI development: implement Lakehouse Warehouse, Dataflows, Gen2, OneLake, real‑time analytics, high‑performance dashboards, CI/CD pipelines, and deployment processes.

Qualifications

• Bachelor’s degree in Computer Science or related field (preferred).
• 5+ years of experience in enterprise BI architecture, semantic modeling, and cloud data platforms.

Benefits

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