Investment Systems Senior Engineer

Colorado PERA; Denver (CO); Hybrid; USD 125,000 - 150,000; Full time

Benefits offered by this job

Hybrid work option

Work from home after orientation

Job summary

Colorado PERA seeks an experienced technical lead to drive development of investment systems and data platforms (FundHub, ICS Athena, Portia, Longview, PACE) using Python, SQL and PowerShell. You will lead solution design, complex data transformations, and lean delivery across CI/CD workflows.

You will mentor the team, coordinate with IT and Investment SMEs, and ensure robust, scalable, secure solutions for investment decision-making. Hybrid work with on-site Denver-based duties available.

Qualifications

• 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

Responsibilities

• Owns large investment projects by providing analysis, development, testing, and deployment; contributes to larger initiatives through effective collaboration with IT and Investment SMEs.
• Leads technical solutioning, design and development activities as well as implementation of complex system enhancements.
• Develops the most complex data transformations and logic; optimizes Snowflake performance and ensures data Lean-ness.
• Translates architectural designs into complex technical builds; leads the technical delivery of major projects and peer-reviews all designs for Lean efficiency.
• Defines technical documentation standards; ensures the team's knowledge base is accurate, searchable, and audit-ready.

Skills

SQL

Python

PowerShell

Data Transformation

CI/CD

Education

Bachelor's degree in STEM

Tools

Snowflake

Power BI

ELT

Job description

Job Details

Level: Experienced

Location: Penn Center - Denver, CO 80203

Position Type: Full Time

Salary Range: $125,000.00 - $150,000.00

Job Shift: Day

Job Category: Information Technology

Summary of Job Responsibilities

You will lead development activities of critical Investment systems/platforms (FundHub,ICS Athena,Portia,Longview,PACE) and supporting Investments data and orchestration platforms (PowerBI,Snowflake,ELT,Automic), by leveraging Python, SQL, PowerShell and other development and scripting languages to build and optimize robust strategic solutions. Applying Lean Development principles, you will deliver quality flexible solutions quickly that can be leveraged throughout PERA. You will lead technical solutioning, design and development activities as well as the implementation of complex system enhancements that directly enable the Investment Team’s decision-making.

Essential Duties and Responsibilities

Employees are held accountable for all duties of the job. Individuals must be able to perform these duties with or without reasonable accommodation.

Systems Engineering & Project Ownership

Owns large investment projects by providing analysis, development, testing, and deployment; contributes to larger initiatives through effective collaboration with IT and Investment SMEs.

Platform Management

Manages and maintains key investment development platforms leveraging CI/DC to deliver robust investment solutions.

Technical Solutioning

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.

Technical Design

Leads technical approach discussions and independently develops/proposes designs for complex developments that meet established standards.

Lead Implementation

Translates architectural designs into complex technical builds. Leads the technical delivery of major projects and peer-reviews all designs for "Lean" efficiency.

Complex Data Logic

Develops the most complex data transformations and logic. Optimizes Snowflake performance and ensures data "Lean-ness" (minimizing redundant data).

Operational Support & Stability

Troubleshooting Troubleshoots daily investment systems/data issues (Tier1/Tier2) and resolves incidents (dependent on level: common issues / most issues / all issues without escalation).

Operational Excellence

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.

Vendor Coordination

Acts as a technical liaison or Subject Matter Expert (Engineer/Senior) when working with vendors to resolve complex application or integration issues.

GovernanceData Governance

Defines solutions that support data quality, data linage, data access control, certified datasets to ensure trust in data assets.

Security

Ensures that new Investment systems and development adhere to secure authentication and compliant access control policies.

Documentation

Develops and maintains high-quality technical requirements, solutioning, development, system support, and troubleshooting documentation.

Process Governance

Defines technical documentation standards. Ensures the team's technical knowledge base is accurate, searchable, and audit-ready.

Knowledge & Leadership

Technical Expertise Maintains an in-depth understanding of the firm’s investment application systems, business functions across asset classes, and underlying network/database environments.

Mentorship

Shares technical and institutional knowledge with the team, leading training and brainstorming sessions to drive continuous improvement.

Continuous Learning

Proactively stays current on evolving investment technologies and industry best practices through frequent technical training.

Technical Liaison

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.

Job Qualifications

• 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

Preferred Qualifications

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

Working Conditions

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Standard office environment with frequent telephone communication, computer operation, and other office productivity machinery, such as a copy and printer machine. Occasional moving and positioning of supplies in excess of 20 poundsAll employees are expected to present themselves in a professional manner in alignment with the financial services industryAbility to sit for prolonged periods of timeAbility to operate standard PC equipmentAbility to manage frequent deadlines and tight schedules.

Hybrid Work Option

Opportunity to work from home up to three days per week after orientation and training, subject to performance and manager approval. Eligibility is dependent upon factors detailed in PERA's Work from Home Policy.

Job Description Disclaimer

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of an employee. Duties, responsibilities, and activities may change or be assigned with or without notice. Unfortunately, at this time, PERA cannot consider candidates that require sponsorship (now or in the future), or are located outside of the US. All Colorado PERA employees are subject to PERA’s Ethics Policy and some employees are subject to the Personal Trading Policy. These policies include restrictions on outside business activities and employment and have certain requirements on personal trading. You may request copies of these policies from PERA’s talent acquisition team and any questions can be answered by PERA’s Investment Administration team.

Why Work at PERA

Colorado PERA offers more than a traditional pension career. We are a mission-driven organization with a growing focus on technology and modernization. Employees have the opportunity to do meaningful work with a real impact on over 700,000 members. From enhancing digital tools and member experiences to supporting major enterprise initiatives, employees are part of meaningful, future-focused work that blends public service with innovation. We take pride in our inclusive culture, career development opportunities, and our consistent recognition as a Top Workplace based on employee feedback. PERA is a place to connect, contribute, and be part of something bigger.

A Culture That Cares

At PERA, leveraging employee strengths and supporting strong engagement are the foundations of our culture. Employees are encouraged to grow through development opportunities and internal career movement, while also being part of an organization where people feel respected, informed, and included. Collaboration is encouraged across teams, allowing employees to learn from one another and contribute in ways that maximize their unique skills. We strive to foster an environment where employees can do their best work and feel supported by the people around them.

An Employer that Invests in You

PERA invests in our employees in ways that matter; from comprehensive benefits and generous paid time-off to thoughtful everyday amenities that enhance the office experience. Employees are encouraged to continue learning through training, mentoring, and development at every stage of their careers. We champion a workplace where people feel valued, inspired, and equipped to grow.

Join Us

If you’re energized by meaningful work, motivated by an organization that evolves with a changing world and looking for an employer that invests in you, then consider joining PERA’s team. Learn more about careers at PERA at copera.org/careers.