Affirmative Action / EEO - Data Analyst

Position Summary

We have the opportunity for a Data Analyst to join the Firm’s Data Analytics team to provide support for our OFCCP Compliance, Government Contracting, and Reporting Practice Group. OFCCP Data Analysts are responsible for providing internal and client facing analytic and data visualization solutions. This position will perform a number of duties, including reviewing data, developing processes and techniques to extract data from a variety sources, determining how best to analyze the data, and generating descriptive and statistical analysis on the data in compliance with OFCCP and DOL requirements.

Essential Functions

1. Perform analysis related to a number of employment-specific project types, including Affirmative Action Programs, EEO-1 Reports, VETS-4212 reports, reduction-in-force, employment discrimination, and state pay reporting.
2. Locate the necessary data sources, extract and convert raw, sometimes discordant data into structured files ready for analysis, verify data integrity, run preliminary descriptive analyses, and finalize documents and data for production.
3. Manipulate, clean, analyze, and refine data using a variety of tools including R, Python, Excel, and other software tools.
4. Develop and document processes and techniques used to extract, clean, and analyze data.
5. Explain your work to others with varying degrees of technical experience.
6. Daily interaction with attorneys, clients and users, including presenting findings and summaries of analyses, as well as collaborating to create data-driven solutions to improve their workflows or processes.
7. An interest in workforce/people analytics and leveraging data to assist clients with creating more efficient, productive workforces through predictive analytics.
8. Manage your projects and work with minimal direction to ensure that deadlines are met and relevant stakeholders are kept in the loop.
9. Assist other team members as needed to ensure that exceptional work product is delivered consistently and in a timely fashion.
10. Locate and define new process improvement opportunities.
11. Create dashboards and other data visualizations in Power BI to help drive insights and tell the story of the analysis.

Requirements

1. At least 2 years’ experience as a data analyst or business data analyst providing support for HRIS-related data. Previous experience analyzing data in support of compliance, including preparation for annual AAPs, EEO-1s, and VETS-4212 is preferred.
2. Expert-level Excel skills and familiarity with MS Office suite.
3. Comfortable interacting with attorneys and clients and taking on prominent role related to data, including presenting the results of your analysis to clients and stakeholders.
4. Ability to explain complicated analyses and processes in terms that are understandable to non-experts both orally and in writing.
5. Self-starter capable of working remotely and with little supervision and able to work through and resolve technical issues on their own.
6. Team player, customer service focused, and adept at multi-tasking and prioritization.
7. Familiarity with Agile project management.
8. Initiative and problem-solving abilities with a focus on building it better and continuous improvement.
9. Keen interest in technology and innovation, and ability to quickly learn new platforms.
10. Experience using statistical packages for analyzing large datasets (e.g. R, Python, SAS, STATA, SPSS, etc.) or an interest in learning.
11. Experience with Power BI or other data visualization platform or an interest in learning.
12. Experience with VBA or an interest in learning.
13. Experience with SQL and/or comfortable querying databases or an interest in learning.

Benefits

In accordance with the Colorado Equal Pay for Equal Work Act, the expected salary range for this Colorado position is between $80,000 and $98,000. In accordance with New York City’s Wage Transparency Law, the expected salary range for this New York City position is between $85,000 and $100,000. In accordance with California’s amended labor code as stated in Senate Bill 1162, the expected salary range for this California position is between $79,000 and $98,000. In accordance with the Washington Equal Pay and Opportunities act, the expected salary range for this Washington position is between $87,000 and $101,000. Actual pay will be adjusted based on experience, geographic location, and other job-related factors as permitted by law. This position qualifies for the benefits below.

Ogletree Deakins offers a robust suite of benefits for our Staff including: Paid Time Off, Paid Sick Leave, a 401(k) matching program, Profit Sharing, Paid Holidays, Paid Parental Leave, affordable Health and Life Insurance including Dental & Vision coverage, Health Savings Account /Flexible Spending Accounts to help offset the cost of dependent care and/or health care expenses, Teladoc (24/7 access to a doctor by phone or online video), Tuition Reimbursement and an Employee Assistance Program.

Firm Overview

Ogletree Deakins is one of the largest labor and employment law firms representing management in all types of employment-related legal matters. Premier client service, as outlined in the firm’s Client Pledge, is one of the firm’s top priorities and a cornerstone of its core values. Best Law Firms has named Ogletree Deakins a “Law Firm of the Year” for 13 consecutive years. In the 2024 edition, the publication named Ogletree Deakins its “Law Firm of the Year” in the Employment Law - Management category. Ogletree Deakins has more than 950 attorneys located in 56 offices across the United States and in Europe, Canada, and Mexico. The firm represents a diverse range of clients, including many of the Fortune 50 companies in the U.S.

We are fully committed to the importance of diversity within the legal profession, as well as all workplace environments and strongly encourage the interest of diverse candidates in the firm.

Equal Opportunity Employer.