Analytics Developer II

Summary

Join Pattern Data, an AI-powered platform for mass tort litigation, as an Analytics Developer. You will partner with business, legal, and product teams, defining data questions, identifying data needs, and building tools and insights. Transform complex data using SQL, Python, and Excel, build LookML models and dashboards, and define business requirements. Develop end-to-end analytics solutions, prepare reports and presentations, and guide projects from concept to delivery. You will also identify and analyze risks, recommend mitigation strategies, and lead critical analyses. This role requires strong analytical skills, communication skills, and experience with data visualization.

Requirements

• Bachelor’s degree in a quantitative or analytical field (e.g., Mathematics, Economics, Accounting, Finance)
• 3–5 years of experience in data analytics, business operations, or strategy, ideally in a tech or legal environment
• Strong business intuition and a track record of turning data into action
• Proficiency in SQL, Python, and Excel
• Hands-on experience with Looker (LookML) or similar BI tools
• Strong analytical skills, business intuition, and a track record of turning data into actionable insights
• Proven ability to own, manage and deliver projects end-to-end in fast-paced, cross-functional teams
• Excellent communication skills with the ability to simplify complex data for diverse audiences
• Passion for data storytelling and the ability to influence decisions through insight-driven recommendations

Responsibilities

• Transform, clean, and interpret complex data using SQL, Python, and Excel to create clear, actionable insights that drive informed decisions
• Build and maintain LookML models, dashboards, reconciliations, and progress trackers to support day-to-day operations and long-term reporting needs
• Define business requirements and translate high-level or ambiguous questions into structured, data-driven problem statements in collaboration with legal, product, operations, and leadership teams
• Develop end-to-end analytics solutions, including scoping data sources, building pipelines, and designing outputs that align with operational context
• Prepare detailed reports and presentations with data visualizations to summarize findings and provide recommendations to a range of stakeholders
• Guide analytics projects through the full lifecycle—from concept to delivery—ensuring deliverables meet quality standards and timelines
• Support project communications and deliverable management by tracking progress, reporting status, and coordinating with cross-functional teams
• Identify and analyze risks, recommend mitigation strategies, and drive process improvements to increase efficiency and reliability
• Lead or support business-critical analyses, including award determinations, duplicate detection, client reporting, and audit compliance
• Conduct root cause investigations on data discrepancies, proactively flag issues, and develop standardized processes to reduce manual effort over time

Preferred Qualifications

Familiarity with AI and machine learning concepts