What are the responsibilities and job description for the ICM Systems Consultant position at Comerica Bank?
The Assistant Vice President, ICM Systems Consultant is responsible for supporting the ICM Systems Manager with management of the Incentive Compensation Management (ICM) Sales Performance Management System, including programming, report building, plan set-up and maintenance, issue resolution, release and project management and general production support, and testing and coordination of organizational efforts with ICM impact. This role is a single incumbent position supporting all ICM incentive plan processing across multiple lines of business. Success incumbents possess technical proficiency in Excel and SQL, and strong attention to detail.
Position Responsibilities:
System Support
- Reviews, evaluates, and documents production support issues; troubleshoots and prepares recommendations.
- Coordinates the prioritization and resolution of production support tickets.
- Implements low to moderate complex incentive plan models for existing and new incentive plans including:
- Develop, build, and maintain incentive calculations.
- Build and maintain components, data and rate tables including custom/structural/data tables.
- Configure, build, and maintain workflows and portal access groups.
- Configure and build Varicent ad hoc queries.
- Use Scheduler in Varicent to schedule jobs.
- Creates and executes test transactions for production support issue resolution.
- Uses analytical skills to review business processes and make recommendations for effectiveness and accuracy.
- Evaluates new compensation components, determines business rules and calculations that apply, prepares documentation.
- Supports technical projects including project initiation, plan development, execution, and status reporting.
- Contributes to requirements and design documentation.
- Develops, deploys, and trains on test plans.
- Assists with communications and training materials for administrators and end users.
- Prepares and maintains current procedure and process documentation.
- Collaborates with stakeholders to develop data and business requirements to support incentive plan processing.
- Works with Incentive Compensation Consultants, vendors, and others to develop and maintain reporting.
- Performs trend analysis, modeling of plan design changes, stress testing and related activities.
- Supports auditing of incentive compensation plans and rules reflected in payout calculations, collects system control information, completes SOC reports and supports related requests.
- Other duties, as assigned.
- Bachelor's Degree from an accredited university or in lieu of a bachelor's degree, a High School Diploma or GED and 4 years of related experience
- 4 years of experience working with relational databases and report writing
- 4 years of experience analyzing data to identify, investigate and manage solutions to align technology solutions and business objectives
- 4 years of project management experience
- 4 years of experience working with word processing and spreadsheet software experience (i.e., Access, Word, Excel) including writing documentation that describes installation and operating procedures and the ability to write complex formulas and calculations
About Comerica
We know our employees are critical to our overall success and we are dedicated to investing in their future. One of the ways we do this is to offer a comprehensive Total Rewards package designed to recognize and reward individual performance, as well support health, well-being, development and security for our colleagues and their family. Total Rewards consists of cash compensation, development and flexible benefit programs designed to meet individual needs today and in the future. Your salary will be commensurate with your work experience and our programs are reviewed regularly to ensure each remain competitive. We are proud to offer benefits such as health and welfare programs, strong retirement benefits, and generous paid time off programs. You and your eligible family members, including domestic partners and their children, can participate in medical, dental, and vision benefits, 401(k) and pension, income protection benefits such as life insurance, AD&D, and supplemental health programs to offset unexpected health care expenses. We also have a variety of time off programs for things like vacation, sick time, disability, and parental leave. Eligibility for some programs varies based on employment status and tenure.
Upon offer, Comerica conducts a comprehensive background and fingerprint check.
NMLS certification requirement: where applicable, a favorable background check screening, credit check, fingerprint check, and NMLS certification is required in accordance with the SAFE Act.
Comerica Incorporated (NYSE: CMA) is a financial services company headquartered in Dallas, Texas, and strategically aligned into three major business segments; the Commercial Bank, the Retail Bank, and Wealth Management. Comerica's colleagues focus on relationships, and helping people and businesses be successful. In addition to Texas, Comerica Bank locations can be found in Arizona, California, Florida and Michigan, with select businesses operating in several other states, as well as in Canada and Mexico.
Comerica is proud to be an Equal Opportunity Employer - veterans/individuals with disabilities, committed to workplace diversity.
