The Business Analyst will develop Excel models, analyze revenue performance, manage operational datasets, and collaborate with teams for strategic insights.
We are seeking a highly analytical and detail-oriented Business Analyst to join our Operations team. This role will be instrumental in driving data-informed decision-making by developing robust Excel-based data models, analyzing revenue performance, and maintaining operational datasets for Professional Services capacity planning and financial tracking.
Key Responsibilities
- Develop and maintain Excel-based data models to support Global Services Capacity Planning.
- Perform in-depth analysis of Revenue Actuals vs Budget, identifying trends, variances, and actionable insights.
- Own and manage all operational datasets to ensure data is accurate, up-to-date, and readily available for ad hoc reporting needs.
- Collaborate with cross-functional teams (Finance, Delivery, HR) to align data inputs and reporting outputs.
- Create dashboards and reports that support strategic planning and operational efficiency.
- Proactively identify data gaps and recommend process improvements to enhance data quality and reporting capabilities.
Qualifications
- Bachelor’s degree in Business, Finance, Operations, or a related field.
- 5+ years of experience in a business analyst, operations analyst, or similar role.
- Advanced proficiency in Microsoft Excel (pivot tables, Power Query, complex formulas, etc.).
- Strong analytical and problem-solving skills with a keen attention to detail.
- Experience working with financial data, capacity models, and operational KPIs.
- Excellent communication skills and the ability to translate data into actionable insights.
Preferred Qualifications
- Experience in Professional Services or SaaS environments.
- Familiarity with BI tools (e.g., Power BI, Tableau) and data visualization best practices.
- Experience with SQL
- Knowledge of Sales, budgeting and forecasting processes.
At Model N we offer fair, equitable and competitive salary ranges for all positions. Compensation varies depending on factors that may include a candidate’s relevant experience, education and/or certifications, location, training, and other skills.
Additionally, Model N offers a robust total rewards package that supports individuals to be their best and protects the well-being of participating dependents. Such benefits include medical, dental, vision, health savings, flexible savings, commuter benefits, matching 401K, PTO, VTO, life insurance, pet insurance, employee assistance programs, mental health programs, charitable giving, coaching, career growth and much more.
The base salary for this position will be $95,000 - $120,000. If your salary expectations are outside of this range, feel free to apply and discuss your expectations with our recruiters. We are constantly opening up new positions and you might match another opening at a different level.
#LI-MN1
Top Skills
Excel
Power BI
SQL
Tableau
Similar Jobs
AdTech • News + Entertainment
The role involves translating operational needs into processes, creating documentation, leading projects, and recommending improvements. Strong analytical skills and detail orientation are essential.
Top Skills:
AirtableJIRAMicrosoft 365 SuitePower BIWorkfront
Healthtech
Responsible for providing strategic insights through data management, analysis, and dashboard implementation to drive revenue and improve customer experience. Collaborates with sales and client success teams to optimize processes and communication with stakeholders.
Top Skills:
ExcelGainsightMs WordPowerPointSalesforce
Other
The Senior Finance & Business Operations Analyst supports the Self-Serve business by providing insights, analyzing data, collaborating across teams, and driving forecasts and initiatives for growth.
Top Skills:
ExcelSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute