Looking for, Data Management Reporting Analyst || Auburn Hills, MI at Auburn, Pennsylvania, USA |
Email: [email protected] |
From: Mayank, Pivotal Technologies [email protected] Reply to: [email protected] Role: Data Management Reporting Analyst Visa : No H1/OPT Location/Onsite requirements: 2 days onsite required a week starting in Oaktec location and then moving to GLC. Oaktec: 3551 Hamlin Rd., Auburn Hills, MI 48326 GLC (Great Lakes Campus): 36455 & 36555 Corporate Dr. Farmington Hills, MI *opening Q1 2024 MUST: Mainframe JCL SAS SAS EG Hyperion TOAD- SQL Cognos PowerBI Job Summary Manage databases, programs, process streams and reports that are utilized to convert raw data from the banks application systems as well as vendor provided demographic and competitive pricing information into consumable information for Retail Bank management. Create Scorecards and Leaderboards. Generates reports and provides analyses within one of 5 reporting domains (Deposit Products, Payment and Electronic Services, Loan Products, Customer, and Access Points and Compliance) to support business decisions in the Retail Bank, including Retail Product Management, Banking Center Network Management, Market Operations, Retail Sales & Banking Centers and Business Banking. Prepares data utilizing standardization and normalization techniquesensuring consistency and reliability in all reports generated. Creates new reporting processes, automates manual processes, maintains and executes scheduled reporting processes, and most importantly validates results first, and then provides insight on metric trends, changes, and cause and effect relationships. Individual is a subject matter expert within their reporting domain frequently required to provide information and insight to the Finance, Commercial Bank, and Wealth Management divisions of the bank. Job Specific In-depth knowledge of application system data availability within their reporting domain, including Comerica application systems CIS, DDA, TDA, CLN, PLN, CBM, HBK, MOB, WBP, DWH, DSS, and OFSA, as well vendor software and data: ERSI ArcGIS, Informa, SNA, Claritas, and finally public information FDIC Summary of Deposits!! Proficient programming skills and data extraction tool knowledge required within their reporting domain including mainframe JCL, mainframe SAS, SAS EG, Hyperion, Toad SQL, and Cognos!! Proficient knowledge of advanced functionality in MS Office products. Most importantly Power BI,Access and Excel followed by Power Point and Word!! Acute attention to the details and validation steps in each reporting process!! Advanced project management skills, including time management / prioritization, managing and measuring work, and communicating results and status!! Experience analyzing data and developing management reports and tools!! Experience leading and independently representing Retail on project teams!! Experience developing and delivering professional presentations Thanks & Regards, Mayank Mer Technical Recruiter https://www.linkedin.com/in/mayank-mer-405972114/ Keywords: business intelligence microsoft Michigan |
[email protected] View all |
Tue Oct 17 18:53:00 UTC 2023 |