Business Intelligence Architect

🔥 1 hour ago

🏈 Ohio – Remote

🏈 Ohio – Remote

💵 $120k - $140k / year

⏰ Full Time

🟠 Senior

🔴 Lead

📚 Business Intelligence Analyst

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

American Red Cross

WebsiteLinkedInAll Job Openings

10,000+ employees

🤲 Charity

🌍 Social Impact

📚 Education

Charity • Social Impact • Education

American Red Cross is a humanitarian organization dedicated to providing relief to those in need, offering services such as disaster relief, blood donation, training in first aid and CPR, and support for military families. Their mission encompasses emergency preparedness, education, and providing assistance to individuals affected by various crises, ensuring a safe and resilient community.

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

• 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

• 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