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.
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
