A strong data integration background, with knowledge of Investment business operations (Front, Middle and Back-Office).
Familiar with all aspects of the Eagle PACE warehouse, including scheduling, report writing, data stewardship, portal, and data model/schemas.
Familiar with Eagle v2017 Modules (Portfolio Data Center, Message Center, Automation Center, Scheduler, Workflow Manager, Reference Data Center, Recon Center, etc.).
Builds complex SQL queries against base and aggregate tables.
Participates in the design, development, and integration of Investment databases.
Design, implement and deploy the data pipelines to transform (structure and map) vendor data into Investments systems.
Stay current with data vendor product offerings and how they may be used by Investments and assisting with tool selection.
Manage and enhance investment data infrastructure through initiatives such as improving data integrity and quality with every release
Work in a fast-paced environment collaborating with business users, engineers, architects, and analysts.
Maintain data management standards to ensure that new data entities get implemented in the data model using schemas that are appropriate for their use, facilitating good performance and analytics needs.
Perform Eagle maintenance release including pre and post data and software validation.
Provide input to our framework team for enhancing the tools we utilize.
Develops technical designs and specifications for complex file data pipelines/data flows and document file data migrations.
Leverage creativity to solve complex data and business problems.
Documents data dictionary and data mapping/transformation rules.
Works extensively with business analysts and investment professionals to analyze business problems.
Supports daily activity of the investment control systems areas by creating and maintaining custom reports and programs and by providing technical support for system and software issues.
Assists customer in creating and running test scripts for data loads and report development.