Data & Business Intelligence Analyst

Diamond Fence Co.; San Marcos (CA); Vor Ort; USD 85.000 - 95.000; Vollzeit

Benefits dieser Stelle

401(k)

Dental insurance

Health insurance

Paid time off

Vision insurance

Zusammenfassung

Diamond Environmental Services LP in California is hiring a Data & BI Analyst to develop and enhance reporting, analytics, and business intelligence capabilities. You will work directly with source data from Tower AMCS, call center systems, and other business applications to create actionable insights for ownership and management.

Responsibilities include data extraction, integration, and governance, building scalable dashboards, and analyzing call center metrics.

Qualifikationen

• 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.

Aufgaben

• Data Extraction, Integration & Management: Access data from Tower AMCS, the call center system, and other applications using SQL and APIs.
• Combine data from multiple systems into integrated datasets and ensure data quality.
• Document data sources, calculations, and business rules for governance.
• Business Intelligence & Reporting: Provide visibility into performance, service levels, and key metrics across locations and teams.
• Respond to ad hoc reporting requests and improve reporting accuracy and accessibility.
• Call Center Analytics: Develop reporting on call volumes, service levels, average handle time, and related measures.
• Analyze customer service activity to identify trends and improvement opportunities.
• Business Analysis & Process Improvement: Communicate findings to leadership, reduce manual work, and automate reporting processes.
• Leadership Profile: Analytical, business-minded, proactive, collaborative, and committed to continuous improvement.

Kenntnisse

SQL

Excel

Data analytics

Analytical thinking

Communication

Independent work

Cross-functional collaboration

Ausbildung

Bachelor’s degree in related field

Tools

AMCS Tower

Oracle Cloud

Crystal Reports

Python

Dynamics 365

Jobbeschreibung

Data & Business Intelligence Analyst

Locations: Select Location

Categories: Admin Apply Home / Jobs / Data & Business Intelligence Analyst

Job Description

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.

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

***APPLICANT MUST SUBMIT DMV K4 PRINTOUT DATED WITHIN THE LAST 30 DAYS WHEN APPLYING TO BE CONSIDERED***

WE ARE AN EQUAL OPPORTUNITY EMPLOYER.

About Diamond Environmental Services LP:

Diamond Environmental Services is an Essential Sanitation service to critical infrastructure work forconstruction, energy, waste, and healthcare industries and government sites. We are open and operating with thesafety of our employees and customers coming first and foremost.

With over 20 years industry experience Diamond Environmental Services has become one of Southern California'spremier portable sanitation companies. With Locations serving the counties of San Diego, Riverside, and Orange,San Bernardino and Los Angeles, we provide all types of portable sanitation services and temporary fencing to bothcommercial and residential customers.