Investment Systems Senior Engineer

Colorado Public Employees' Retirement Association • Denver, CO

8d • Hybrid

About The Position

This role involves taking ownership of critical investment systems and platforms such as Portia, Longview, PACE, Automic, Power BI, and Snowflake. The engineer will leverage scripting languages like Python, SQL, and PowerShell to build and optimize data pipelines, ensuring timely operational data loads. A key aspect of the role is applying Lean principles to eliminate waste through root-cause analysis and automation of manual processes, thereby improving daily operations. The position also entails leading technical solutioning, design activities, and the implementation of system enhancements to support the Investment Team's decision-making. As part of a 24/7 on-call rotation, the engineer will be responsible for maintaining the high reliability and performance of vital financial technology systems.

Requirements

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

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 platforms (Portia, Longview, PACE, Power BI, Athena) and utilizes automation and data transformation tools (Python, SQL, Snowflake, PowerShell, and orchestration tools) to improve process robustness.
• 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.
• Participates in the 24/7 investment systems on-call rotation, taking tenacious ownership of system stability and minimizing downtime.
• Educates and trains non-senior staff to handle on-call rotation.
• Documents new fixes discovered during the shift to improve the team's knowledge.
• Conducts post-incident "Lean" reviews to ensure the same issue never happens twice.
• 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.
• Administers and patches investment application servers and database environments.
• Administers investment system users and roles, ensuring secure authentication and compliant access control.
• Develops and maintains high-quality system support, troubleshooting, and Standard Operating Procedure (SOP) 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.
• Acts as a technical liaison or Subject Matter Expert (Engineer/Senior) when working with vendors to resolve complex application or integration issues.

Benefits

• health, dental and vision coverage
• generous paid time off and volunteer hours
• pension and retirement plans, including PERA’s defined benefit plan, 457 defined contribution plan, and 401(k) employer match, as applicable
• tuition assistance
• free, convenient on-site parking or RTD subsidy
• free on-site fitness center
• employee assistance program
• training, leadership and mentoring programs

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed