BI Architect at AArete

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 RoleAs 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 DoDesign, develop, and implement Business Intelligence and data analytics solutions, including data warehouses, data lakes, ETL processes, reporting, and visualizationCreate and optimize logical and physical data models to support reporting and analytics needs, ensuring data consistency and accuracyDesign and build robust ETL (Extract, Transform, Load) processes to ensure efficient data flow and integration from various data sourcesWork closely with business stakeholders, data analysts, data scientists, and IT teams to gather requirements and translate them into BI solutionsMonitor and optimize BI solutions for performance, scalability, and securityEvaluate, select, and integrate new BI tools and technologies to enhance analytics capabilities, staying current with industry trends and innovationsProvide training, documentation, and support to users and data teams, promoting the effective use of BI tools, best practices and standardsLead and mentor a team of BI developers, analysts, and data engineers, fostering a collaborative and high-performance work environmentRequirementsMinimum 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 roleExpertise in BI tools such as Power BI, Tableau, or similar platforms; proficiency in SQL, data modeling, and ETL tools like SSIS, Talend, or InformaticaIn-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 servicesExcellent analytical and problem-solving skills, with a strong ability to translate complex data into actionable insightsExperience in establishing data governance frameworks, data quality management, and data security practicesExcellent communication and interpersonal skills, with the ability to explain technical concepts to non-technical stakeholders and lead cross-functional teamsRelevant 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 sponsorshipPreferred RequirementsBased in Chicago, IL and flexible to work from our Chicago office as neededBenefitsFlexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidaysOwn Your Day flexible work policyCompetitive majority employer-paid benefits: Medical, Dental, Vision, 401K MatchEmployee Stock Ownership PlanGenerous maternity/paternity leave optionsCompletely employer paid Life Insurance, STD, LTDCharitable contribution matching programNew client commission opportunities and referral bonus programVideo-free FridaysBike share discount programAbout AAreteAArete 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 StatementAll 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