Business Intelligence Architect

About the Company:

Headquartered in El Segundo, Calif., Internet Brands is a fully integrated online media and software services organization focused on four high-value vertical categories: Health, Automotive, Legal, and Home/Travel. The company's award-winning consumer websites lead their categories and serve more than 250 million monthly visitors, while a full range of web presence offerings has established deep, long-term relationships with SMB and enterprise clients. Internet Brands powerful, proprietary operating platform provides the flexibility and scalability to fuel the company's continued growth. Internet Brands is a portfolio company of KKR and Temasek

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

s.For Company details, visit our websi

comJob Summ

ary:We are seeking a highly skilled and experienced BI Architect to lead the design, development, and optimization of enterprise-wide Business Intelligence solutions. The ideal candidate will have strong technical expertise in Power BI, Azure Data Services, SQL, Excel, and SharePoint to deliver impactful data solutions, dashboards, and reporting frameworks that drive data-driven business decisions. This role will partner closely with key business stakeholders to translate complex data requirements into effective BI soluti

ons.Experi

yearsMust-Have Skills & Qualificat

• ions:5+ years of experience in Business Intelligence and Data Analytics, including experience as a Power BI Architect or Lead Devel
• oper.Strong expertise in Power BI Desktop and Power BI Service: DAX, Power Query (M), Dataflows, Gateways, and Worksp
• aces.Proficiency in SQL: writing complex queries, stored procedures, optimizing performance in SQL Server or Azure SQL Data
• base.Solid experience with Azure Data Services: Azure Data Factory, Azure SQL, Data Lake, Synapse Analy
• tics.Advanced skills in Microsoft Excel, including data modeling, Power Query, and advanced form
• ulas.Hands-on knowledge of SharePoint Online: building dashboards, integrating Power BI reports, and automating workf
• lows.Deep understanding of data modeling techniques (star schema, snowflake schema) and BI architecture best pract
• ices.Strong analytical and problem-solving skills with the ability to work independently and in a team environ
• ment.Excellent communication skills with the ability to translate technical solutions into business v

alue.Preferred Qualificat

• ions:Microsoft certifications in Power BI, Azure Data Engineer, SQL Database, or related fi
• elds.Experience with Power Platform (Power Apps, Power Autom
• ate).Familiarity with CI/CD pipelines, DevOps for BI deploym
• ents.Knowledge of Agile/Scrum methodologies for project deli

very.Key Responsibili

• ties:Architect and design scalable, maintainable Power BI solutions, including datasets, dataflows, dashboards, and paginated rep
• orts.Build and manage Azure Data Services (Data Factory, Azure SQL, Data Lake, Synapse) for robust ETL/ELT proce
• sses.Develop advanced SQL queries, stored procedures, and scripts to support efficient data transformation and mode
• ling.Create dynamic Excel models and analytical tools for operational reporting and decision sup
• port.Design and manage SharePoint dashboards, lists, and collaborative BI environments with integration to Powe
• r BI.Lead workshops and requirements sessions with business users to develop clear reporting objectives and
• KPIs.Develop and maintain optimized data models with efficient DAX calculations and Power Query (M) transformat
• ions.Implement data governance policies, role-level security, and audit controls in BI platf
• orms.Conduct performance tuning of BI reports and SQL queries to ensure optimal report refresh t
• imes.Promote BI adoption across the organization through user training and best practice sha