Peak Performers · 2 days ago
Senior Investment Data Integration Engineer
Peak Performers has partnered with a Texas State Agency to assist in their search for a hybrid Sr. Investment Data Integration Engineer. In this position, you will be responsible for building a trusted, integrated, and scalable information infrastructure that transforms complex Investments data into valued insights for data-informed decisions.
Employment
Responsibilities
Build complex SQL queries against base and aggregate tables
Participate 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
Develop 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
Document data dictionary and data mapping/transformation rules
Work extensively with business analysts and investment professionals to analyze business problems
Support 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
Assist customer in creating and running test scripts for data loads and report development
Qualification
Required
Graduation from an accredited four-year college or university. Each year of related experience over the required may be substituted for one year 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
Benefits
Excellent medical health, dental & vision insurance at 60 days
Our employees may choose to participate in a 403(b) retirement plan
We pay weekly through direct deposit