Senior OLAP Cube Developer

Are you ready to build the future of our company?

About Mercury Financial

Mercury Financial is an innovative and growing financial services company with locations in both Austin, TX and Wilmington, DE. Our mission is to help customers build and maintain their financial future by offering them credit cards they can afford and understand. After only a few years, we've had great success building a significant credit card program, but we are aiming higher, which means we have lots of challenging problems for you to help us solve. Come onboard, work with some of the most talented individuals who thrive on collaboration and teamwork; and help us continue to build something special.

Location

Mercury Financial is headquartered in the progressive and entrepreneurial tech hub of Austin, Texas. Our physical location is situated in a beautiful park like setting called the Domain. The Domain's ideal location and exceptional amenities, amazing restaurant selection and convenient parking, are all perfect for after work happy hours!

Or,

Mercury Financials' Wilmington, Delaware office is located near the Riverfront. Wilmington is Delaware's largest city and is the economic engine of the state. The Riverfront combines its rich history with a host of attractions that bring great food, entertainment, and shopping to our city. Based on its convenient location, direct access to I-95, Amtrak and SEPTA, this location allows our employees the flexibility to live in a variety of the surrounding areas.

What it's like to work here:

We foster a collaborative and innovative culture where you will be empowered to do your best work. All of our employees bring everything they have to their job and are part of a larger team working towards a greater goal. We do right by our employees, our partners, and our customers.

Role:This role is perfect for an experienced OLAP developer who thrives on creating impactful, high-performing analytical solutions. If you are passionate about delivering optimized cube designs that drive business insights, we encourage you to apply!

What a day is like:

• Design, develop, and implement scalable and usable OLAP cubes to support complex business analytics needs.
• Transform existing processes and workflows into optimized OLAP cube solutions.
• Take business requirements and translate them into well-designed OLAP cubes that meet stakeholder needs.
• Modify and enhance existing cubes to meet evolving business requirements and performance standards.
• Continuously improve cube design to balance optimization and usability for business users.
• Assess and implement cube optimization strategies, ensuring they align with business goals and analytical needs.
• Perform performance tuning and troubleshooting of cubes to ensure efficient data retrieval and processing.
• Conduct thorough QA testing on cube solutions to ensure data accuracy, integrity, and consistency.
• Implement validation processes and troubleshoot discrepancies to maintain high-quality deliverables.
• Work closely with business analysts, data engineers, and other stakeholders to gather requirements and deliver effective cube solutions.
• Partner with Tableau and other self-service BI tool resources to ensure cubes are designed for seamless integration and usability in self-service environments.
• Create and maintain detailed documentation for cube designs, processes, and updates.
• Provide support and training to users on cube functionalities and best practices.

You're perfect for this role if you have:

• Proven experience in developing, managing, and optimizing OLAP cubes using tools such as Microsoft SQL Server Analysis Services (SSAS) or similar platforms
• Strong understanding of multidimensional and tabular models, with the ability to translate business processes into efficient cube designs
• Excellent interpersonal and communication skills to work effectively with cross-functional teams, including business users and technical stakeholders
• Data Visualization Integration: Familiarity with self-service BI tools such as Tableau, with experience designing cubes for seamless integration
• Strong QA and testing skills to ensure data accuracy, reliability, and performance
• Ability to troubleshoot and resolve cube-related issues efficiently, balancing performance with business requirements.

Preferred Qualifications:

• Experience with data warehousing and ETL processes to support cube creation and optimization.
• Familiarity with Tableau or other visualization tools to enable self-service analytics.
• Knowledge of advanced cube features such as partitions, aggregations, and calculated measures.

Why you'll like working here:

This isn't a place where you will fill a seat and keep your head down. This is a place where everybody is expected to help build something. This is a place where you can be involved and lead in your areas of expertise. So, how much do you believe in yourself? If you believe in your skills, in your drive and determination, we'll give you the resources and room to show the world what you can do. Here are just a few of the benefits we offer:

• Employer insurance coverage for employee & dependents
• Life insurance
• 401K with generous employer match
• Wellness program
• Monthly Company Events
• Hybrid Work Model

Mercury Financial is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, among other things, or status as a qualified individual with disability.