Allied Consultants, Inc. ยท 1 day ago
Data Architect
Austin, Texas Metropolitan Area
Contract
Hybrid
Senior Level
5+ years expAllied Consultants, Inc. is a premier provider of technical and business staffing solutions. They are currently seeking an experienced Data Architect to be a key resource on a technical services team for their client, the Employees Retirement Systems (ERS), focusing on data integration and investment systems.
ConsultingEnterprise Resource Planning (ERP)Information TechnologySoftware
Hiring Manager
Carli Powell
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
Qualification
Required
Graduation from an accredited four- years college or university. Each year of related experience over the required may be substituted for one year (30 semester hours) of required college credit
Strong communication and collaboration skills and good documentation habits
Demonstrated experience with orchestration and automation of database processes
Knowledge in Investments Accounting and Data Domains and Platforms
5 years of Data analysis and data modeling/architecture experience
5 years of SQL experience
5 years of 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
4 years of Experience working in Eagle PACE as a data integrator implementing data pipelines
Preferred
Prefer experience in general accounting, investment accounting, account reconciliation, and writing procedures
Benefits
Medical insurance (Allied shares a percentage of the cost)
Life insurance
A matching 401(k) plan
A cafeteria plan
Company
Allied Consultants, Inc.
Allied Consultants, Inc (Allied), helps organizations determine what technology they need and how best to employ it.
51-200 employees
H1B Sponsorship
Allied Consultants, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2022 (3)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase