Apply on Employer Site

tms · 17 hours ago

Oracle Essbase Consultant – Databricks Migration

United States

Contract

Remote

Mid Level

TMS LLC is seeking a highly skilled Oracle Essbase Consultant for a Databricks migration initiative. The role involves hands-on Essbase data integration work, as well as the migration and modernization of existing Essbase workloads into Databricks.

AdvertisingProfessional ServicesMarketingBusiness DevelopmentMarket Research

H1B Sponsor Likely

Responsibilities

Perform hands-on data integration and maintenance activities in Oracle Essbase

Support and manage BSO and ASO cubes

Analyze existing Essbase workloads and identify candidates for migration

Migrate and replace selected Essbase workloads with Databricks-based solutions

Design and validate data models and transformations during migration

Develop and optimize SQL queries for data analysis and reconciliation

Collaborate with data engineering, analytics, and business teams

Ensure data accuracy, performance, and scalability post-migration

Document migration processes, mappings, and best practices

Qualification

Oracle EssbaseBSOASO cubesSQLEssbase data integration toolsDatabricksData analysisCommunication skillsDocumentation skills

Required

Strong hands-on experience with Oracle Essbase

Proven experience with BSO (Block Storage Option) and ASO (Aggregate Storage Option) cubes

Experience with Essbase data integration tools

Strong SQL and data analysis skills

Ability to work independently while collaborating with cross-functional teams

Strong communication and documentation skills

Preferred

Experience with Databricks and cloud-based data platforms

Prior experience migrating legacy OLAP systems to modern analytics platforms

Knowledge of data warehousing and ETL frameworks

Company

tms

Glassdoor3.9

tms unites technology and marketing and sourcing to drive transformational change for the world’s leading brands.

Founded in 1986

Chicago, Illinois, USA

1001-5000 employees

https://themarketingstore.com

H1B Sponsorship

tms 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

2024 (2)

Funding

Current Stage

Late Stage

Leadership Team

Chuck McDonough

Chief Financial Officer

James Eby

Sr. Vice President, Chief Creative Officer

Company data provided by crunchbase