Job Openings - ERS (Database) Data Architect 1
Location: Austin, Texas - HYBRID (LOCAL CANDIDATES ONLY)
Minimum Requirements:
Graduation from an accredited four-year college or university.
Each year of related experience over the required may be substituted for one year (30
semester hours) of required college credit
5 years data analysis and data modeling/architecture experience
5 years SQL experience
5 years experience designing and implementing ETL technical solutions for complex data
models using multiple data sources
4 years of experience with Eagle database environment including schema architecture
Strong communication and collaboration skills and good documentation habits.
Demonstrated experience with orchestration and automation of database processes.
4+ years' experience working in Eagle PACE as a data integrator implementing data pipelines
Functional Responsibilities:
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
Never miss an opportunity! Create an alert based on the job you applied for.
