> Markdown version of [/jobs/ext/1834303-business-intelligence-architect](https://www.wearedevelopers.com/jobs/ext/1834303-business-intelligence-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Architect - **Company:** American Red Cross - **Location:** United States - **Experience:** Expert - **Salary:** $120,000.0 - $140,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Amazon Web Services, Business Analytics Applications, Data Analysis, Business Logic, Architectural Patterns, Business Software, Business Systems, Data Architecture, Extract Transform Load (ETL), Data Structures, Data Warehousing, Dimensional Modeling, Document-Oriented Databases, Python (Programming Language), Performance Tuning, Query Optimization, Power BI, Standard Sql, Data Streaming, Systems Integration, Data Analytics, Tools for Reporting, Amazon Redshift - **Published:** July 21, 2026 - **Apply:** https://americanredcross.wd1.myworkdayjobs.com/American_Red_Cross_Careers/job/Statewide-OH/Business-Intelligence-Architect_RC89614 ## About the Role * Bachelor's degree required * 7+ years of experience in data analytics, BI, or data architecture Technical Skills Technical Expertise * 7+ years Power BI experience including semantic model design, DAX development, and performance optimization * 5+ years of data architecture experience with dimensional modeling (star/snowflake schemas) * Expert-level understanding of Power BI semantic models, relationships, calculation groups, aggregations, etc. * Advanced DAX expertise including complex calculations, time intelligence, and performance optimization * Strong SQL and data modeling (star/snowflake schemas), including writing optimized queries and developing scalable views for poofs of concepts * Enterprise data warehouse experience (Redshift/AWS or similar) * Row-level security design and implementation across complex data models * Knowledge of ETL/ELT processes and multi-source integrations and their impact to downstream reporting * Experience with enterprise data warehouses (e.g., AWS Redshift) * Familiarity with Excel, Python, or other analytics tools Core Capabilities * Strong analytical thinking and problem-solving skills * Ability to translate complex concepts for business users * Experience working across multiple systems and stakeholder groups * Proven ability to manage multiple priorities and drive results ## Description The Principal, IT Business Systems will be responsible for designing and delivering scalable, secure, and high-performing data and analytics solutions that enable informed decision-making across Finance and enterprise functions. This role blends data architecture, advanced analytics, and reporting with cross-functional support for all technology solutions managed by the Finance Business Applications team. This individual serves as a strategic partner and subject matter expert, translating business needs into technical solutions while ensuring consistent data definitions, security, governance and standards, optimized performance, and alignment across systems, tools, and stakeholders., Business Requirements Translation and Analytics * Translate business and Finance requirements into technical solutions, data models, semantic layers, and reporting solutions. * Serve as SME for data interpretation, ensuring consistent understanding of metrics across the organization. * Present insights and recommendations and facilitate alignment when stakeholders have differing interpretations of data meaning * Validate that technical implementations accurately represent original business intent * Collaborate with Finance, HR, IT, and other business partners. Data Architecture & Semantic Modeling * Design enterprise Power BI semantic layer architecture, including data models, relationships, and calculation frameworks. * Define standardized business logic, measures, and time intelligence patterns. * Ensure alignment of calculations and metrics across multiple data sources and domains. * Partner with data warehouse teams to support "analytics-ready" data structures. Performance, Security & Integration * Design scalable solutions supporting multi-source data integration. * Implement row-level security and data access controls across user groups. * Optimize performance through aggregation strategies, DAX tuning, and query optimization. * Ensure solutions meet enterprise standards for scalability, reliability, and performance. Cross-Functional Technology Support (Finance Business Applications) * Provide data and analytics support across all Finance-owned technology solutions (e.g., ERP, planning tools, workforce systems, Bi solutions). * Partner with product owners and system leads to ensure reporting, data structures, and integrations support business needs. * Identify opportunities to enhance tools, eliminate redundancies, and improve end-to-end data flows. * Serve as a point of contact for Finance Business Applications solutions. Governance, Standards & Continuous Improvement * Apply enterprise Power BI standards * Establish architectural patterns within enterprise framework * Document architectural decisions, trade-offs, and rationale * Validate implementations against architectural standards through design reviews * Document data definitions, architecture decisions, and solution designs. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)