Data & BI Analyst: Drive Operational Insights

Diamond Fence Co.; San Marcos (CA); On-site; USD 85,000 - 95,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Health insurance

Paid time off

Vision insurance

Job summary

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.

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.

Responsibilities

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

Skills

SQL

Excel

Data analytics

Analytical thinking

Communication

Independent work

Cross-functional collaboration

Education

Bachelor’s degree in related field

Tools

AMCS Tower

Oracle Cloud

Crystal Reports

Python

Dynamics 365

Job description

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.