Financial Systems Support Analyst II
This role plays a critical part in leading the month-end close process, maintaining data integrity across financial systems, and bridging the gap between business needs and technical solutions. The ideal candidate will possess strong analysis and troubleshooting skills, systems configuration, and maintenance capabilities, drive successful outcomes, and the ability to work collaboratively across finance and technology teams in a fast-paced, deadline-driven environment.
Position Responsibilities:
Support month end close during first 5 business days of the month by processing all instrument data for financial reporting in various financial systems applications (e.g. Oracle OFSAA, Workday, Adaptive)
Lead monthly maintenance to ensure the system is prepared for month end processing.
Create SQL's to perform data analysis, check trends and investigate data discrepancies
Configure new and update existing SQL rules, data quality groups, allocation rules and models
Collaborate with technology to troubleshoot job failures, reload data, identify source logic
Partner with business Finance users to investigate data trends and discrepancies
Serve as a mediary between business and technology to collect business requirements and translate them to technical solutions
Subject Matter Expert for all Financial Systems and lead projects, enhancements, and initiatives
Analyze current business processes and systems to identify inefficiencies and recommend innovative solutions
Conduct system testing, UAT and validation
Position Qualifications:
Bachelor's degree from an accredited university in management information systems, Information Technology, Computer Science, Finance, or four years of relevant work experience.
2 years of experience in Excel functions, system analysis, and eliciting business requirements
2 years of experience in software troubleshooting and root cause analysis
1 year of experience with data analysis and interpreting errors through various querying tools such SQL
Work Best Category: Category C - Days in the office will either be designated days or will vary week to week from 2-5 days
Hours: 8:00am - 5:00pm Monday - Friday
Salary: To Be Determined Based on Individual Experience
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. Your fingerprints will be used to check the criminal history records of the FBI and may be subscribed in the FBI's Record of Arrest and Prosecution Background ("RAP Back") service, which provides ongoing notification to the Company of any updates to your criminal history.
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 - disability/veteran.
Comerica is proud to be an Equal Opportunity Employer - veterans/individuals with disabilities, committed to workplace diversity.
