Investment Systems Senior Engineer

Colorado Public Employees' Retirement Association•Denver, CO

8d•$125,000 - $150,000•Hybrid

About The Position

This role involves leading the development activities for critical Investment systems and platforms, including FundHub, ICS Athena, Portia, Longview, and PACE, as well as supporting Investments data and orchestration platforms like Power BI, Snowflake, ELT, and Automic. The engineer will leverage Python, SQL, and PowerShell to build and optimize strategic solutions, applying Lean Development principles to deliver quality, flexible solutions efficiently. The position requires leading technical solutioning, design, and development for complex system enhancements that support the Investment Team's decision-making.

Requirements

Degree in technical (STEM) field and four years experience in technical role preferred, or equivalent combination of education and experience.
Mastery of SQL and Python/PowerShell.
Experience with system architecture and Snowflake data modeling.

Nice To Haves

In depth institutional knowledge of investment systems and complex business functions.

Responsibilities

Owns large investment projects by providing analysis, development, testing, and deployment; contributes to larger initiatives through effective collaboration with IT and Investment SMEs.
Manages and maintains key investment development platforms leveraging CI/DC to deliver robust investment solutions.
Leverages deep understanding of Investments business needs to develop optimal solutions using current and new technologies and platforms to deliver highly scalable, robust and maintainable projects aligned with strategic initiatives.
Leads technical approach discussions and independently develops/proposes designs for complex developments that meet established standards.
Translates architectural designs into complex technical builds.
Leads the technical delivery of major projects and peer-reviews all designs for "Lean" efficiency.
Develops the most complex data transformations and logic.
Optimizes Snowflake performance and ensures data "Lean-ness" (minimizing redundant data).
Troubleshoots daily investment systems/data issues (Tier 1/Tier 2) and resolves incidents.
Leads the stability of the entire application suite.
Proactively identifies systemic risks and builds automated recovery/monitoring solutions.
Works with the Architect to optimize and reduce technical debt.
Acts as a technical liaison or Subject Matter Expert (Engineer/Senior) when working with vendors to resolve complex application or integration issues.
Defines solutions that support data quality, data linage, data access control, certified datasets to ensure trust in data assets.
Ensures that new Investment systems and development adhere to secure authentication and compliant access control policies.
Develops and maintains high-quality technical requirements, solutioning, development, system support, and troubleshooting documentation.
Defines technical documentation standards.
Ensures the team's technical knowledge base is accurate, searchable, and audit-ready.
Maintains an in-depth understanding of the firm’s investment application systems, business functions across asset classes, and underlying network/database environments.
Shares technical and institutional knowledge with the team, leading training and brainstorming sessions to drive continuous improvement.
Proactively stays current on evolving investment technologies and industry best practices through frequent technical training.
Acts as the primary bridge between the Investment Team's needs and technical execution.
Manages project scope and senior stakeholder expectations.
Performs other duties as assigned.