Entry Level Excel Data Analyst Jobs in Illinois (NOW HIRING)

The data analytics team/program primarily supports, identifies and implements data analytics initiatives across Federal Signal. Additionally, the team supports several strategic research/business development opportunities and tactical implementation/optimization projects at the discretion of the CEO/executive management with detailed data-driven analysis and solutions.

Essential Job Duties and Responsibilities:

1. Leverage data and research to test hypotheses generated to support ongoing assessment of growth objectives and business opportunities.
2. Create and support the creation of data-intensive models that are geared at optimizing key strategic decisions across sales, operations and capital allocation.
3. Develop and maintain detailed market share and market sizing analysis by key products and business units.
4. Support data aggregation/data automation efforts across key external KPIs for the company to provide timely intelligence to business units, the corporate strategy team and senior management.
5. Author and provide support analysis for quarterly and annual market intelligence reports for senior management based on assessment of external and internal data.
6. Support realization of select data analytics projects through (1) the identification of new data-based intelligence offerings & (2) internal BU data analysis.
7. Identify and disseminate sales lead generations by analyzing large unstructured data sets for key Federal Signal products.
8. Maintain and update relevant data sets across internal and external sources and distribute data-driven conclusions to key internal stakeholders.
9. Provide ad hoc data-analysis and support special projects as needed
10. Perform other duties, assignments and special projects as assigned.

Position Requirements

• Bachelor’s Degree Required in analytical field such as data science, statistics, economics, computer science, or finance
• 1+ years of professional experience in data analytic/analysis, strategy, consulting or a related analytical role 
• Advanced Microsoft Excel knowledge required
• Experience in web-scraping strongly preferred
• Proficiency in SQL and data manipulation tools (e.g., Python, R) preferred
• Self starter; intellectual curiosity
• Foundational level skills in finance, forecasting and related analysis including modeling and problem-solving skills
• Ability to work with large sets of unstructured data independently 

Target salary range: $65,000 - $95,000

Benefits of Employment

In addition to excellent career growth opportunities, Federal Signal Corporation offers a wide array of benefits including: annual bonus potential, insurance (life, medical, dental, vision), paid holidays, paid vacation, 401(k) with matching contributions and tuition reimbursement. We provide our employees with a smoke-free, drug-free workplace.

About Us

Federal Signal Corporation (NYSE: FSS) builds and delivers equipment of unmatched quality that moves material, cleans infrastructure, and protects the communities where we work and live. Founded in 1901, Federal Signal is a leading global designer and manufacturer of products and total solutions that serve municipal, governmental, industrial and commercial customers. Headquartered in Downers Grove, IL, with manufacturing facilities worldwide, the Company operates two groups: Environmental Solutions and Safety and Security Systems. For more information on Federal Signal, visit: www.federalsignal.com.

The Company is an equal opportunity employer. Qualified applicants will not be discriminated against on the basis of, and will receive consideration for employment without regard to, race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, genetic information, status as a protected veteran, or any other protected category, characteristic, or trait under applicable law. If you require reasonable accommodation in the application process, contact Human Resources at HR@federalsignal.com. All other applications must be submitted online.

#LI-PZ1