Job Summary
As an Associate within the CAO Data Solutions team, you will learn about all the datasets contained within our Oracle reporting database and the Cognos report writing application to provide the requested solutions. You will provide the right solution, which will require an understanding of the data gap we are being asked to solve as well as an understanding of the appropriate golden source to address the need. This will require some engagement with the requestor as well as relevant subject matter experts both from within the associated business functions as well as related technology teams. Most of these requests will be associated with suppliers and Inter-Affiliate services, and the data maintained involving those entities and activities.
Job Responsibilities
- Manage ad-hoc data requests as submitted through the firm’s Advancing Analytics & Automation (AAA) @ CAO SharePoint site – these requests may be used in internal and external audits and exams
- Identify where these requests require recurring delivery, and building and maintaining schedules necessary to deliver these reports with minimal on-going manual intervention
- Enhance a level of subject matter knowledge that can be leveraged to provide guidance and validation around the appropriateness of using certain data from certain sources in providing the requested solution
- Provide testing support for data solutions created by others on our team as well as by our tech partners to ensure the proper data quality and appropriateness of developed solution
- Assist in report remediation and regression testing that may be required as a result of changes in upstream systems supplying key data used in our reports
- Participate as time allows on other strategic DSGBI projects, including but not limited to efforts to move Oracle database to the cloud and urgent regulatory demand
Required qualifications, capabilities and skills:
- Bachelors in Accounting, Finance, Management Information Systems or related discipline
- Minimum 3+ years of experience in Financial Services reporting, data and analytics or business analysis roles
- Experience in building and enhancing reports using the Cognos reporting tool
- Strong advocate for data quality and integrity
- Ability to dig in and understand data issues and use that knowledge to effectively operationalize recurring review processes
- Ability to manage multiple tasks simultaneously to plan, organize, prioritize and execute to hit multiple conflicting timelines
- Ability to operate in a collaborative and cooperative environment, and must possess the strong interpersonal skills necessary to work effectively and communicate effectively with colleagues at various levels of the organization
- Adapts well to changing scope and complexity of work brought on by business growth
- Highly Proficient in Excel and strong MS