Operations Data Analyst

MONARCH LANDSCAPE COMPANIES

Monarch Landscape Companies is a family of successful landscape brands in eight states across the United States. We are a values-based learning organization committed to being the best place to work as a landscape professional. At Monarch Landscape Companies, your achievements determine your rewards, your abilities define your success, and your professionalism leads to autonomy!

Position Summary

Monarch Landscape is seeking a highly technical and business-focused Data Analyst to join the team at our corporate headquarters in downtown Los Angeles. This is a full-time, on-site role dedicated to compiling, analyzing, and presenting operational data to support strategic decision-making and drive performance across the organization. The ideal candidate will be passionate about data, comfortable navigating both modern and legacy systems, and able to translate complex datasets into actionable insights that support labor planning, revenue tracking, backlog visibility, and operational throughput.

Qualifications

• Bachelor's degree in Data Analytics, Statistics, Business Intelligence, or related field.
• 3+ years of experience in data analysis, preferably in operations, field services, or landscape maintenance.
• Expert-level Excel skills and comfort working with legacy systems and flat file data.
• Experience with financial and labor planning data, including budget vs. actuals and forecast modeling.
• Strong communication skills and ability to work cross-functionally.

Preferred Skills

• Familiarity with landscape maintenance operations or ancillary services.
• Experience with backlog management and labor optimization.
• Ability to work independently and collaboratively in a fast-paced, data-driven environment.
• Exposure to customer compliance dashboards, SOW repositories, and CSA score correlation tools.

Key Responsibilities

Data Compilation & Reporting

• Aggregate and structure data from multiple internal operating systems.
• Build recurring and ad hoc reports that support labor planning, revenue tracking, backlog visibility, and throughput analysis.
• Develop workarounds and integrations for legacy systems and flat files to ensure complete and accurate data views.
• Learn and adapt to legacy platforms and data environments; prior experience is not required, but a willingness to learn is essential.

Advanced Analytics & Technical Skills

• Excel Mastery

• Advanced use of pivot tables, Power Query, Power Pivot, and data modeling

• Complex formula writing including INDEX/MATCH, XLOOKUP, array formulas, and nested logic

• Experience with macros, VBA scripting, and automation techniques

• Ability to build interactive dashboards, scenario models, and multi-tab reporting workbooks with structured formatting

• Business Intelligence Tools

• Experience with Power BI: building dashboards, data transformations, DAX calculations, and publishing reports to workspaces

• Familiarity with Tableau: creating visualizations, calculated fields, and interactive dashboards

• Comfort with Google Data Studio, Looker, or other visualization platforms is a plus

• Data Integration & Governance

• Ability to extract and reconcile data from legacy and modern systems

• Strong attention to detail and data hygiene

• Experience with version control and documentation of data workflows

• Identify inconsistencies, gaps, and anomalies in datasets and resolve them proactively

Operational Insights & Business Support

• Analyze performance trends and identify variances between budget, projections, and actuals.
• Provide actionable insights to improve crew utilization, job sequencing, and service consistency.
• Collaborate with field and corporate teams to support labor alignment, revenue recovery, and strategic planning.
• Support initiatives such as CSA score analysis, SOW compliance tracking, and labor ROI modeling.

Workbook & Slide Deck Development

• Build and maintain structured Excel workbooks with color-coded tabs and standardized table formats for operational reporting.
• Create and update slide decks for leadership meetings, performance reviews, and strategic planning sessions.
• Ensure visual consistency and clarity across reporting materials used by field and executive teams.

Technical Writing & Documentation

• Document data workflows, reporting logic, and system integrations clearly and concisely.
• Write process guides, SOPs, and instructional materials for internal use.
• Contribute to the development of training content and onboarding materials for analytics tools and reporting standards.

Visualization & Communication

• Create compelling visualizations and presentations using Excel, PowerPoint, and BI tools.
• Translate complex datasets into business-friendly narratives for leadership and field teams.
• Contribute to executive reporting and performance reviews with data-backed insights.

Total Rewards

At Monarch, we strive to deliver a Total Rewards package that will attract, engage, and retain top talent. Elements of our Total Rewards package include competitive base pay and variable compensation opportunities.

Monarch also provides eligible employees with an array of additional benefits, including:

• The opportunity to enroll in a variety of healthcare benefit programs, including medical, dental, and vision plan options; flexible spending accounts; retirement savings plans; term life/ad&d; and a number of supplemental insurances
• Company Provided Life/AD&D
• Employee Assistance Program
• 6 Paid Holidays
• 3 Days Paid Bereavement
• 5 Days Paid Jury Duty
• Employee Equity Program
• Paid Time Off Plan
• On-Demand Pay Through A Partnership with DailyPay
• Referral Bonuses Programs
• Gym Membership and Mobile Carrier Discounts
• Education Assistance
• Best-in-Class Learning Management System
• Career Advancement Opportunities

The specific programs and options available to any given employee may vary depending on eligibility factors such as position, tenure, geographic location, and the applicability of collective bargaining agreements.

Please note that the salary information shown below is provided in compliance with state specific laws. Salaries are based upon candidate experience and qualifications, as well as market and business considerations, and therefore may be different in other locations or operating divisions.

Pay Range: $75,000 - $80,000

Monarch Landscape Companies is an EEO and E-Verify participating employer.

Monarch Landscape Companies is an On Demand Daily Pay employer.