Senior BI Architect

Essential Duties and Responsibilities Architecture & Platform OwnershipDefine and lead the overall application and date architecture strategy across the organization.Design and implement scalable semantic models, data marts, and enterprise BI frameworks.Establish standards for data modeling (star schema), naming conventions, and reusable datasets.Lead environmental strategy including development, testing, deployment pipelines, and lifecycle management.Ensure solutions are optimized for performance, scalability, and long-term maintainability.Governance & StandardsEstablish and enforce BI governance practices, including data quality, security (RLS), and access controls.Define best practices for software development, version control, and release management.Review and approve technical solutions to ensure alignment with architectural standards.Lead efforts around audit readiness, compliance, and documentation standards.Leadership & MentorshipProvide technical leadership and mentorship to BI developers and analysts.Guide analysts on proper use of certified datasets vs. creating redundant or siloed reports.Conduct code reviews and enforce development standards across the BI team.Act as the escalation point for complex technical challenges.Development (Hands-On Leadership)Design and develop complex BI solutions including semantic models, dashboards, and paginated reports.Develop advanced DAX, Power Query (M), and T-SQL for high-performance analytics.Build and optimize data models that support enterprise-wide reporting needs.Develop Power Automate workflows for operationalizing BI processes.Cross-Functional CollaborationPartner with data engineering teams to define data pipelines, data structures, and ingestion strategies.Translate business requirements into scalable, production-grade BI solutions.Influence upstream data design to improve downstream analytics usability.AI & Advanced Analytics EnablementLeverage Microsoft Copilot, Fabric AI capabilities, and approved tools to enhance development efficiency and insight generation.Define responsible and effective usage patterns for AI-enabled analytics within BI workflows.Stay current with evolving industry trends and recommend adoption where appropriate.Job Requirements: 7+ years of experience in enterprise BI development.Demonstrated experience designing BI architecture and scalable data models.Strong expertise in Microsoft Fabric, Azure SQL Server, and enterprise data platforms.Advanced proficiency in DAX, Power Query (M), and T-SQL.Proven ability to lead technical initiatives and mentor junior team members.Strong understanding of BI governance, security, and deployment best practices.Preferred Qualifications:Microsoft Certification in BI Tools.Experience in regulated or compliance-driven environments.Experience implementing enterprise BI governance frameworks.Familiarity with DevOps practices, CI/CD pipelines, and version control for BI.EEO Non-Discrimination and ADA Reasonable Accommodation Statement Willdan is an equal opportunity employer. Architecture & Platform OwnershipDefine and lead the overall application and date architecture strategy across the organization.Design and implement scalable semantic models, data marts, and enterprise BI frameworks.Establish standards for data modeling (star schema), naming conventions, and reusable datasets.Lead environmental strategy including development, testing, deployment pipelines, and lifecycle management.Ensure solutions are optimized for performance, scalability, and long-term maintainability.Governance & StandardsEstablish and enforce BI governance practices, including data quality, security (RLS), and access controls.Define best practices for software development, version control, and release management.Review and approve technical solutions to ensure alignment with architectural standards.Lead efforts around audit readiness, compliance, and documentation standards.Leadership & MentorshipProvide technical leadership and mentorship to BI developers and analysts.Guide analysts on proper use of certified datasets vs. creating redundant or siloed reports.Conduct code reviews and enforce development standards across the BI team.Act as the escalation point for complex technical challenges.Development (Hands-On Leadership)Design and develop complex BI solutions including semantic models, dashboards, and paginated reports.Develop advanced DAX, Power Query (M), and T-SQL for high-performance analytics.Build and optimize data models that support enterprise-wide reporting needs.Develop Power Automate workflows for operationalizing BI processes.Cross-Functional CollaborationPartner with data engineering teams to define data pipelines, data structures, and ingestion strategies.Translate business requirements into scalable, production-grade BI solutions.Influence upstream data design to improve downstream analytics usability.AI & Advanced Analytics EnablementLeverage Microsoft Copilot, Fabric AI capabilities, and approved tools to enhance development efficiency and insight generation.Define responsible and effective usage patterns for AI-enabled analytics within BI workflows.Stay current with evolving industry trends and recommend adoption where appropriate.Job Requirements: 7+ years of experience in enterprise BI development.Demonstrated experience designing BI architecture and scalable data models.Strong expertise in Microsoft Fabric, Azure SQL Server, and enterprise data platforms.Advanced proficiency in DAX, Power Query (M), and T-SQL.Proven ability to lead technical initiatives and mentor junior team members.Strong understanding of BI governance, security, and deployment best practices.Preferred Qualifications:Microsoft Certification in BI Tools.Experience in regulated or compliance-driven environments.Experience implementing enterprise BI governance frameworks.Familiarity with DevOps practices, CI/CD pipelines, and version control for BI.EEO Non-Discrimination and ADA Reasonable Accommodation Statement Willdan is an equal opportunity employer.

Create an account to see the full posting, access our search engine, and more.