Senior Analytics Engineer

Epiq Company; New York, Northern (NY, KY); Hybrid; USD 140,000 - 170,000; Full time

Job summary

Epiq is seeking a Senior Analytics Engineer to help build modern data and analytics capabilities for corporate legal teams. You will translate complex business logic into modular Python/SQL code, architect local data environments, and ensure client reporting is reproducible and secure.

Remote-friendly, full-time, with growth and learning opportunities. The role emphasizes architecture, data modeling, and maintaining documentation, while collaborating with senior consultants and engineers in a

Qualifications

• Strong SQL and Python capabilities for data engineering tasks.
• Hands-on experience with dbt and data modeling.
• Familiarity with version control workflows using Git.
• Ability to translate complex business rules into modular code.

Responsibilities

• Pipeline Architecture: design, build, and manage dbt models using DuckDB to standardize calculations.
• Code Quality Assurance: review requests and ensure clean, documented, secure code before production.
• Environment Management: configure local dev setups for security compliance.
• Metric Definition: translate requirements into stable SQL definitions in models/.
• Documentation Maintenance: update data dictionary and link reports to code modules.

Skills

SQL

Python

dbt

Plotly

Git

Data modeling

Tools

DuckDB

Parquet

CSV

Job description

## Senior Analytics EngineerApplyremote type: Remote: Work from Home Full-Timelocations: USA-New York-NY-1166 Avenue of Americastime type: Full timeposted on: Posted Todayjob requisition id: R0034923At **Epiq**, your work contributes to complex, global legal outcomes. You’ll join a values‐driven community where integrity guides decisions, **relentless service** sets the bar, and we **thrive on big challenges** together. We invest in your growth with enterprise‐wide learning and mobility. We celebrate who you are, and we respect life beyond work with flexibility that’s recognized externally. Enabled by modern platforms and AI, **you’ll do the most meaningful work of your career** and see your impact at scale.**Job Description:****Job Summary:**The Senior Analytics Engineer is a key role to help our team establish modern data and analytics capabilities in order to help corporate legal departments work smarter, faster, and more cost effectively. The role is responsible for architecting and maintaining a local data environment; they translate complex business logic into modular, version-controlled Python/SQL code. This role ensures that all client reporting derived is reproducible, secure, and consistent, rather than relying on fragmented Excel spreadsheets.Key Responsibilities:**Essential Job Responsibilities*** Pipeline Architecture: Design, build, and manage dbt (data build tool) models using DuckDB (or similar solutions) to standardize calculations across the team (e.g., ensuring “Average Blended Rate\" means the same thing for every engagement).* Code Quality Assurance: Review requests from non-technical consultants. Validate that generated code is clean, documented, and secure before merging into production repositories.* Environment Management: Configure local dev environments for consultants (e.g., Ollama, DuckDB drivers) to ensure security compliance.* Metric Definition: Translate business requirements from Practice leadership and Senior Consultants into stable SQL definitions (e.g., in a models/ folder if using dbt).* Documentation Maintenance: Ensure every code module has clear comments and links to client-facing reports; maintain the internal \"Data Dictionary\" that AI tools use to understand our data. **Qualifications & Characteristics*** Technical Proficiency: Good command of SQL (Postgres/DuckDB) and Python scripting. Hands-on experience with dbt, plotly, and/or related tooling ideal.* Version Control: Knowledge of Git flows (Commits, Branching, PRs) and demonstrated ability to maintain strong version control over projects.* Data Modeling: Ability to normalize messy client data (Parquet/CSV) into clean schemas without losing nuance.* Soft Skills: Ability to explain technical limitations (\"We can't do this in one Jupyter notebook cell\") to non-technical stakeholders without sounding dismissive; ability to propose creative solutions based on known constraints.* Familiarity with Jupyter notebooks, Quarto, Ollama, Cursor IDE, or VS Code a plus.* Experience with established software engineering best practices as well as modern techniques (e.g., Claude Code) preferred.* Knowledge of LLM prompting/privacy best practices a plus.Your specific salary will be determined based on several factors:* **Location-based market rate** for the role* **Your abilities** in relation to the job specification* **Performance** during screening and interview* **Pay parity** with the wider team in the considered locationFurther details about the package will be provided during the initial screening call with the Talent Acquisition Team.Click here to learn about Epiq's Benefits.**Epiq Leadership Compass****Enterprise Decision Making**Applies deep business and financial insight to guide strategic decisions, resource allocation, and thought leadership.* Use financial and market expertise for long-term direction* Build strategic partnerships* Promote a customer-first mindset* Allocate global resources for innovation and growth**Cultivates a Growth Mindset**Fosters innovation through curiosity, smart risk-taking, and adaptability—aligning change with strategy for lasting impact.* Promote curiosity and forward-thinking* Build a culture of innovation through partnerships* Drive innovation to meet client needs* Lead innovation with a clear vision* Align innovation with market trends**Builds Talented Teams**Builds and develops inclusive, high-performing teams aligned to strategic goals for exceptional talent and business results.* Focus on employee engagement* Build a strong talent pipeline**Fosters Relationships & Collaboration**Builds trust and alignment through open communication, shared goals, and strong partnerships to drive collective success.* Build trust-based partnerships* Nurture long-term relationships* Remove collaboration barriers* Celebrate cross-team success**Engages & Influences**Inspires action and alignment through clear communication, purposeful influence, and a compelling vision.* Use storytelling to build buy-in* Align communication with organizational goals* Guild alignment through strong engagement**Maximizes Performance**Sets and reinforces performance standards that drive results, ensure accountability, and align with Epiq’s goals.* Use data to identify improvement opportunities* Make informed decisions* Align team goals with boarder strategy* Empower teams to manage their own goals* Translate vision into clear priorities* Prepare for disruptions with strong change management**It is Epiq’s policy to comply with all applicable equal employment opportunity laws by making all employment decisions without unlawful regard or consideration of any individual’s race, religion, ethnicity, color, sex, sexual orientation, gender identity or expressions, transgender status, sexual and other reproductive health decisions, marital status, age, national origin, genetic information, ancestry, citizenship, physical or mental disability, veteran or family status or any other basis protected by applicable national, federal, state, provincial or local law. Epiq’s policy prohibits unlawful discrimination based on any of these impermissible bases, as well as any bases or grounds protected by applicable law in each jurisdiction. In addition Epiq will take affirmative action for minorities, women, covered veterans and individuals with disabilities. If you need assistance or an accommodation during the application process because of a disability, it is available upon request. Epiq is pleased to provide such assistance and no applicant will be penalized as a result of such a request. Pursuant to relevant law, where applicable, Epiq will consider for employment qualified applicants with arrest and conviction records.**