Investment Systems Senior Engineer

Colorado Public Employees' Retirement Association•Denver, CO

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

About The Position

The Investment Systems Senior Engineer leads development and technical delivery for critical investment systems and platforms, including FundHub, ICS Athena, Portia, Longview, and PACE, as well as supporting investment data and orchestration platforms such as Power BI, Snowflake, ELT, and Automic. Using Python, SQL, PowerShell, and other development and scripting languages, the engineer builds and optimizes robust strategic solutions. Applying Lean Development principles, the role delivers flexible, high-quality solutions that can be leveraged across PERA and enables investment decision-making through complex system enhancements. The position owns large investment projects from analysis and development through testing and deployment, leads technical solutioning and design, and translates architectural designs into complex builds. It also manages and maintains investment development platforms, develops complex data transformations, optimizes Snowflake performance, and supports operational stability through troubleshooting, incident resolution, monitoring, and automated recovery. The engineer works with an Architect to reduce technical debt and serves as a technical liaison with vendors and stakeholders. The role supports data governance, security, and reliable technical documentation; maintains deep knowledge of investment applications and business functions; and mentors colleagues through knowledge sharing, training, and brainstorming. The position is based in a standard office environment in Denver, Colorado, with an option to work from home up to three days per week after orientation and training, subject to performance, manager approval, and PERA policy. This is a full-time, exempt position reporting to the Investments Technical Services Manager II.

Requirements

Mastery of SQL and Python or PowerShell.
Experience with system architecture and Snowflake data modeling.
A degree in a technical (STEM) field and four years of experience in a technical role are preferred, or an equivalent combination of education and experience.
Must be able to perform essential job functions with or without reasonable accommodation.
Must be able to manage frequent deadlines and tight schedules.
Candidates requiring sponsorship now or in the future, or located outside the United States, cannot be considered.

Nice To Haves

In-depth institutional knowledge of investment systems and complex business functions.
A technical (STEM) degree and four years of experience in a technical role, or an equivalent combination of education and experience.
Experience with system architecture and Snowflake data modeling.

Responsibilities

Own large investment projects by providing analysis, development, testing, and deployment, and contribute to broader initiatives in collaboration with IT and Investment subject-matter experts.
Manage and maintain key investment development platforms, leveraging CI/CD to deliver robust investment solutions.
Develop optimal, scalable, robust, and maintainable technical solutions aligned with Investment business needs and strategic initiatives.
Lead technical approach discussions and independently develop or propose designs for complex developments that meet established standards.
Translate architectural designs into complex technical builds; lead technical delivery of major projects and peer-review designs for Lean efficiency.
Develop complex data transformations and logic, optimize Snowflake performance, and minimize redundant data.
Troubleshoot daily investment systems and data issues and resolve incidents.
Lead stability across the application suite by identifying systemic risks and developing automated recovery and monitoring solutions.
Work with the Architect to optimize systems and reduce technical debt.
Serve as a technical liaison or subject-matter expert with vendors to resolve complex application or integration issues.
Define solutions supporting data quality, data lineage, data access control, and certified datasets.
Ensure new Investment systems and development follow secure authentication and compliant access-control policies.
Develop and maintain technical requirements, solutioning, development, system support, and troubleshooting documentation.
Define technical documentation standards and keep the team's technical knowledge base accurate, searchable, and audit-ready.
Maintain in-depth knowledge of investment applications, business functions across asset classes, and underlying network and database environments.
Share technical and institutional knowledge, lead training and brainstorming sessions, and mentor junior staff in solutioning, design, and troubleshooting practices.
Stay current on investment technologies and industry best practices through technical training.
Act as the primary bridge between Investment Team needs and technical execution, managing project scope and senior stakeholder expectations.
Perform other duties as assigned.