The Senior BI Architect is a senior-level technical leader responsible for designing, governing, and scaling enterprise business intelligence platforms. This role goes beyond dashboard development and includes ownership of system BI architecture, data modeling standards, platform governance, and team mentorship.
This position serves as the bridge between business stakeholders, data engineering, and analytics teams, ensuring that solutions are built on a robust, scalable, and secure architecture rather than ad hoc implementations.
Essential Duties and Responsibilities
Architecture & Platform Ownership- Define 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.
- Establish 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.
- Provide 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.
- 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.
- Partner 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.
- Leverage 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.
- 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. Applicants are considered for all positions without regard to race, religious creed, color, age marital status, sex, sexual orientation, gender identity, gender expression, citizenship status, national origin, ancestry, religion, military service or veteran status, disability, medical condition, childbirth and related medical conditions, genetic testing, reproductive status or any other classification protected by federal, state or local laws and ordinances. Willdan does not discriminate on the basis of physical or mental disability where the essential functions of the job can be reasonably accommodated. Determinations on requests for reasonable accommodation will be made on a case-by-case basis. If you need reasonable accommodation for any part of the application and hiring process, please notify us.
Willdan Energy Solutions participates in E-Verify.
Skills Required
- 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
- 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
What We Do
Willdan (NASDAQ: WLDN) provides professional consulting and technical services to utilities, public agencies and private industry throughout the United States. Its broad set of complementary disciplines span energy efficiency, distributed energy resources and software, engineering and planning, public finance and economic consulting. Willdan provides integrated technical solutions to extend the reach and resources of its clients, and provides all services through its subsidiaries specialized in each segment. Since our establishment in 1964, Willdan has grown significantly, employing 1,560 dedicated professionals (excluding contractors) as of December 31, 2021, and achieving an impressive annual Contract Revenue exceeding $350 million. Willdan benefits from long standing, well-established relationships with local and state government agencies, investor-owned and municipal utilities, and commercial and industrial firms throughout the United States. Headquartered in Anaheim, California, Willdan operates from offices in more than 20 states across the US, with its largest operations in California and New York.
