Operations Data Analyst

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 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. #J-18808-Ljbffr Landsystems - A Monarch Landscape Company