Business Intelligence Architect

American Red Cross

IT Business Systems Principal responsible for delivering data and analytics solutions at American Red Cross. Designing architecture for informed decision-making across Finance and enterprise functions.

Posted 7/21/2026full-timeRemote • Ohio • 🇺🇸 United StatesSeniorLead💰 $120,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and delivering scalable data and analytics solutions, with a strong focus on Power BI semantic model design, DAX development, and data architecture. Capable of translating business requirements into technical solutions while ensuring data governance and performance optimization.

Highest-signal resume keywords

Power BI Semantic Model DesignAdvanced DAX ExpertiseData Architecture ExperienceSQL and Data ModelingEnterprise Data Warehouse Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalyticsDAX DevelopmentDimensional ModelingRow-Level Security DesignETL/ELT ProcessesMulti-Source IntegrationsOptimized Query WritingData ModelingPerformance OptimizationData Architecture

Soft Skills

CollaborationCommunicationStakeholder AlignmentProblem SolvingDocumentation

Tools & Technologies

Power BIExcelPythonRedshiftAWS

Industry Keywords

Finance Business ApplicationsData GovernanceData SecurityBusiness IntelligenceData Integration

Tech Stack

Tools & technologies

Amazon RedshiftAWSERPETLPythonSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

Bachelor’s degree required
7+ years of experience in data analytics, BI, or data architecture
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 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
Familiarity with Excel, Python, or other analytics tools

Benefits

Comp & perks

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