Park Ridge, IL 60068
Salary: $70,000.00 to $90,000.00 /year

We are looking for a Mid-Level Business Intelligence Developer who will be responsible for analyzing reports, conducting data conversions, moving data, and providing recommendations for process improvements. He or she will focus on database management systems revolving around working with clients to convert data between different formats and compatible with our PCRS system. This position will also be responsible for developing and monitoring custom SSRS reports. The Mid-Level Business Intelligence Developer will work directly with our Reporting Team.

• Become a subject matter expert in the service contract and F&I aftermarket products industry through hands-on training
• Manage master data, including creation, updates, conversions, and deletion
• Interpret data and analyze results using statistical techniques
• Provide quality assurance of imported data, working with the QA team as necessary
• Process confidential data and information according to guidelines
• Support the data warehouse in identifying and revising reporting requirements
• Support initiatives for data integrity and normalization
• Troubleshoot the reporting database environment and reports
• Identify, analyze, and interpret trends or patterns in complex data sets
• Design, develop, revise, and maintain custom SSRS reports
• Gather and translate business requirements into report designs
• Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports
• Generate ad-hoc reports as needed
• Provide reporting to customers and management to support business decisions and become more proficient in the use of the application
• Train end users on new reports and dashboards
• Communicate with team members to assess progress of deliverables
• Examine, evaluate, and develop reporting requirements for various business units; develop reports and reporting structures as required
• Communicate reporting changes, enhancements, and modifications verbally or through written documentation to management and other team members
• Work with other reporting team members to prepare and deliver reports, recommendations, or alternatives for improving processes in reporting systems across the organization

• BA/BS degree required
• 5-6 years of experience in prior Business Intelligence role
• At least 1 year of experience with Power BI
• Demonstrated ability to analyze data and solve complex problems
• Ability to work with stakeholders to assess potential risks
• High-level experience in methodologies and processes for managing large scale databases
• SQL skills required
• Ability to translate business requirements into non-technical terms
• Strong analytical skills with the ability to collect, organize, and analyze significant amounts of information with great attention to detail
• Excellent written, verbal and presentation skills are required

Experience Preferred:
• Strong strategic thinking, teamwork, situational leadership and planning skills
• Experience using various reporting tools preferred
• Highly, self-motivated personality with the ability to manage time
• Knowledge of Microsoft Office: Outlook, Excel and Power Point

Company Overview:
PCMI Corporation is a growing international software development company. Our modular platform, Policy Claim and Reporting Solutions™ (PCRS), supports and automates the full administration lifecycle of all extended warranties, F&I products, and service contracts – mainly for the automotive industry.

Our team members are given the opportunity to develop and grow professionally in a fast-paced, entrepreneurial work environment. Everyone is given the opportunity to work towards career goals by attending classes and achieving certifications that are eligible for bonuses. Our other Benefits offered include:

Health and dental insurance
401k with company matching
Paid time off
Paid holidays
Maternity/paternity leave
And more!

This position is located in our Park Ridge, IL office, in walking distance from the Blue Line and right off I-90/I-294.

Go to all jobs