Citizens Bank Analysis and Reporting Senior Analyst in Riverside, Rhode Island
This is a senior reporting developer/analyst position. The successful candidate will combine exceptional business analysis skills with advanced report development capability. He/she will not only develop the code, but will also be working with the business stakeholders on reporting requirements, be able to validate report’s output and deliver it for review to the business user with no or minimal follow up required; thus, owning the report’s lifecycle end-to-end. Primary responsibilities include:• Working closely with Commercial Loan Operations colleagues and business line partners to identify reporting needs and offer solutions • Developing complex reports using SQL or MS Access queries and new SQL views in Teradata environment• Independently translating business requirements into technical specifications to either develop reports or hand off to other developers within the team • Designing, developing, modifying, debugging and evaluating existing production and/or ad-hoc reports using data from commercial loan servicing systems• Assisting with data analysis and defect identification for commercial loans: sourcing test data, helping with logistics for data queries to uncover data discrepancies, and communicating results to users to ensure proper cleanup or further action• Testing upgrades related to Oracle BI, Teradata, data loads, application releases and disaster recovery exercises• Driving small initiatives and representing the team in larger-scale enterprise projects• Recommending changes in development, maintenance and systems related to commercial loans• Participating in internal, external and regulatory audit activities by pulling data necessary for successful testing efforts and resolution of issues• Providing automation solutions to speed up and streamline ongoing initiatives and projects• Using understanding of the principles of large datamarts, such as Teradata and Oracle, use Oracle Business Intelligence tool and ETL processes to work with Technology teams to resolve issues and test upgrades.• Troubleshooting production issues related to data loads and report distribution• Working directly with multiple stakeholders, delivering world-class customer service to all users
• At least 7 years experience of reporting in a development capacity • At least 3 years experience in business analysis• Strong problem-solving and time-management skills, a superior customer service orientation and advanced analytical capability • The ability to multi-task and function efficiently in a high-volume, fast-paced environment • Solid working knowledge of database principles and concepts • Solid written, verbal and interpersonal skills, as well as the ability to support others through training and coaching• Intermediate-to-advanced level in MS Access• Advanced SQL development skills• Working knowledge/experience with Teradata SQL, Oracle Business Intelligence, Cognos, MS Access and Excel • Experience working with commercial banking data is preferred• Experience with Oracle BIEE G11 or other business intelligence tools• Familiarity with Oracle database principles• Understanding business processes, accounting, and loan processing/serving nuances in order to develop correct reportsEducation:Bachelor's Degree PreferredHours and Work Schedule:Hours per week: 40Work schedule: Monday - Friday 8am - 5 pm#LI-CC1
Why Work for Us
At Citizens, you'll find a customer-centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth.
Equal Employment Opportunity
It is the policy of Citizens Bank to provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to race, color, ethnicity, religion, gender, pregnancy/childbirth, age, national origin, sexual orientation, gender identity or expression, disability or perceived disability, genetic information, citizenship, veteran or military status, marital or domestic partner status, or any other category protected by federal, state and/or local laws.
Equal Employment and Opportunity Employer/Disabled/Veteran
Citizens Bank is a brand name of Citizens Bank, N.A. and each of its respective subsidiaries.
- Citizens Bank Jobs