Data Architect - Investments (Eagle PACE)

Data Architect - Investments (Eagle PACE)

[Austin, TX / Hybrid / Onsite as applicable] local or close only

All visa (no H1 and opt)

Data Architect with 5+ years SQL, ETL, data modeling/architecture, Eagle PACE experience, investment systems knowledge, data pipeline development, and strong communication/documentation skills.

Data Architect to join a high-impact product team supporting enterprise Investments data initiatives. In this role, you will help build and evolve a trusted, integrated, and scalable data infrastructure that enables data-driven decision making across the Investments organization.

You'll play a central role in shaping the Investments data strategy, maintaining and enhancing the Investment Data Warehouse, optimizing Portfolio Management applications, and driving continuous improvement in data quality, reporting, and governance.

This role is ideal for candidates with deep Eagle PACE experience, strong SQL and ETL skills, and a passion for solving complex data challenges in a dynamic financial environment.

Key Responsibilities

Data Architecture & Integration

Design, develop, and integrate Investment databases and data models.

Build advanced SQL queries against base and aggregate tables.

Develop data pipelines to transform vendor data into Investment systems.

Maintain data management standards ensuring proper schema design for performance and analytics.

Eagle PACE & Investment Systems Support

Hands-on work with Eagle PACE warehouse components including scheduling, reporting, stewardship, schemas, and portals.

Utilize Eagle v2017 modules: Portfolio Data Center, Message Center, Automation Center, Scheduler, Workflow Manager, Reference Data Center, Recon Center, etc.

Execute and validate Eagle maintenance releases with pre- and post-data/software validations.

Provide technical support to investment control systems including report/program creation and troubleshooting. Required Qualifications

5+ years experience in data analysis, data modeling, or data architecture

5+ years SQL development experience

5+ years ETL design and implementation for complex multi-source models

4+ years Eagle database environment experience, including schema architecture

4+ years working in Eagle PACE as a data integrator building data pipelines

Proven experience with orchestration and automation of database processes

Bachelor's degree from an accredited four-year institution (or relevant experience)

Strong communication, collaboration, and documentation skills Preferred Skills & Experience

Background in investment accounting, general accounting, reconciliation, or procedure documentation

Understanding of data marts, ETL concepts, and data warehousing principles

Experience with:

Crystal Reports

.NET (VB or C#)

MS SQL Server, Oracle

MS Access/Excel

FIX, SWIFT, XML

IWS/Eagle ML

Experience implementing Eagle STAR/PACE software upgrades

Strong aptitude for troubleshooting and problem-solving

Ability to explain complex technical concepts to non-technical audiences

Comfortable working in Agile environments and with DevOps/DataOps practices (CI/CD)