Del Oro Consulting, Inc.

Senior Business Analyst, Advanced Excel

Del Oro Consulting, Inc.

contract

Posted on:

Location Type: Remote

Location: California • United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $65 - $76 per hour

Job Level

Senior

About the role

  • Own, maintain, and enhance a complex Excel-based configuration workbook that supports a global partner program.
  • Redesign and update Excel models and logic as new program rules are released.
  • Build and maintain advanced Excel functions and formulas, including multi-line, nested, and custom logic beyond standard macros and pivot tables.
  • Develop automated workflows and data transformations using advanced Excel features, Power Query, and structured modeling techniques.
  • Partner with business, finance, and operations leaders to gather, document, and validate system and reporting requirements.
  • Translate business needs into functional specifications, user stories, and Jira tickets.
  • Support product and platform enhancements through requirements documentation, mock-ups, and collaboration with IT.
  • Work with IT to translate concepts into Figma wireframes and production-ready solutions.
  • Document business processes, data logic, and configuration rules to ensure continuity and scalability.
  • Serve as a subject matter expert for Excel-based configuration tools and partner data platforms.

Requirements

  • 8+ years of experience in business systems analysis, product support, or a similar senior-level role
  • Expert-level proficiency in Microsoft Excel, including:
  • Advanced, multi-line, nested functions
  • Complex data modeling and validation logic
  • Power Query and advanced automation
  • Demonstrated experience maintaining and enhancing mission-critical Excel-based tools or configuration systems
  • Experience working with multiple data sources and system integrations
  • Proven ability to gather and document business requirements and translate them into technical solutions
  • Experience writing user stories and managing work in Jira
  • Ability to work independently and serve as a primary owner of complex tools and processes
Benefits
  • Medical
  • Dental
  • Vision
  • 401(k) with company match
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Microsoft Exceladvanced functionsmulti-line functionsnested functionsdata modelingvalidation logicPower Queryautomationsystem integrationsbusiness requirements documentation
Soft Skills
independent workcollaborationcommunicationdocumentationproblem-solvingrequirements gatheringvalidationsubject matter expertise