United States
Full time
R00000071299
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.
Magellan is the employer of choice for hard working people interested in making a difference in the health care industry and in the communities where we work and live. Our strong culture of caring is the common thread in both our business strategy and our work environment. We value professional growth and development, total health and wellness, rewards and recognition as well as employee unity. Magellan is a place where you can thrive.
Magellan is committed to providing equal employment opportunities to employees and applicants for employment without regard to race, color, creed, religion, sex, gender identity and expression, sexual orientation, marital status, age, national origin, ancestry, citizenship, physical or mental disability, disabled veteran or veteran of the Vietnam Era status, or any other factors protected by law.
Magellan is committed to meeting applicable Federal labor and employment law posting requirements by providing necessary posters in a format which is easily accessible and conspicuous to all applicants. Copies of applicable posters are accessible by clicking here (https://www.magellanhealth.com/media/760295/mg-federal-contractors-applicant-english.pdf) .
Warning: Employment Scam
It has come to our attention that a false representative is contacting potential candidates and offering them work at home positions with Magellan Health. "Interviews" are conducted completely through email and the false job offer includes the promise of a check to be issued to the candidate for the purposes of setting up a home office.
Please know that Magellan Health does not interview any candidate through email, nor do we issue checks to candidates to set up home offices. All of our available positions are posted on legitimate job boards and our recruitment team directly contacts candidates should there be a fit.
If you suspect you are being contacted by a false representative of Magellan Health, please call 410-953-2911