Remote Data Analyst Sql Excel Jobs in Bothell, WA

This is an exciting opportunity to work for one of the top law firms in the U.S.! Davis Wright Tremaine LLP is looking for a Data Analyst to join our team in our Seattle, Portland, Los Angeles, or San Francisco offices.

This position offers the flexibility to be fully remote while working within reasonable commuting distance from any of our offices.

This position is responsible for supporting a dynamic and growing class-action defense practice. The data analyst will play a pivotal role in managing, analyzing, and visualizing data for complex matters, including wage and hour disputes, pay equity cases, and class-action litigation. The ideal candidate will thrive in a collaborative, fast-paced environment and demonstrate outstanding technical, analytical, and communication skills to streamline class-action litigation support processes and deliver exceptional client service.

At Davis Wright Tremaine, you will find challenging assignments, opportunities for professional growth and community involvement, and a culture of inclusion. DWT fosters inclusiveness and authenticity. Regardless of position, everyone here has a voice and the support is unparalleled.

On a typical day you will:

Data Management & Analytics

• Partner with attorneys and clients to evaluate data needs, develop analysis strategies, and deliver clear and actionable insights.
• Obtain, structure, and manage raw datasets from various sources, including payroll, timekeeping, and HRIS.
• Analyze and evaluate data using advanced tools and reporting platforms to create pivot tables, charts, and intuitive visual dashboards.
• Perform advanced data analytics to generate deliverables such as exposure analyses, pay equity audits, affirmative action plans, and class lists.
• Design exposure analysis reports to identify key case strengths, risks, and potential settlement strategies.
• Organize data workflows for wage and hour analyses, enabling efficient and accurate review across multiple data sets and record formats.

Collaboration & Communication

• Work with multidisciplinary teams, including attorneys, clients, expert witnesses, and opposing counsel, to guide data-related discussions.
• Collaborate with IT, eDiscovery, and Practice Support teams to ensure secure, compliant handling of sensitive data throughout the case lifecycle.
• Communicate findings effectively to attorneys, clients, and other stakeholders through written reports, visual presentations, and face-to-face briefings.

Technology Strategy & Support

• Evaluate and recommend new technologies, tools, and methodologies for data analysis, visualization, and reporting for litigation support.
• Leverage software such as Excel, Tableau, Power BI, SQL,or similar tools to deliver dynamic and interactive visualizations of crucial metrics.
• Collaborate with staff in analytics roles to provide support and seamless backup coordination.

Class-Action Specific Support

• Assist with analysis of potential CAFA removal.
• Prepare putative class lists, perform random sampling analyses, and other tasks in support of class opposition processes.
• Develop and run pay equity and EEO analyses to ensure compliance with regulatory standards and best practices.
• Coordinate with expert witnesses to create polished and effective exposure models for case development and litigation defense strategy.
• Generate detailed reports to support complex class-action claims, highlighting key trends and patterns in the data.

Trial & Litigation Preparation

• Support attorneys during motion practice, depositions, and trial preparation with clear, accurate data summaries and visual exhibits.
• Assist in reviewing data-related findings in expert reports, ensuring alignment with case objectives and litigation strategies.

Join us if you have:

• 4+ years of professional experience as a Data Analyst, with a proven track record in complex data analysis and reporting, preferably in employment class action litigation or related fields.
• Master's or Bachelor's degree in statistics, data analytics, or a related field.
• Technical Proficiency:
• Advanced Excel skills, including pivot tables, macros, and advanced formulas.
• Experience with Tableau, Power BI, SQL,or similar platforms for data visualization and analysis.
• Familiarity with HRIS, payroll systems (e.g., ADP, UKG), and wage and hour analysis.
• Excellent verbal and written communication skills with the ability to adapt technical findings for non-technical audiences.
• Advanced proficiency in the use of Microsoft Office applications (i.e., Word, Excel, PowerPoint, and Outlook) for drafting and editing complex documents and spreadsheets.
• Exceptional problem-solving, analytical skills, and attention to detail, with a demonstrated ability to meet tight deadlines.
• Familiarity with employment law, including wage and hour standards (especially in California), pay equity laws, and EEO compliance are strongly preferred.
• Ability to design and deliver exposure models and visual insights for effective case strategy.
• Strong organizational skills and ability to multitask effectively in a fast-paced environment.
• Willingness and availability to work flexible hours, including evenings or weekends, to meet litigation deadlines.
• Previous experience in a law firm or professional services setting supporting multiple offices strongly preferred.

Who We Are

Davis Wright Tremaine LLP is an AmLaw 100 law firm with 9 offices nationwide. We are relentlessly committed to client service and look for candidates who share that commitment. At DWT, client service means having empathy for each client's and each lawyer's work and personal pressures, business objectives, and legal needs; anticipating their needs; and having the capabilities and commitment to deliver what matters most to them.

What's in it For You?

DWT offers competitive compensation in addition to ample benefits including but not limited to:

• Choice of health and vision insurance plans
• 2 paid volunteer days for qualifying community service work
• Dental plan
• Fertility and adoption benefit
• Paid sabbatical after 13 years of service
• Tuition reimbursement
• Commuter benefits
• Retirement contribution

This job description intends to describe the general nature and level of work being performed by individuals assigned to this position. It is not intended to include all duties and responsibilities.

Washington State

The annualized salary range for this position in Washington is $121,000 to $145,000 ($62.05 to $74.36 hourly).Actual pay will be adjusted based on the candidate's education, training, experience and other job-related factors permitted by law. Full time employees may be eligible for a bonus, health insurance with an optional HSA, long term disability, dental insurance, vision care, telemedicine and virtual short term solution based counseling services, life insurance, Healthcare and Dependent Care Flexible Spending Accounts, subsidized backup care and caregiving resources, 401(k), vacation, sick time, 11 paid holidays each year and an employee assistance program. For full-time employees, the initial vacation benefit is 15 days per year and 11 days of sick leave per year, accrued bi-weekly. Additional voluntary programs include: voluntary accident insurance, voluntary life, voluntary disability, voluntary long term care, and pet insurance. Commuter and Transit programs are also available.

California

The annualized salary range for this position in Los Angeles is $120,000 to $146,000 ($61.54 to $74.87 hourly); and in San Francisco is $138,000 to $165,000 ($70.77 to $84.62 hourly). Actual pay will be adjusted based on experience and other job-related factors permitted by law. Full time employees may be eligible for a bonus, health insurance with an optional HSA, long term disability, dental insurance, vision care, telemedicine and virtual short term solution based counseling services, life insurance, Healthcare and Dependent Care Flexible Spending Accounts, subsidized backup care and caregiving resources, 401(k), vacation, sick time, and an employee assistance program. Additional voluntary programs include: voluntary accident insurance, voluntary life, voluntary disability, voluntary long term care, and pet insurance. Commuter and Transit programs are also available.

Davis Wright Tremaine LLP fosters a culture where all talented individuals-including those who are traditionally underrepresented in the legal profession-can have, and can see, paths to success.Our commitment to diversity, equity, and inclusion sits on four pillars: Community, Growth, Education, and Engagement.Learn more about the firm's commitment to DEI here:www.dwt.com/dei.

Davis Wright Tremaine provides reasonable accommodations for those who need them to complete the application or recruiting process and for employees who need reasonable accommodations to perform the essential functions of their positions due to a disability or for religious reasons. If you need to request accommodation during the application or recruiting process, please emailhumanresources_confidential@dwt.com.

#LI-RK1