BI Architect

Description
Business Intelligence Architect
AArete is one-of-a-kind when it comes to consulting firm culture.
Why AArete?
We are 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.
We were recently named by Forbes as one of theWorld's Best Management Consulting Firms 2024.
AArete earned this recognition for its services, experience, and expertise in two categories:
Digital Transformation and Data Analytics.
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.
At AArete, we encourage you to unlock your full potential by directly contributing to our mission and prioritizing space for personal development and fulfillment.
The Role
As a Business Intelligence (BI) Architect, you will be responsible for designing, developing, and implementing business intelligence solutions that drive data-driven decision-making across organizations.
The Architect will work closely with stakeholders to understand their data needs and translate them into technical requirements.
The role will involve creating data models, designing ETL processes, and designing dashboards and reports.
The BI Architect will also be responsible for guiding the technical team and ensuring best practices are implemented for the BI solutions.
The candidate should have a strong background in data warehousing, data modeling, and BI tools along with excellent problem-solving and communication skills.
Work You'll Do
Design, develop, and implement Business Intelligence and data analytics solutions, including data warehouses, data lakes, ETL processes, reporting, and visualization
Create and optimize logical and physical data models to support reporting and analytics needs, ensuring data consistency and accuracy
Design and build robust ETL (Extract, Transform, Load) processes to ensure efficient data flow and integration from various data sources
Work closely with business stakeholders, data analysts, data scientists, and IT teams to gather requirements and translate them into BI solutions
Monitor and optimize BI solutions for performance, scalability, and security
Evaluate, select, and integrate new BI tools and technologies to enhance analytics capabilities, staying current with industry trends and innovations
Provide training, documentation, and support to users and data teams, promoting the effective use of BI tools, best practices and standards
Lead and mentor a team of BI developers, analysts, and data engineers, fostering a collaborative and high-performance work environment
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.)
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
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 maternity/paternity leave options
Completely employer paid Life Insurance, STD, LTD
Charitable contribution matching program
New client commission opportunities and referral bonus program
Video-free Fridays
Bike share discount program
About AArete
AArete is a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and advisory services.
Our cross-industry solutions are powered by modern technology, market intelligence, and big data to drive purposeful change and actionable outcomes.
AArete is guided by our deeply embedded principles:
Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.
We are proud to have earned a Great Place to Work Certification and named one of America's Best Management Consulting Firms by Forbes, Vault's Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000's Fastest Growing Firms, Consulting Magazine's Fastest Growing Firms.
AAP/EEO Statement
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