Data & Analytics Lead

TPS MEDIA CORP
Monterey Park, CA, United States
2 days ago
Apply on jobs.gogpac.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$120,000.0 - $180,000.0
Working hours
Regular working hours

Tech stack

Application Programming Interfaces (APIs) Audit Trail Microsoft Azure BigQuery Business Systems Data Security Data Warehousing Database Queries Fraud Prevention and Detection Python (Programming Language) SQL Azure Power BI
+7 more
Systems Integration Data Processing Data Ingestion Data Layers Data Analytics Data Pipelines Databricks

Job description

  • Build and maintain a data warehouse or lake integrating internal systems, including policy, claims, quoting, and transportation management, with external carrier feeds, partner APIs, and performance data.
  • Develop reliable data pipelines, transformations, data models, and documented workflows.
  • Establish consistent, governed metrics and a self-service reporting environment using Power BI and related tools.
  • Deliver data insights directly into internal applications and claims systems through embedded reporting or APIs.
  • Develop alerts to identify emerging loss trends by carrier, shipping lane, commodity, and partner.
  • Analyze claims, loss frequency, severity, and other performance metrics to help teams identify risks earlier.
  • Direct offshore analysts and engineers through clear specifications, quality reviews, and delivery standards.
  • Implement data security controls, including access restrictions, masking, environment separation, and audit trails, while supporting SOC 2 compliance.
  • Collaborate with underwriting, claims, operations, and technology teams to prioritize projects and improve data accessibility., * Location: Los Angeles, CA, with a hybrid schedule and approximately monthly in-office collaboration.
  • Southern California candidates are strongly preferred.
  • Exceptional remote candidates may be considered, with quarterly onsite visits and substantial overlap with Pacific time business hours. Travel for required onsite visits is covered.

Requirements

  • Hands-on experience building a data warehouse or lake, including data ingestion, transformation, orchestration, and modeling.
  • Experience integrating internal business systems with external data sources, vendor feeds, or partner APIs.
  • Proven ability to develop governed metrics, semantic layers, certified datasets, and row-level security.
  • Experience delivering data through applications, embedded reporting, or APIs-not just BI dashboards.
  • Strong SQL skills and working knowledge of Python, with the ability to code regularly.
  • Experience directing contractors or offshore teams and reviewing deliverables for quality and accuracy.
  • Knowledge of data security, access controls, sensitive-data handling, and audit requirements.
  • Strong analytical, communication, and problem-solving skills, with the ability to prioritize foundational work in a developing data environment.

Preferred Qualifications

  • Experience in insurance, shipping, logistics, parcel delivery, or supply chain.
  • Microsoft Azure, Azure SQL, Power BI, or Fabric experience. Snow–flake, BigQuery, and Databricks experience may also be relevant.
  • Exposure to fraud detection or predictive modeling is a plus but not required.

About the company

A growing technology-driven shipping insurance organization provides coverage for goods in transit, from everyday merchandise to high-value items such as jewelry, precious metals, trading cards, and fine art. Its technology platform, insurance API, and claims system generate valuable data across quoting, policies, claims, carrier performance, and shipping activity.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.gogpac.com
Prepare application

Good distractions

Loading talks and stories from around this role…