Data & Business Intelligence Analyst

Prominent Environmental Services Company

Data & Business Intelligence Analyst

About Our Company

We are a leading provider of essential environmental and site services throughout Southern California. For over 25 years, we have been family owned and operated, proudly serving customers across the construction, special events, commercial, industrial, and residential markets. Our decades of delivering superior service have set us apart from our competitors, with a commitment to being there when our customers need us most – including providing responsive, dependable, on-demand emergency services when critical needs arise.

With multiple locations throughout California, our company provides a broad range of services, including portable restrooms, temporary fencing and power, pumping services, restroom and shower trailers, and related site services. We are seeking an analytical, technically capable, and business-minded Data & Business Intelligence Analyst to join our team. This individual will play an important role in developing and strengthening the company’s data reporting and analytics capabilities by extracting, integrating, analyzing, and transforming data from our operational systems, call center phone platform, and other business applications into meaningful, actionable business intelligence.

Position Summary

The Data & Business Intelligence Analyst develops and improves the company’s reporting, analytics, and business intelligence capabilities. This hands-on role works directly with source data. Initial priorities are the Tower AMCS operational platform and call center phone system.

TO APPLY PLEASE CLICK ON THE LINK: Data & Business Intelligence Analyst – San Marcos, CA 92069 – Indeed.com

Key Responsibilities

Data Extraction, Integration & Management

• Access data from Tower AMCS, the call center phone system, and other applications using SQL, database connections, APIs, exports, and other available methods.
• Combine data from multiple systems into useful, integrated datasets.
• Clean, transform, validate, and reconcile data; investigate inconsistencies with relevant departments.
• Document data sources, calculations, business rules, and processes.

Business Intelligence & Reporting

• Provide visibility into operational performance, customer service, productivity, revenue, costs, and key business metrics across locations, teams, customers, and service lines.
• Respond to ad hoc reporting requests and continuously improve reporting accuracy, usefulness, accessibility, and efficiency.

Call Center Analytics

• Develop reporting on call volumes, service levels, speed to answer, abandonment rates, average handle time, and other available measures.
• Analyze customer service and order-processing activity to identify trends, recurring issues, and improvement opportunities.

Business Analysis & Process Improvement

• Communicate findings, trends, and recommendations clearly to ownership and management.
• Reduce manual spreadsheet work, standardize reporting processes, and establish scalable solutions that support company growth.

Required Qualifications

• Approximately 3–5 years of experience in data analytics, business intelligence, reporting, or a related technical field.
• Strong SQL skills, including querying, joining tables, aggregating data, investigating discrepancies, and preparing datasets for analysis.
• Experience extracting, cleaning, transforming, validating, and integrating data from multiple business systems.
• Strong Excel and data-analysis skills, with excellent attention to detail and a commitment to data accuracy and consistency.
• Self-directed work style, with the ability to take ownership, work independently, and proactively identify improvements.
• Collaborative approach and ability to explain technical concepts and business implications in clear, practical language.

Preferred Qualifications

• Experience working with ERP, Oracle Cloud stack, Database, Data & AI, Crystal Reports, field service management, waste management, equipment rental, logistics, transportation, or other operational business systems. Comparative expertise in Microsoft SQL and Dynamics 365 considered a plus.
• Experience with AMCS products or Tower AMCS specifically.
• Experience integrating data from call center systems, CRM platforms, workforce management systems, or customer service applications.
• Familiarity with APIs, database connectors, scheduled exports, ETL/ELT processes, automated data pipelines, data warehouses, or centralized reporting datasets.
• Experience with Microsoft SQL, Dynamics 365, Oracle Cloud, Crystal Reports, Python, or other scripting languages.
• Bachelor’s degree in Data Analytics, Business Analytics, Information Systems, Computer Science, Finance, or a related field preferred.

Leadership Profile

The successful candidate will be:

• Analytical and technically capable: Investigates data, identifies patterns, writes SQL queries, transforms datasets, and develops dependable reporting solutions.
• Business-minded and detail-oriented: Understands how reporting supports business performance and prioritizes data accuracy, validation, and consistent methodologies.
• Curious and proactive: Challenges assumptions, investigates anomalies, and identifies opportunities for improvement.
• Accountable and process-oriented: Takes ownership of deliverables, meets commitments, and looks for ways to automate repetitive work and improve consistency.
• Collaborative and communicative: Builds productive cross-functional relationships and translates complex findings into understandable, actionable insights.
• Committed to continuous improvement: Consistently strengthens reporting capabilities, data quality, and management decision-making.

Why Join Us?

This is an opportunity to join a growing organization and play a meaningful role in strengthening how the company uses data to understand performance, solve problems, and make decisions.

If you are a technically capable, analytical professional who enjoys working with source data, solving business problems, building useful reporting solutions, and turning information into actionable insights, we would love to hear from you.

Diamond Services is an Equal Opportunity Employer and is committed to providing equal employment opportunities to all qualified applicants and employees. Employment decisions are made without regard to any characteristic protected by applicable federal, state, or local law.

Location: This is an onsite position based in San Marcos, California.

Industry: Environmental Services, Equipment Rental & Field Services

Employment Type: Full-Time, Exempt

Pay: $85,000.00 – $95,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance