Demo

Senior BI Architect

Lumen Resources
Westchester, IL Full Time
POSTED ON 7/20/2026
AVAILABLE BEFORE 9/5/2026

We're looking for a Senior Business Intelligence (BI) Architect to join a growing enterprise organization focused on modernizing its analytics and reporting ecosystem.


What You’ll Do

  • Lead the design, architecture, and ongoing evolution of an enterprise Business Intelligence platform, ensuring scalable, secure, and high-performing reporting solutions across the organization
  • Design dimensional data models and semantic layers that support enterprise reporting, dashboards, and analytics using industry best practices for data warehousing
  • Build and optimize Power BI semantic models, DAX calculations, security models, and reporting performance while leveraging Microsoft Fabric capabilities
  • Establish governance standards for BI development, including modeling conventions, report design standards, reusable datasets, security practices, and performance optimization
  • Manage BI platform administration across development, testing, and production environments, including capacity planning, gateway management, deployments, and platform monitoring
  • Partner with Data Engineering and business stakeholders to translate business requirements into scalable reporting and analytics solutions that support enterprise decision making
  • Develop long-term BI platform strategy by evaluating emerging technologies, improving architecture, and recommending enhancements that align with organizational goals
  • Create deployment strategies, release management processes, validation plans, rollback procedures, and documentation to support reliable production releases
  • Monitor platform adoption, usage metrics, security compliance, and audit readiness while promoting best practices around data governance and self-service analytics
  • Provide technical leadership, mentor BI developers, review technical designs and code, and guide distributed development resources to ensure consistent delivery standards


What We’re Looking For

  • 6 - 10 years of experience designing enterprise data warehouse solutions using dimensional modeling methodologies
  • 4 - 7 years of hands-on experience developing Power BI solutions, including semantic models, advanced DAX development, and report optimization
  • Strong experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Direct Lake, and modern analytics architecture
  • Experience implementing Row Level Security (RLS), semantic models, reusable datasets, and enterprise reporting standards
  • Advanced Microsoft SQL Server and T-SQL skills with experience writing complex queries, stored procedures, and performance tuning
  • Experience supporting enterprise ETL or modern data integration pipelines within cloud or hybrid data environments


Join us at Lumen Resources, where your expertise will contribute to our growth, and you'll have the opportunity to have fun and thrive alongside a dynamic group of professionals. Apply today and become a part of our exciting journey!


Lumen Resources:


At Lumen Resources you will be partnering with trained recruiters who will guide you through discovering a brighter future. Our recruiters are concise and efficient in all interactions, hold exceptional communication, and will support resume writing and interview preparation, so you can land any position you want!


If this role doesn’t align with what you are looking for, we have a host of clients with roles that could be a match. Feel free to reach out to connect with one of our team members at info@lumenresources.com1


Lumen Resources is an Equal Opportunity Employer

Don't hesitate to get in touch with our team for more information

Salary : $140,000 - $170,000

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Lumen Resources

  • Lumen Resources Houston, TX
  • Global Tax Manager We're looking for a Global Tax Manager to oversee corporate tax operations for a diversified organization with complex domestic and inte... more
  • 4 Days Ago

  • Lumen Resources Orlando, FL
  • Responsibilities: Hire, mentor, and develop a team of AI and full-stack engineers. Set performance expectations, run career development conversations, and ... more
  • 5 Days Ago

  • Lumen Resources Plano, TX
  • We're looking for a Director of Quality Assurance & Quality Control to lead enterprise quality strategy for a rapidly growing organization delivering compl... more
  • 5 Days Ago

  • Lumen Resources Houston, TX
  • We’re looking for a Sr. Payroll Tax & Technology Analyst for a global organization with U.S. and Canadian operations. What You’ll Do Serve as the go-to pay... more
  • 10 Days Ago


Not the job you're looking for? Here are some other Senior BI Architect jobs in the Westchester, IL area that may be a better fit.

  • Trova Search Oak Brook, IL
  • NO C2C OR 3RD PARTY VENDORS. Overview This is a hands-on architectural role, responsible for designing, building, and governing core BI solutions while ens... more
  • 1 Month Ago

AI Assistant is available now!

Feel free to start your new journey!