Business Intelligence Architect

Job Overview

Joining The American Red Cross is like nothing else – it’s as much something you feel as something you do. You become a vital part of the world’s largest humanitarian network. Joining a team of welcoming individuals who are exceptional, yet unassuming. Diverse, yet uncompromising in unity. You grow your career within a movement that matters, where success is measured in people helped, communities made whole, and individuals equipped to never stop changing lives and situations for the better.

Key Responsibilities

• 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.

Qualifications

• Bachelor’s degree required.
• 7+ years of experience in data analytics, BI, or data architecture.
• Technical Skills:
• 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 proofs of concept.
• Enterprise data warehouse experience (Redshift/AWS or similar).
• 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.

Scope

Individual contributor role leading complex analytics and architecture efforts. Influences enterprise data strategy and Finance technology ecosystem. Balances hands-on development with strategic design and stakeholder engagement.

PAY INFORMATION

The annual salary range for this position is $120,000 - $140,000. We do not offer an annual bonus for this role. Note that American Red Cross salaries are aligned to the specific geographic location in which the work is primarily performed. Other factors that may be used to determine your actual salary may include your specific skills, how many years of experience you have and comparison to other employees already in this role. We will review specific salary information at the time of phone screening based upon your location & experience.

Benefits

For You As a mission-based organization, we believe our team needs great support to do great work. Our comprehensive package includes: Medical, Dental Vision plans Health Spending Accounts & Flexible Spending Accounts PTO: Starting at 15 days a year; based on type of job and tenure Holidays: 11 paid holidays comprised of six core holidays and five floating holidays 401K with up to 6% match Paid Family Leave Employee Assistance Disability and Insurance: Short + Long Term Service Awards and recognition