Tort Experts is an innovative vertically integrated legal case acquisition marketing company. We disrupt the status quo by providing qualified claimants to lawyers nationwide built on technology, data and transparency. At Tort Experts, we connect qualified claimants with representation in the most efficient and effective process for our clients.

Data analyst role will assist in monitoring existing reports, query our data warehouse (bigquery) for ad hoc requests, and writing code to get data out of api endpoints.

Daily activities could include:

• Write clean and composable SQL code using CTE and window functions.
• Create python code to pull data from api rest apis.
• 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 (mysql and bigquery but any sql rmdbs works)
• Check reports to look for outliers and inconsistencies
• Monitor and update looker dashboards.

Ongoing activities:

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

Writing documentation on queries written.

Soft Skills:

• Understand the day-to-day issues that our business faces, which can be better understood with data
• Compile and analyze data related to business' issues
• Develop clear visualizations to convey complicated data in a straightforward fashion

Technical Skills:

• 2+ years SQL (MySQL or similar)
• 4+ years of excel
• 2 years of visualization tooling (Looker preferred)
• Experience with JSON and CSV
• Python or other programming experience
• Git experience

Nice to Have:

• Prefect
• Looker experience
• DBT experience