Operations Data Analyst

Landsystems - A Monarch Landscape Company; Los Angeles (CA); On-site; USD 75,000 - 80,000; Full time

Benefits offered by this job

Healthcare benefits

Equity program

Paid time off

DailyPay / On-Demand Pay

Education assistance

Life/AD&D coverage

Job summary

Monarch Landscape Companies in Los Angeles is seeking a highly technical Data Analyst to join our corporate headquarters team. This full-time, on-site role focuses on compiling, analyzing, and presenting operational data to support strategic decisions.

The ideal candidate will translate complex datasets into actionable insights for labor planning, revenue tracking, backlog visibility, and throughput, while developing scalable, automated reporting to improve data quality and standardization

Qualifications

• Bachelor's degree in Data Analytics, Statistics, BI, CS, IS, or related field.
• 3+ years of data analysis experience, preferably in operations, field services, or landscape maintenance.
• Expert-level Excel skills and comfort with legacy systems and flat-file data.
• Proficiency with Python and SQL for queries, data transformation, and integration.
• Experience with financial and labor planning data, including budget vs. actuals and forecasts.
• Strong data transformation, data quality, and reporting knowledge.
• Strong cross-functional communication with technical and non-technical stakeholders.

Responsibilities

• Aggregate, structure, and reconcile data from multiple internal operating systems.
• Build recurring and ad hoc reports to support labor planning, revenue tracking, backlog visibility, and throughput analysis.
• Develop automated processes and integrations for legacy systems and flat files.
• Learn and adapt to legacy platforms; willingness to learn is essential.
• Identify opportunities to replace manual reporting with automated, standardized solutions.
• Translate analytical findings into practical recommendations for operational and financial performance.

Skills

Excel Mastery

Python

SQL

Data analysis

Data modeling

Communication

Education

Bachelor's degree in Data Analytics or related field

Tools

Power BI

Tableau

Looker

Google Data Studio

Job description

Monarch Landscape Companiesis 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 Companies 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. This role will also help advance Monarch's data capabilities by developing scalable solutions that reduce manual reporting, improve data quality, and create more standardized and reliable processes across the organization.

Qualifications

• Bachelor's degree in Data Analytics, Statistics, Business Intelligence, Computer Science, Information Systems, or a 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.
• Working experience with Python and SQL, with the ability to develop queries, transform data, automate processes, and support data integration.
• Experience with financial and labor planning data, including budget vs. actuals and forecast modeling.
• Strong understanding of data transformation, data quality, and reporting processes.
• Strong communication skills and ability to work cross-functionally with technical and non-technical stakeholders.

Preferred Skills

• Familiarity with landscape maintenance operations or ancillary services.
• Experience with backlog management and labor optimization.
• Experience building automated reporting workflows or data pipelines.
• Experience working with multiple source systems and integrating disparate datasets.
• Knowledge of data engineering concepts, including ETL/ELT processes, data modeling, and data governance.
• 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, structure, and reconcile 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, integrations, and automated processes 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.
• Identify opportunities to replace manual reporting processes with standardized, automated, and repeatable solutions.

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.

Python & SQL

• Develop and maintain advanced capabilities in Python and SQL to support data analysis, transformation, automation, and integration across multiple systems.
• Write and optimize SQL queries to extract, join, validate, and analyze data from multiple sources.
• Use Python to automate recurring reporting, data preparation, validation, and workflow processes.
• Develop reusable scripts and tools that reduce manual data manipulation and improve reporting efficiency.
• Apply Python and SQL to identify data quality issues, reconcile datasets, and support scalable analytical solutions.
• Continuously expand technical capabilities to improve the organization's ability to move from manual analysis toward automated and standardized data processes.

Business Intelligence Tools

• Experience with Power BI, including building dashboards, data transformations, DAX calculations, and publishing reports to workspaces.
• Familiarity with Tableau, including creating visualizations, calculated fields, and interactive dashboards.
• Comfort with Google Data Studio, Looker, or other visualization platforms is a plus.
• Integrate data across multiple modern and legacy systems to create consistent and reliable reporting.
• Develop and maintain data transformation processes that prepare information for analysis, reporting, and business intelligence.
• Support the development of scalable, repeatable data pipelines and workflows.
• Automate recurring data preparation, reporting, and validation processes where appropriate.
• Establish and maintain data quality checks to identify inconsistencies, gaps, duplicates, and anomalies.
• Improve data governance by documenting data sources, definitions, business rules, transformations, and reporting logic.
• Maintain clear documentation and version control for data workflows, scripts, reporting processes, and system integrations.
• Work proactively to improve data reliability, accessibility, and consistency across reporting environments.
• Help transition information and reporting processes from manual, person-dependent workflows to standardized, governed, and repeatable processes.

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.
• Translate analytical findings into practical recommendations that support operational and financial performance.

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.
• Develop reporting templates and standardized outputs that can be consistently used across teams and operating divisions.

Technical Writing & Documentation

• Document data workflows, reporting logic, data transformations, and system integrations clearly and concisely.
• Document Python scripts, SQL queries, automated workflows, and data processes to support continuity and scalability.
• 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.
• Maintain clear documentation of data definitions, calculations, assumptions, and reporting methodologies.
• Create compelling visualizations and presentations using Excel, PowerPoint, and BI tools.
• Translate complex datasets into business-friendly narratives for leadership and field teams.
• Communicate technical concepts and analytical findings clearly to both technical and non-technical audiences.
• Contribute to executive reporting and performance reviews with data-backed insights.
• Partner with stakeholders to understand business needs and translate them into effective analytical and reporting solutions.

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
• Gym Membership and Mobile Carrier Discounts
• Education Assistance

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.