American RED Cross
Business Intelligence Architect
Statewide, OH
Sponsorship not specified$120k-$140kDetected 2 days ago
PythonData StructuresSQLSnowflakeRedshiftAWSData AnalysisData EngineeringData VisualizationExcelERPProblem Solving
About the role
- 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.
- 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
Responsibilities
- 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.
- 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.
- As a mission-based organization, we believe our team needs great support to do great work.
Requirements
- 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
- Strong SQL and data modeling (star/snowflake schemas), including writing optimized queries and developing scalable views for poofs of concepts
- Row-level security design and implementation across complex data models
Skills
- 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
- 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
- Strong analytical thinking and problem-solving skills
- Ability to translate complex concepts for business users
- Experience working across multiple systems and stakeholder groups
Compensation
- As you care for others, you're cared for with competitive compensation and benefits.
Benefits
- Medical, Dental Vision plans
- Health Spending Accounts & Flexible Spending Accounts
Equal opportunity
- Equal Opportunity employer.
Apply directly at American RED Cross →Create a free account for alerts like thisView American RED Cross immigration profile
This listing is sourced directly from American RED Cross's careers page and normalized into a canonical job model.