BI Architect

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)