Power BI, Microsoft Fabric Architect

Signet Jewelers

Power BI / Microsoft Fabric Architect leading design and optimization of enterprise analytics solutions. Focus on scalable semantic models and high-performance self-service analytics using Microsoft Fabric and AWS Redshift.

Posted 6/10/2026full-timeAkron • Ohio, Texas • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

Amazon RedshiftAWSCloud

About the role

Key responsibilities & impact

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-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
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
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) and Object-Level Security (OLS) with data governance controls
Ensure semantic models support enterprise scalability, maintainability, and self-service reporting
Lead implementation of Microsoft Fabric capabilities including Lakehouse, Warehouse, Dataflows Gen2, Semantic Models, and OneLake
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.

Requirements

What you’ll need

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

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Microsoft FabricPower BIAWS RedshiftDAXDirectQueryImportComposite ModelsRow-Level SecurityObject-Level Securitydimensional models

Soft Skills

leadershipcollaborationcommunicationproblem-solvingstrategic thinkingperformance optimizationgovernancescalabilityuser experiencedata governance