BI Engineer

About Tort Experts At Tort Experts, we are redefining the landscape of performance marketing in the legal sector. Our mission is to democratize access to information for individuals who have been injured, connecting them with law firms that can truly advocate for their rights and achieve successful outcomes. As an innovative, vertically integrated legal case acquisition marketing company, we leverage cutting‑edge technology, data‑driven insights, and a commitment to transparency to disrupt the status quo. About The Role We are currently seeking a highly motivated and detail‑oriented BI Engineer to join our dynamic team. In this role, you will support monitoring existing reports, query our data warehouse (BigQuery) for ad‑hoc requests, and write Python code to pull data from 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. Location Remote (must be available 9am – 5pm Eastern Time) What You’ll Do Build and update dashboards Understand the semantic layer (LookML, Cube) Monitor dashboards to find outliers and inconsistencies Work closely with other departments to investigate sources of errors, then fix the problem or create a summary of the issue and work 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 queries to join multiple tables and get data (MySQL, BigQuery, or any SQL RDBMS) Write clean and composable SQL code (CTE and window functions required) Write Python code to pull data from REST API endpoints Ongoing Activities Give suggestions on ways to increase revenue or decrease costs from data Write documentation on how our data process works and errors we encounter Qualifications 3+ years SQL (MySQL or similar) 4+ years of Excel 2+ years of LookML experience Git experience Experience with JSON and CSV Nice to Have Python or other programming experience Prefect dbt Benefits Uncapped quarterly profit‑sharing bonuses based on company performance 100% company‑paid monthly premiums for Fortune 500 level quality insurance plans for you and any/all dependents (US‑based employees) 100% company match on any employee contributions to either HSA or FSA flex benefits plans (US‑based employees) 401k plan with full company match of up to 6% of salary and no vesting period required (US‑based employees) Unlimited paid time off with planned role/responsibilities coverage Work‑from‑home equipment budget (at company discretion) Forever remote work environment Why Join Us? At Tort Experts, we believe in empowering our team members with growth opportunities, a flexible work environment, and the chance to make a tangible impact. If you thrive in fast‑paced environments and are driven, client‑focused, and eager to contribute to our mission of connecting clients with top‑tier legal representation, are you ready to lead the next wave of growth in legal marketing? Apply today and help us transform access to justice AA/EEO Statement Tort Experts provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This applies to all terms and conditions of employment. Seniority level Mid‑Senior level Employment type Full‑time Job function Business Development and Sales Industries Legal Services #J-18808-Ljbffr