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.
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.
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.
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
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
Experience with Power BI: building dashboards, data transformations, DAX calculations, and publishing reports to workspaces
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
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
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
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.
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.
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.
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
• Paid Time Off Plan
On-Demand Pay Through A Partnership with DailyPay
• Referral Bonuses Programs
Gym Membership and Mobile Carrier Discounts
Education Assistance
• 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.
