Data Architect 1

Role: Data Architect 1Location: Austin, Texas 78701 (Hybrid, onsite 2 days/week)Duration: 6 months Contract with possibility to extension

As a member of a product team, you will build a trusted, integrated, and scalable information infrastructure that transforms complex Investments data into valued insights for data-informed decisions. The role takes on a key part in building out Client’s Investments data strategy to support strategic initiatives. It is an essential for the sustainability and advancement of the Investment Data Warehouse and optimization of Portfolio Management data applications. The candidate is capable of aiding report development and organizational adaption of Investment platforms and expected to contribute to agency’s process improvement in its sustained data management program, including data quality, reporting, and change management activities.

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/schemasFamiliar 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 tablesParticipates in the design, development, and integration of Investment databasesDesign, 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 releaseWork 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 needsPerform Eagle maintenance release including pre and post data and software validationProvide input to our framework team for enhancing the tools we utilizeDevelops technical designs and specifications for complex file data pipelines/data flows and document file data migrationsLeverage creativity to solve complex data and business problemsDocuments data dictionary and data mapping/transformation rulesWorks extensively with business analysts and investment professionals to analyze business problemsSupports 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 issuesAssists 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 proceduresFinancial knowledge in investment banking and accounting.Understanding of data mart structures, ETL processes, and data warehousing conceptsDesire to work in an Agile environment and use DevOps / DataOps practices such as continuous integration, continuous delivery, and continuous deploymentHands 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 MLStrong communication, presentation and interpersonal skillsProficient ability to explain technical information to a non-technical audienceAbility to learn new concepts, systems, and software independently and quicklyWillingness to take initiative, seeing problems through to final completionThe ability handle diverse situations and rapidly changing priorities with deadlinesDemonstrated experience with implementation of Eagle STAR/PACE software upgrades.Strong aptitude for troubleshooting and problem solving

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 credit5 years data analysis and data modeling/architecture experience5 years SQL experience5 years’ experience designing and implementing ETL technical solutions for complex data models using multiple data sources4 years of experience with Eagle database environment including schema architectureStrong 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.