Magellan Health Logo

Magellan Health

Senior Business Intelligence Solutions Architect

Posted 7 Days Ago
Remote
Hiring Remotely in United States
105K-179K Annually
Senior level
Remote
Hiring Remotely in United States
105K-179K Annually
Senior level
Architects and develops the enterprise BI semantic layer, including governed data models, reusable datasets, business metrics, data-level security, and performance optimization. Establishes modeling, documentation, certification, and lifecycle standards; partners with data engineering, architecture, BI developers, and business owners to deliver scalable reporting solutions. Evaluates emerging BI and AI-driven analytics capabilities, mentors developers and self-service users, and ensures consistent, secure, trusted data across the organization.
The summary above was generated by AI
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.

Similar Jobs

A Minute Ago
In-Office or Remote
59K-96K Annually
Senior level
59K-96K Annually
Senior level
Information Technology • Mobile • Social Impact • Software
Manage and support software implementation projects for clients, coordinating requirements, Agile ceremonies, sprint backlogs, technical delivery, integrations, documentation, training, quality, risks, and stakeholder communications. The role partners with technical teams, vendors, government stakeholders, and public health specialists to deliver CommCare solutions. Responsibilities also include improving project-management practices, supporting capacity building, and using AI-assisted tools for planning, analysis, documentation, and communication.
Top Skills: AgileAsanaCommcareDatabase ManagementEmrExcelJIRALarge Language ModelsScrum
An Hour Ago
Remote or Hybrid
California, USA
Senior level
Senior level
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Leads state and local government affairs across Western markets, including policy monitoring, legislative analysis, advocacy strategy, lobbying, stakeholder engagement, and relationships with elected officials, trade associations, NGOs, and community groups. Partners with internal business functions to align public policy initiatives with enterprise priorities, directs lobbyists and consultants, and serves as a subject matter lead on retail policy issues. The role is based in Sacramento and requires travel up to 40%.
An Hour Ago
Remote or Hybrid
United States
71K-120K Annually
Mid level
71K-120K Annually
Mid level
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Analyzes operational data across payments, fraud, customer service, compliance, and processing to identify trends, anomalies, risks, control gaps, and process breakdowns. Develops predictive monitoring models, dashboards, and exception reports; leads root cause analysis; recommends corrective actions; and helps standardize control reporting for operations and leadership.
Top Skills: Power BIPython

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account