Senior Business Intelligence Solutions Architect

Magellan Health

3d • $105,230 - $178,890

About The Position

The Senior Business Intelligence Solutions Architect is the hands-on architect and developer responsible for Magellan Health’s enterprise Business Intelligence (BI) semantic layer: governed, reusable data models that make complex warehouse data accessible as consistent, business-friendly metrics for reporting and self-service analytics. The role designs, builds, and maintains semantic-layer data models, business logic, metric definitions, data-level security, and performance and scalability. It defines and applies technical standards for modeling, securing, certifying, documenting, and maintaining BI data sources, and partners with data architecture, BI developers, and business owners to create scalable solutions aligned with enterprise architecture standards.

The architect is the technical owner of published and certified data sources used across the organization. Responsibilities include organizing data from multiple systems into reusable datasets; establishing modeling patterns, naming conventions, documentation, certification criteria, versioning, and change-management practices; managing lifecycle changes and redundant sources; and optimizing connection strategies, refreshes, queries, and warehouse performance as data volumes and user numbers grow. The role also aligns warehouse design with semantic-layer needs, evaluates emerging BI and semantic-layer capabilities—including AI-driven analytics—and recommends adoption approaches.

The position designs and implements row-level security and entitlement models consistent with enterprise security and compliance requirements. It also enables and mentors BI developers and self-service users through documentation, training, and design reviews.

The position may be eligible for short-term incentives and includes a comprehensive benefits package. The stated anticipated base salary range is $105,230 to $178,890; actual pay may vary based on location and job-related factors.

Requirements

• Bachelor’s degree and 7+ years of experience as a Business Intelligence Architect, or a higher-level information technology degree and 5+ years of experience in BI/data architecture.
• Experience designing, implementing, and supporting enterprise-scale data model and reporting systems.
• Proficiency in Hadoop-related tools and technologies, BI technologies, data modeling, and cube design.
• Certification in one of the following: Tableau Certified Data Analyst - Enterprise, Tableau Certified Architect, or Tableau Certified Consultant.
• Combination of technical depth, written and verbal communication skills, and client management skills.
• Bachelor’s degree in Computer and Information Science or Information Technology, or a higher-level information technology degree as described in the experience alternative.

Nice To Haves

• Code development experience with Java, Scala, Python, or Shell.
• Knowledge of distributed systems, data warehousing concepts, complex data pipelines, and data transformation concepts.
• Master’s degree in Computer and Information Science or Information Technology.
• AWS Certified Data Engineer - Associate - Enterprise certification.

Responsibilities

• Architect, build, and maintain the enterprise BI semantic layer and governed, reusable data models and published/certified data sources.
• Organize and connect data from multiple systems into reusable, business-friendly datasets for consistent reporting and insights.
• Establish and enforce semantic-layer standards, including modeling patterns, naming conventions, documentation, certification criteria, versioning, and change management.
• Manage the semantic-layer lifecycle, including impact analysis for upstream data changes and consolidation or retirement of redundant data sources.
• Engineer semantic-layer performance and scalability through connection strategy, refresh design, query optimization, and planning for growing data volumes and users.
• Partner with data engineering and data architecture to align warehouse design with semantic-layer needs.
• Partner with BI developers and business owners to gather requirements and translate them into reusable data-source designs.
• Evaluate emerging semantic-layer and BI capabilities, including AI-driven analytics dependent on governed metrics, and recommend adoption approaches.
• Design and implement data-level security, including row-level security and entitlement models, in accordance with enterprise security and compliance requirements.
• Enable and mentor BI developers and self-service users through documentation, training, and design reviews.
• Comply with applicable security responsibilities, controls, legal, regulatory, contractual, and internal policy requirements.

Benefits

• Comprehensive benefits package
• Health benefits
• Life benefits
• Voluntary benefits
• Other benefits and perks supporting physical, mental, emotional, and financial wellbeing
• May be eligible for short-term incentives

What This Job Offers

• Job Type: Full-time
• Career Level: Senior