Junior Excel Data Analyst Jobs in Carol Stream, IL

DLA Piper is, at its core, bold, exceptional, collaborative and supportive. Our people are the backbone, heart and soul of our firm. Wherever you are in your professional journey, DLA Piper is a place you can engage in meaningful work and grow your career. Let's see what we can achieve. Together.

Summary

The Senior Data Analyst, working in collaboration with and in support of the firm's strategic initiatives, in the Data Analytics group is responsible for data-driven forecasting, leading financial analysis projects, identifying financial trends and operational performance drivers, advancing the firm's data innovation efforts, and applying advanced analytical techniques to support strategic decision-making. This role requires strong analytical and technical skills, financial acumen, and a passion for leveraging data to drive business outcomes.

The Senior Data Analyst uses tools such as Power BI to deliver high-impact analytics, reporting, and dashboards; develop complex data models; and identify and resolve data quality issues. This individual will lead large-scale analytical initiatives, mentor junior analysts, and collaborate with FP&A Revenue & Strategic Finance team to prioritize business needs and deliver actionable insights.

Key skills include proficiency in SQL, Python, DAX, advanced data analysis, and strong presentation and communications skills. The role also involves fostering collaboration, driving continuous improvement, contributing to the firm's data strategy, and ensuring timely, accurate deliverables. Working closely with the FP&A Revenue & Strategic Finance team and our practice groups across the firm, this position conducts research, analyzes and presents data to identify trends, forecast outcomes, and support informed decision-making related to financial performance. Duties will include financial performance data analysis and presentation, interpreting data from analysis using statistical techniques, forecasting, developing and implementing data collection techniques to optimize statistical efficiency.
Location

This position can sit in any of our US office locations (Reston, Chicago, New York, and Short Hills are preferred offices) and offers a hybrid work schedule.
Responsibilities

• Utilize Power BI and other advanced analytics tools to deliver comprehensive and high-impact analytics, forecasting, reporting and insight-driven solutions.
• Collaborate with FP&A Revenue & Strategic Finance to identify practice group challenges and prioritize analysis and solutions.
• Implement best practices and innovative solutions to enhance data integrity and data reporting accuracy, leveraging AI tools to enable data validation of financial reporting
• Drive and manage large-scale analytical projects that span multiple teams and functions.
• Coordinate cross-functional efforts to ensure project alignment with business objectives and successful execution.
• Specifically support identification and tracking of revenue financial drivers and regularly present to internal partners and practice group leadership.
• Support data quality and production for external survey submissions.
• Analyze trends and derive actionable insights to address complex business challenges.
• Design and develop advanced solutions to streamline processes, improve data quality, and drive intelligent automation.
• Champion continuous improvement initiatives to enhance operational efficiency and effectiveness.
• Engage with stakeholders at all levels to understand their needs and provide tailored data solutions.
• Strong communication and financial storytelling skills with both technical and non-technical stakeholders.
  

Desired Skills

Strong analytical and problem-solving skills, with the ability to interpret large complex datasets, identify trends and provide actionable data-driven insights. Highly proficient in data visualization tools (PowerBI/Tableau). Experience in management reporting, report creation process and dashboard design. Highly proficient in Microsoft office, with advanced skills in Excel, including complex formulas, pivots tables, data analysis, VBA, and data visualization techniques. Experience with advanced statistical methods and data modeling techniques. Highly proficiency in SQL and programming languages (Python/R/VBA) or other relevant programming languages.

Demonstrated experience in creation of complex queries, data manipulation, and automation of data processes. Experience/Interest in Machine Learning and AI implementation. Demonstrated problem-solving skills and the ability to adapt to changing business needs. Ability to work independently and as part of a team. Attention to detail and high level of accuracy in work.
Minimum Education

• Bachelor's Degree in Data Science/Analytics, Computer Science, Finance, Economics, Accounting or related field.
  

Minimum Years of Experience

• 4 years' experience as a Data Analyst or similar role including experience with data modeling, statistical analysis and processes.

Essential Job Expectations

While the specific job requirements of a DLA Piper position may vary depending upon scope of the job and area of specialty, there are certain universal requirements that are expected of all DLA Piper employees, which include but are not limited to:

• Effectively communicate, verbally and in writing, with clients, lawyers, business professionals, and third parties.
• Produce deliverables, answer phone calls, and reply to correspondence in an efficient and responsive manner.
• Provide timely, accurate, and quality work product.
• Successfully meet deadlines, expectations, and perform work duties as required.
• Foster positive work relationships.
• Comply with all firm policies and practices.
• Engage in both physical and sedentary activity, such as (a) working at a computer for extended periods of time, including on-screen reading and typing; (b) participating in digital/virtual conference calls; (c) participating in meetings as needed.
• Ability to work under pressure and manage competing demands in a fast-paced environment.
• Perform all other duties, tasks or projects as assigned.
  

Our employees are expected to embrace and uphold our firm values as a part of our DLA Piper culture. We are committed to excellence in how we represent our clients and develop our people.
Physical Demands

Sedentary work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Work Environment

The individual selected for this position may have the opportunity for a hybrid work arrangement comprised of remote and in-office work, the requirement for which will be determined in coordination with the hiring manager or supervisor and may be modified in the firm's discretion in the future.
Disclaimer

The purpose of this job description is to provide a concise statement of the work elements and to organize and present the information in a standardized way. It is not intended to describe all the elements of the work that may be performed by every individual in this classification, nor should it serve as the sole criteria for personnel decisions and actions. The job duties, requirements, and expectations for this position may be modified at the Firm's discretion at any time. This job description does not change the at-will nature of employment.

Application Process

Applicants must apply directly online instead of sending application materials via email.

Accommodation

Reasonable accommodations may be made upon request to permit individuals with a disability to perform the essential functions and responsibilities of the position or to participate in the job selection process. If you have a request for an accommodation during the application process, please contact careers@us.dlapiper.com.

Agency applications will not be considered.

No immigration sponsorship is available for this position.
The firm's expected hiring range for this position is $89,991 - $143,088 per year depending on the candidate's geographic market location.

The compensation offered for employment will also be dependent on other factors including the candidate's experience, skills, educational and professional background, and overall qualifications. We offer a comprehensive package of benefits including medical/dental/vision insurance, and 401(k).

#LI-MK1
#LI-Hybrid

DLA Piper is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.Job applicant poster viewing center.