Data Analyst

About Tort Experts

Tort Experts is a leading provider of mass tort lead generation services, dedicated to connecting qualified claimants with legal representation. Our expertise lies in leveraging cutting-edge digital marketing strategies and innovative technologies to identify and generate high-quality leads for various mass tort cases, such as pharmaceutical, medical device, and environmental claims. We pride ourselves on our commitment to ethical practices, client satisfaction, and driving results for our partners.

About the role

We are currently seeking a highly motivated and detail-oriented Data Analyst to join our dynamic team. In this role, you will support  monitoring existing reports, query our data warehouse (bigquery) for ad hoc requests, and writing python code to get data out of api endpoints. The ideal candidate will have previous experience in lead generation, especially in the legal vertical.  This is an exciting opportunity to join a fast-paced environment and play a key role in expanding our reach and impact in the mass tort industry.

Daily activities will include:

• Monitor dashboards to find outliers and inconsistencies

• Build and update Looker dashboards

• Work closely with other departments to investigate sources of errors. Then fixing the problem or creating a summary of the issue and working with our data engineer to fix it.

• Format reporting in excel and merge data from multiple datasets with vlookup and other advanced excel functions.

• Write ad hoc sql multiple table join queries to get data 

  • We use MySQL and BigQuery but experience with any sql RDBMS works

• Write clean and composable SQL code 

  • Knowledge of CTE and window functions is highly desirable

• Write python code to pull data from api rest apis.

Ongoing activities:

• Give suggestions on ways to increase revenue or decrease costs from data.

• Writing documentation on how our data process works and errors we encounter.

Requirements:

• 3+ years SQL (MySQL or similar)

• 4+ years of excel

• 2 years of visualization tooling (Looker preferred)

• Experience with JSON and CSV

Nice to Have:

• DBT experience

• Python or other programming experience

• Git experience

• Prefect

• Looker experience