Data Architect with Eagle Pace/eagle Star Exp - Austin, United States - American Unit Inc
Description
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 fouryear college or university.
- 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 fastpaced 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
Tel:
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
More jobs from American Unit Inc
-
Solutions Architect
Overland Park, United States - 3 weeks ago
-
OnBase Specialist
Michigan, United States - 2 weeks ago
-
Solution Architect
Atlanta, United States - 1 week ago
-
Data Analyst
McLean, United States - 4 weeks ago
-
Snap Logic Developer
Durham, United States - 2 weeks ago
-
Java Full Stack Developer
McLean, United States - 4 weeks ago