BI Architect

Jefferson Frank; Stockholms kommun; On-site; SEK 900,000 - 1,300,000; Full time

Job summary

Jefferson Frank is seeking a Senior BI Architect to design, govern, and scale a company-wide BI ecosystem. You will own the technical vision for data modeling, warehousing, and delivery of trusted insights to executives and analysts.

The role blends data architecture, analytics engineering, and stakeholder strategy. You will lead migrations to Microsoft Fabric, define dimensional models, and ensure cross-cloud data integration while mentoring BI teams and partnering with product and analytics

Qualifications

• 7+ years in BI, data architecture or analytics engineering
• Proven track record of enterprise-scale BI
• Hands-on leadership of migration projects to Microsoft Fabric
• Deep expertise in dimensional modeling and modern warehouse design
• Cloud-agnostic solutions spanning AWS, Azure and GCP
• Advanced Power BI (DAX) and knowledge of other BI platforms
• Strong SQL and ELT/ETL tooling experience
• Experience in data governance and security
• Excellent communication and mentoring abilities

Responsibilities

• Design and own the enterprise BI architecture including data warehouse/lakehouse structures
• Define data modeling standards (dimensional modeling, star/snowflake)
• Lead selection and governance of BI tools (Power BI, Tableau, Looker)
• Architect migrations to Microsoft Fabric (OneLake, lakehouses/warehouses, Data Factory)
• Ensure cloud-agnostic architecture and cross-platform data integration
• Collaborate with data engineering to design scalable data pipelines
• Establish data governance practices and metadata management
• Translate business requirements into scalable tech solutions
• Mentor BI developers and analysts on best practices
• Evaluate new BI technologies to keep architecture future-proof
• Drive self-service analytics with governed data models
• Own performance optimization for dashboards and semantic models

Skills

Business intelligence

Data architecture

Analytics engineering

Enterprise BI design

Dimensional modeling

Cloud-agnostic mindset

SQL proficiency

Leadership/mentoring

Stakeholder communication

Tools

Power BI

Tableau

Looker

dbt

Data Factory

Fivetran

Airflow

Job description

About the Role

On behalf of our client, [Client Company Name], we’re hiring a Senior BI Architect to design, govern, and scale their business intelligence ecosystem. You’ll own the technical vision for how data is modeled, warehoused, and delivered to the business – turning raw data into trusted, decision‑ready insight. This is a high‑impact role for someone who thrives at the intersection of data architecture, analytics engineering, and stakeholder strategy.

What You’ll Do

• Design and own the enterprise BI architecture, including data warehouse/lakehouse structures, semantic layers, and reporting frameworks
• Define and enforce data modeling standards (dimensional modeling, star/snowflake schemas, medallion architecture) to ensure consistency and performance across BI assets
• Lead the selection, implementation, and governance of BI tools and platforms (e.g., Power BI, Tableau, Looker) and their integration with the broader data stack
• Architect and lead migrations to Microsoft Fabric, including OneLake, lakehouses/warehouses, Data Factory pipelines, and Power BI semantic models
• Design solutions that remain cloud‑agnostic where appropriate, ensuring architecture isn’t unnecessarily locked to a single vendor and can integrate across AWS, Azure, and GCP data sources
• Partner with data engineering to design scalable, reliable data pipelines that feed BI systems
• Establish data governance practices – access controls, data quality standards, metadata management, and documentation
• Translate business requirements into scalable technical solutions, working closely with analysts, product, and executive stakeholders
• Mentor BI developers and analysts on architecture best practices, performance tuning, and self‑service enablement
• Evaluate emerging BI/analytics technologies and make recommendations to keep the architecture future‑proof
• Own performance optimization for large‑scale dashboards, semantic models, and queries
• Drive self‑service analytics adoption through well‑governed, reusable data models

What You’ll Bring

• 7+ years of experience in business intelligence, data architecture, or analytics engineering, including prior BI development experience
• Proven track record architecting enterprise‑scale BI solutions from the ground up
• Hands‑on experience leading multiple end‑to‑end migration projects onto Microsoft Fabric (OneLake, Lakehouse/Warehouse, Data Factory, Power BI semantic models), including planning cutover strategy and minimizing disruption to existing reporting
• Deep expertise in dimensional modeling and modern data warehouse/lakehouse design
• Cloud‑agnostic mindset – comfortable architecting solutions that span or move between AWS, Azure, and GCP rather than being tied to a single ecosystem
• Advanced proficiency with Power BI (DAX, semantic modeling) and working knowledge of other major BI platforms (Tableau, Looker)
• Strong SQL skills and familiarity with ELT/ETL tooling (e.g., dbt, Data Factory, Fivetran, Airflow)
• Experience with data governance, security, and role‑based access frameworks
• Excellent communication skills – able to translate between technical architecture and business needs
• Experience mentoring or leading technical teams

Nice to Have

• Experience migrating off legacy platforms (e.g., Synapse, SSAS, Snowflake, Redshift, BigQuery) onto Fabric
• Experience with Python or scripting for data automation
• Familiarity with CI/CD for analytics (version‑controlled BI development, Fabric deployment pipelines)
• Background in a specific industry vertical (finance, retail, healthcare, SaaS, etc.)
• Relevant certifications (e.g., Microsoft Certified: Fabric Analytics Engineer, Power BI, Snowflake SnowPro, AWS/GCP data certifications)