Analytics Engineer (Quilpué)

Join to apply for the Analytics Engineer role at Tort Experts. Get AI-powered advice on this job and more exclusive features. 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. Why Join Us? Joining Tort Experts means becoming part of a dynamic team that is passionate about making a meaningful impact. We foster a collaborative environment where creativity thrives, and every team member plays a vital role in connecting qualified claimants with the representation they deserve. If you're looking for a workplace where your contributions can truly make a difference, and where innovation meets purpose, Tort Experts is the perfect place for you. About The Role We're looking for a highly motivated and detail-oriented Analytics Engineer to join our growing data team. In this role, you'll be responsible for building clean, reliable, and extensible data models that power business reporting and decision-making. You'll collaborate closely with our Business Intelligence Engineer to ensure they have well-structured datasets ready for dashboarding, monitor data quality across key systems, write ad hoc queries in BigQuery, and help extract data from external APIs using Python. The idóneo candidate brings not only strong technical skills but also a solid understanding of marketing and business operations. Experience in lead generation—especially within the legal industry—is a strong plus. Success in this role means the business can trust the data, build dashboards faster, and reduce reliance on ad hoc queries and manual fixes. This is a high-impact opportunity to join a fast-paced company and play a key role in expanding our reach in the mass tort space. Must be available to work 9am - 5pm EST. What You'll Do Take full ownership of the transformation layer (dbt) and ensure it provides clean, well-tested, and performant datasets for analytics and reporting. Kimball-style dimensional modeling. Creating and update data models using best practices like testing and data diff (Data Fold). Add metadata (schema, descriptions) and data tests to models Leverage reusable dbt macros and packages to ensure scalable and DRY transformations. Improve speed to build tables by using incremental models Build curated data marts or semantic layers that allow business users or dashboard developers to self-serve reporting needs without requiring custom SQL queries. Proactively monitor data pipelines and anomalies using tools like Monte Carlo, and take ownership of triaging data quality issues before they impact stakeholders. Document all data models, their dependencies, and usage guides so that other team members can easily understand and extend the system. 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 queries involving multiple table joins to retrieve data. We use MySQL and BigQuery, but experience with any SQL RDBMS is acceptable. Write clean and composable SQL code, with knowledge of CTEs, window functions, and query performance optimization. Write Python code to pull data from REST APIs. Qualifications 2+ years of data modeling at production level. 3+ years SQL (MySQL or similar). 1 year of dbt. Solid understanding of Git (commit, branch, merge). 2 years of visualization tooling (Looker preferred). Experience with JSON and CSV. Strong written and verbal communication. Nice to have GCP or other cloud experience (AWS, Azure). Prefect or similar orchestrator (Airflow, Dagster, etc.) - assist with data extraction schedules. Looker experience. 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) : medical (Aetna) dental (Guardian) vision (Guardian) 100% company match on any employee contributions to either HSA or FSA flex benefits plans (US based employees) : $500 free FSA company contribution, even if $0 employee contribution 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's discretion) Forever remote work environment 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 Part-time Job function Information Technology Industries Legal Services #J-

• Ljbffr

#J-18808-Ljbffr