Sales/CRM Business Analyst

Vactor Manufacturing; Elgin (IL); On-site; USD 75,000 - 90,000; Full time

Benefits offered by this job

Annual bonus

Life insurance

Medical insurance

Dental insurance

Vision insurance

Paid holidays

Paid vacation

401(k) match

Tuition reimbursement

Smoke-free workplace

Drug-free workplace

Job summary

Vactor Mfg. Inc. in Illinois seeks a Sales BI Analyst to optimize CRM usage, build dashboards, and turn diverse data into actionable insights for the sales organization.

You will ensure data integrity in Dynamics CRM, develop pipeline reports, and deliver timely sales reporting to leadership. Ideal candidates have a data analytics background, SQL, Python or R, and BI tools experience; some dealer-session travel may be required.

Qualifications

• Bachelor's degree required; concentration in Data Science, Finance, Statistics, Economics, or related field desirable
• 1–3 years of experience mining, manipulating, and formatting large data sets for a sales environment
• Proven experience in Microsoft Office (Word, Excel, PowerPoint)
• Proficiency in CRM platforms (Dynamics preferred), data management, BI tools
• Proficiency in SQL and data manipulation tools (e.g., Python, R) preferred
• Independently research, identify, and analyze new data sets that aid the strategic planning process
• Ability to interpret data and make thoughtful business recommendations
• Ability to work with large sets of unstructured data independently
• Process-oriented thinker with proven track record in problem-solving, data interpretation and process mapping

Responsibilities

• Develop and implement comprehensive pipeline reports and dashboards to track sales opportunities.
• Provides Business Intelligence and synthesizes sales and marketing data for business leadership.
• Analysis of sales data to identify sales/market trends, profitability, and cyclicality of business.
• Administration of Microsoft Dynamics CRM to ensure data integrity, load product information, update data, and track opportunities within the CRM including system optimization and process improvement.
• Maintain Dealer Dashboard data integrity by tracking new business, discount amounts, demonstrations, and profitability of dealerships by utilization of the Vactor/Elgin BI tool.
• Development of win/loss reporting to track new business by segment, dealer, and RSM.
• Responsible for maintenance of monthly new business reporting to track actuals vs. plan, discounting and profitability for all sales channels.
• Create sales data repository to capture market data obtained from demonstration initiatives and other customer interfaces.
• Attend dealer market planning sessions to gather market information and common trends observed throughout all the sessions. Some dealer sessions will require travel.

Skills

CRM proficiency

BI reporting

SQL

Python

R

Data analysis

Data visualization

Excel

Education

Bachelor's degree in related field

Tools

Microsoft Dynamics CRM

Power BI

SQL

Python

R

Excel

Job description

Responsibilities

Responsibilities may include, but are not limited to, the following: management of sales tools including CRM and BI tool. CRM optimization. Complete data entry into systems, track business, create extract data from various sources, synthesize turning data into usable information and distributing to the proper channel. Provide accurate and efficient sales reporting and other analysis and intelligence essential for the efficient operations of the sales organization. Recommend revisions to existing reporting and lead the development of new reporting tools as needed.

• Develop and implement comprehensive pipeline reports and dashboards to track sales opportunities.
• Provides Business Intelligence and synthesizes sales and marketing data for business leadership.
• Analysis of sales data to identify sales/market trends, profitability, and cyclicality of business.
• Administration of Microsoft Dynamics CRM to ensure data integrity, load product information, update data, and track opportunities within the CRM including system optimization and process improvement. Liaise with IT acting as the bridge between sales and IT to ensure system utilization and enhanced performance of program.
• Maintain Dealer Dashboard data integrity by tracking new business, discount amounts, demonstrations, and profitability of dealerships by utilization of the Vactor/Elgin BI tool.
• Development of win/loss reporting to track new business by segment, dealer, and RSM.
• Responsible for maintenance of monthly new business reporting to track actuals vs. plan, discounting and profitability for all sales channels.
• Create sales data repository to capture market data obtained from demonstration initiatives and other customer interfaces.
• Attend dealer market planning sessions to gather market information and common trends observed throughout all the sessions. Some dealer sessions will require travel.

Experience And Skills Required

• Bachelor's degree required; concentration in Data Science, Finance, Statistics, Economics, or other related filed desirable
• 1-3 years of experience mining, manipulating, and formatting large data sets to a construction of models in a Sales environment highly desirable
• Must have proven experience in Microsoft Office (Word, Excel, PowerPoint)
• Proficiency in CRM platforms (Dynamics preferred), data management, BI tools
• Proficiency in SQL and data manipulation tools (e.g., Python, R) preferred
• Independently research, identify, and analyze new data sets that aid the strategic planning process
• Ability to interpret data and make thoughtful business recommendations
• Ability to work with large sets of unstructured data independently
• Process-oriented thinker with proven track record in problem-solving, data interpretation and process mapping

Salary Range - $75k-90k

Benefits of Employment;

• 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

Vactor Mfg. Inc. is a leading manufacturer of municipal combination catch basin/sewer cleaning vacuum trucks and industrial vacuum loaders that clean up industrial waste or recover and recycle valuable raw materials. Vactor is located in Streator, IL and is a subsidiary of Federal Signal Corporation.

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 [e-mail]. All other applications must be submitted online.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.