Senior BI Architect

Senior Business Intelligence Architect

AArete is one-of-a-kind when it comes to consulting firm culture.

We're a global, innovative management and technology consulting firm, with offices in the U.S., India, and the U.K. Our name comes from the Greek word for excellence: "Arete." And excellence is exactly what we strive for.

Our success starts with enriching and empowering our people. From robust career development planning to competitive life and wellness benefits, AArete's "Culture of Care" takes a holistic approach to the employee experience.

AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing space for personal development and fulfillment.

The Role

As a hands-on Business Intelligence (BI) Architect, you will be responsible for designing, developing, and implementing business intelligence solutions that drive data-driven decision-making across client organizations. This is not a purely strategic or oversight role-we're looking for someone who enjoys working directly with the data, building scalable solutions, and solving complex problems through engineering.

You will collaborate closely with business stakeholders and offshore development teams to turn data needs into working, impactful BI solutions. This includes building data models, writing data pipelines, and creating dynamic dashboards and analytics tools. You'll work across a wide variety of projects and datasets-healthcare, retail, finance, higher-ed-and be expected to bring curiosity and technical depth to each one. The BI Architect will also provide leadership to delivery teams, enforce BI best practices, and help shape a modern, efficient, and forward-thinking analytics environment.

Work You'll Do

• Design, develop, and implement business intelligence and data analytics solutions, including data warehouses, data lakes, data pipelines, reporting layers, and visualizations
• Develop and deliver solutions that go beyond dashboards-automation, insight delivery, embedded analytics, and decision support tools
• Create and optimize logical and physical data models to support reporting and analytics needs, ensuring data consistency and accuracy
• Build robust, scalable data processing to integrate data from cloud data platforms, such as Snowflake, Databricks, or third-party sources
• Work directly with business stakeholders, analysts, and IT partners to gather requirements and rapidly translate them into technical BI solutions
• Collaborate closely with offshore developers and engineers to coordinate delivery, review code, and maintain alignment on architecture and standards
• Monitor and tune BI performance, troubleshoot issues, and optimize for scalability and data freshness
• Evaluate, pilot, and implement new BI tools and technologies to keep solutions current and future-proof
• Promote the effective use of BI platforms across the organization through training, documentation, and mentorship
• Lead and support a team of BI developers, analysts, and engineers while also contributing as an individual contributor

Requirements

• Minimum of 8 years of experience in Business Intelligence, Data Warehousing, or Data Architecture roles, with at least 3-5 years in a BI Architect or similar role
• Expertise in BI tools such as Power BI, Tableau, or similar platforms; proficiency in SQL, data modeling, and ETL tools like SSIS, Talend, or Informatica
• In-depth knowledge of relational databases (e.g., SQL Server, Oracle, MySQL) and modern data warehousing solutions (e.g., Snowflake, Redshift, Databricks)
• Experience with cloud data platforms such as Azure, AWS, including data storage, data pipelines, and analytics services
• Excellent analytical and problem-solving skills, with a strong ability to translate complex data into actionable insights
• Experience in establishing data governance frameworks, data quality management, and data security practices
• Excellent communication and interpersonal skills, with the ability to explain technical concepts to non-technical stakeholders and lead cross-functional teams
• Relevant certifications in BI tools, data architecture, or cloud platforms are a plus (e.g., Microsoft Certified: Data Analyst Associate, AWS Certified Data Analytics, etc.)
• Willingness to engage in direct client interaction, including travel to client locations
• Must be legally authorized to work in the United States without the need for employer sponsorship

Preferred Requirements

• Based in Chicago, IL and flexible to work from our Chicago office as needed

Compensation & Benefits

• Flexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidays
• Own Your Day flexible work policy
• Competitive majority employer-paid benefits: Medical, Dental, Vision, 401K Match
• Employee Stock Ownership Plan
• Generous paid parental leave options
• Employer paid Life Insurance, STD, LTD
• Charitable contribution matching program
• New client commission opportunities and referral bonus program
• Bike share discount program

The estimated base salary range for this position is XX - XX. In addition to this base salary, individuals may be eligible for an annual discretionary bonus. This range is a part of a competitive, total compensation package together with our Employee Stock Ownership Plan, majority employer-paid benefits, and incentive pay for eligible roles. Please note that this range is a guideline and individual total compensation may vary due to numerous factors including but not limited to experience level, certifications, and other relevant business considerations.

AArete will accept applications until the position is filled. The job posting will be removed once the role is no longer available.

We put humans at the center of our work

We're a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.

But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.

And we've been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.

We've earned a Great Place to Work Certification and been named a World's Best Management Consulting Firm by Forbes, Vault's Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000's Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms.

Learn more about our award-winning culture

We are an Equal Employment Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

#LI-DNI