Merative · 1 day ago
Senior OLAP Performance Engineer
United States
Full-time
Remote
Senior Level
$175K/yr - $262K/yrMerative is dedicated to supporting the crucial mission of improving health outcomes through data, analytics, and software for the health industry. The Senior OLAP Performance Engineer is responsible for the performance and scalability of the organization’s enterprise OLAP and cube-based analytics platform, focusing on query optimization and performance tuning.
AnalyticsHealth CareInformation TechnologyIT Infrastructure
Responsibilities
Continuously improve and maintain the performance of the OLAP/cube analytics platform through hands-on query tuning, cube optimization, and dashboard performance improvements
Design, prototype, refine, and optimize cubes 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 resource utilization
Assess vendor roadmaps by evaluating new platform capabilities, testing pre-release features, and advising on opportunities to enhance performance and scalability
Serve as the primary troubleshooter for slow-running queries, dashboard inefficiencies, concurrency issues, and refresh delays
Optimize how 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 tenant isolation, predictable performance, and cost efficiency as both user volume and data size grow
Implement and maintain monitoring for cube performance, including query execution patterns, refresh behavior, caching efficiency, and overall environment health
Define baseline performance metrics to detect degradations, conducting release-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
Demonstrate strong ownership and a self-starter mindset in identifying improvement opportunities and driving solutions independently
Guide teams and stakeholders in understanding performance tradeoffs, data modeling decisions, and optimization strategies
Qualification
Required
Extensive hands-on experience with OLAP/cube technologies such as Kyvos, SSAS, Essbase, Kylin, or similar platforms
Expert-level proficiency in MDX with demonstrated ability to diagnose and optimize complex MDX queries
Strong SQL skills and ability to analyze data structures, lineage, and transformations that impact analytical performance
Deep experience in multidimensional OLAP cube and semantic-layer design, including hierarchies, partitions, aggregates, caching strategies, and measure calculations
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
Bachelor's degree in Computer Science, Engineering, Information Systems, or a related technical field required
Preferred
Experience with healthcare data (claims, eligibility, clinical, or member-level analytics) is preferred but not required
Master's degree in a related technical or analytics discipline preferred
Benefits
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!
Company
Merative
Merative is an IT services company that offers products to improve decision-making and performance. It is a sub-organization of IBM.
Founded in 2022
1001-5000 employees
H1B Sponsorship
Merative has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (10)
2024 (5)
2023 (10)
2022 (2)
Funding
Current Stage
Late StageTotal Funding
unknown2022-01-25Acquired
2018-03-29Series A
Leadership Team
Gerry McCarthy
Chief Executive Officer and Board Director
Troy Bailey
Chief Technology Officer
Recent News
citybiz
2025-10-03
2025-09-23
2025-09-15
Company data provided by crunchbase