Data Architect with Eagle pace/eagle star experience

Location: Local to Austin, TX - hybrid

Long-term Contract role

• Client: State of Texas -ERS Department

DESCRIPTION OF SERVICES: The Employees Retirement System of Texas requests the services of 1 Data Architects, hereafter referred to as Worker, who meets the general qualifications of Data Architects and the specifications outlined in this document.

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

Grace,

Technical Recruiter

American Unit Inc

Email: Grace@americanunit.com

Tel: 214-556-0117

Job Type: Contract

Pay: Up to $80.00 per hour

Expected hours: 40 per week

Experience level:

• 10 years
• 11 years
• 9 years

Schedule:

• 8 hour shift

Work Location: In person