Data Architect

Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Data Architect to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.  Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

**Location of job: Hybrid. Candidates must be local to Austin, TX**

• 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

Additional Skills:

• Prefer experience in general accounting, investment accounting, account reconciliation, and writing procedures
• Financial knowledge in investment banking and accounting.
• Understanding of data mart structures, ETL processes, and data warehousing concepts
• Desire to work in an Agile environment and use DevOps / DataOps practices such as continuous integration, continuous delivery, and continuous deployment
• Hands on and extensive experience with many of the following technologies: Crystal Reports,
• .Net (VB or C#), MS SQL Server, Oracle, MS Access/Excel. FIX, SWIFT, and XML, IWS/Eagle ML
• Strong communication, presentation and interpersonal skills
• Proficient ability to explain technical information to a non-technical audience
• Ability to learn new concepts, systems, and software independently and quickly
• Willingness to take initiative, seeing problems through to final completion
• The ability handle diverse situations and rapidly changing priorities with deadlines
• Demonstrated experience with implementation of Eagle STAR/PACE software upgrades.
• Strong aptitude for troubleshooting and problem solving

Minimum (Required):

Preferred (Optional):