Job Description

Hands-on architect and developer of the enterprise Business Intelligence (BI) semantic layer, the governed, reusable data models that turn complex warehouse data into consistent, business-friendly metrics for all BI reporting and self-service analytics. Designs, builds and maintains the semantic layer, including data modeling, business logic and metric definitions, data-level security, and performance and scalability, so that reports and dashboards across the organization are built on a consistent, trusted source of data. Defines and applies the technical standards for how BI data sources are modeled, secured, certified and maintained, and partners with data architecture, BI developers and business owners to turn data requirements into scalable semantic layer solutions aligned with enterprise architectural standards.

• Architects, builds and maintains the enterprise BI semantic layer, serving as the technical owner of the governed, reusable data models and published/certified data sources used across reporting and self-service analytics. Organizes and connects data from multiple systems into reusable, business-friendly datasets that enable consistent reporting and insights. Establishes and enforces semantic layer standards: modeling patterns, naming conventions, documentation, certification criteria, and versioning and change management for data sources. (40%)
• Manages the semantic layer lifecycle, including impact analysis for upstream data changes and consolidation or retirement of redundant data sources. Engineers the semantic layer for performance and scalability, including extract vs. live connection strategy, refresh design, query optimization against the data warehouse, and planning for growing data volumes and users. Partners with data engineering and data architecture to align warehouse design with semantic layer needs, and with BI developers and business owners to gather requirements and turn them into reusable data source designs. Evaluates emerging semantic layer and BI capabilities, including AI-driven analytics that depend on governed metrics, and recommends how to adopt them. (35%)
• Designs and implements data-level security within the semantic layer, including row-level security and entitlement models, in line with enterprise security and compliance requirements. (10%)
• Enables and mentors BI developers and self-service users to build on certified data sources through documentation, training and design reviews. (15%)

Other Job Requirements

Responsibilities

Bachelor's degree and 7+ years experience as Business Intelligence Architect or a higher level information technology degree with 5+ years experience in BI/date architecture.

Experience designing, implementing and supporting enterprise-scale data model & reporting systems.

Proficiency in Hadoop-related tools and technologies, Business Intelligence technologies, data modeling and cube design (Tableau, Qlik, PowerBI, Cognos, MicroStrategy, Business Objects, SSAS).

Code development experience is beneficial (Java, Scala, Python, Shell).

Knowledge of distributed systems, data warehousing concepts, complex data pipelines and data transformation concepts.

Must possess combination of technical depth, written/verbal communication and client management skills.

Certification in one of the following: Tableau Certified Data Analyst - Enterprise, Tableau Certified Architect, or Tableau Certified Consultant.

General Job Information

Title

Senior Business Intelligence Solutions Architect

Grade

30

Work Experience - Required

Analytics/Informatics, Business Intelligence

Work Experience - Preferred

Education - Required

Bachelor's - Computer and Information Science, Bachelor's - Information Technology

Education - Preferred

Master's - Computer and Information Science, Master's - Information Technology

License and Certifications - Required

Tableau Certified Architect - Enterprise, Tableau Certified Consultant - Enterprise, Tableau Certified Data Analyst - Enterprise

License and Certifications - Preferred

AWS - Amazon Web Service Certified Data Engineer - Associate - Enterprise

Salary Range

Salary Minimum:

$105,230

Salary Maximum:

$178,890

This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law.

This position may be eligible for short-term incentives as well as a comprehensive benefits package. Magellan offers a broad range of health, life, voluntary and other benefits and perks that enhance your physical, mental, emotional and financial wellbeing.

Magellan Health, Inc. is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled.

Every employee must understand, comply with and attest to the security responsibilities and security controls unique to their position; and comply with all applicable legal, regulatory, and contractual requirements and internal policies and procedures.