United States onlyJoin a team dedicated to supporting the crucial mission of improving health outcomes.
At Merative, you can apply your skills – and grow new ones – with colleagues who have deep expertise in health and technology. Merative provides data, analytics and software for the health industry. Our clients include providers, health plans, employers, life sciences companies and governments around the world. With industry-leading products and focused innovation, we help customers improve decision-making and performance so that together, we drive real progress in health. Learn more at merative.com
About UsTruven is a platform offering real-world data, healthcare analytics, and member engagement solutions to help improve health and financial outcomes. We offer a deep understanding of the healthcare industry and time-tested processes to ensure precise, accurate insights. Truven provides information, analytic tools, benchmarks, research, and services to a variety of healthcare organizations. Our mission is to enable smarter decisions, reduce inefficiencies, and improve patient outcomes across the healthcare ecosystem. Learn more at merative.com
Role Overview
The Senior OLAP Performance Engineer is a hands-on expert responsible for the performance and scalability of the organization’s enterprise OLAP and cube-based analytics platform. This role focuses on deep MDX tuning, query optimization, dashboard performance tuning, and evaluating new platform capabilities. The ideal candidate is a self-starter with strong problem‑solving skills and a passion for diagnosing complex analytical performance challenges.
Key Responsibilities
Platform Performance & Optimization
Continuously improve andmaintainthe performanceof the OLAP/cube analytics platform through hands-on query tuning, cube optimization, and dashboard performance improvements.
Design, prototype, refine, andoptimizecubes and semantic-layer structures, including hierarchies, partitions, aggregates, caches, and precomputed measures.
Proactively analyze and resolve performance bottlenecks by evaluating query execution patterns,underlying data structures,and resourceutilization.
Assessvendor roadmaps by evaluating new platform capabilities, testing pre‑release features, andadvising onopportunities to enhance performance and scalability.
Serve as the primary troubleshooter for slow-running queries, dashboard inefficiencies, concurrency issues, and refresh delays.
Optimizehow BI/reporting tools connect to and query the OLAP layer by improving semantic structures and query paths.
Ensure the OLAP platform scales effectively in a multi-tenant environment,preserving tenantisolation, predictable performance, and cost efficiency asboth uservolume and data size grow.
Monitoring, Operations & Release Management
Implement andmaintainmonitoring for cube performance, including query execution patterns, refresh behavior, caching efficiency, and overall environment health.
Define baseline performance metrics to detect degradations,conductingrelease-over-release performance analysis for platform upgrades, feature enhancements, and cross-team validation efforts.
Document performance findings, tuning techniques, and troubleshooting approaches to support knowledge sharing and consistent problem-solving.
Leadership & Problem Solving
Demonstrate strong ownership and a self-starter mindset inidentifyingimprovement opportunities and driving solutions independently.
Guide teams and stakeholders in understanding performance tradeoffs, data modeling decisions, and optimization strategies.
Required Qualifications
Extensive hands-on experience with OLAP/cube technologies such asKyvos,SSAS, Essbase, Kylin, or similar platforms.
Expert-levelproficiencyin MDX withdemonstratedability to diagnose andoptimizecomplex MDX queries.
Strong SQL skills and ability to analyze data structures, lineage, and transformations thatimpactanalytical performance.
Deepexperience in multidimensional OLAP cube and semantic-layer design, including hierarchies, partitions, aggregates, caching strategies, andmeasurecalculations.
Proven ability to troubleshoot and tune large-scale analytical workloads, including cube refresh performance and concurrency issues.
Experience with distributed environments such as Spark, Databricks, Hive, or Presto, and columnar storage formats such as Parquet,or ORC.
Hands-on experience in cloud environments (Azure strongly preferred), including VM tuning, ADLS optimization, and observability tooling.
Strong understanding of ETL/ELT pipelines and ability to reshape or precompute data to achieve required performance.
Excellent communication skills with the ability to articulate technical decisions and performance tradeoffs.
Experience with healthcare data (claims, eligibility, clinical,ormember-level analytics) ispreferredbut notrequired.
Education
Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related technical fieldrequired.
Master’s degree in a related technical or analytics discipline preferred.
Travel
Occasional travel may berequiredfor team collaboration or project support.
Compensation
The salary range provided in this job posting is intended to reflect the general market value for the position. The actual salary offered may vary based on factors such as the candidate’s experience, qualifications, skills, and the specific requirements of the role. This range may also be subject to change as market conditions evolve. We encourage open communication throughout the interview process to discuss compensation expectations. For base-salary + commission sales roles, the range represents On-Target Earnings.
Min – Max :
$174,688.00 - $262,032.00 (USD)Benefits
The benefits described represent the current offerings at our organization, however, benefits are subject to change and may vary by location and employment status. We strive to provide a comprehensive benefits package that supports our employees’ health, wellness, and financial goals. Please note that benefits may be discussed in more detail during the hiring process.
Remote first / work from home culture
Flexible vacation to help you rest, recharge, and connect with loved ones
Paid leave benefits
Health, dental, and vision insurance
401k retirement savings plan
Infertility benefits
Tuition reimbursement, life insurance, EAP – and more!
It is the policy of Merative to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, Merative will provide reasonable accommodations for qualified individuals with disabilities.
Merative participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here: http://www.uscis.gov/e-verify/employees
CA, IN + 1 more