Investment Systems Engineer

Colorado Public Employees' Retirement Association • Denver, CO

1d • $108,000 - $134,000 • Hybrid

About The Position

The Investment Systems Engineer owns and supports critical investment systems and platforms, including Portia, Longview, PACE, Ascend, Power BI, Athena, Automic, and Snowflake. The role uses Python, SQL, PowerShell, and other scripting and automation tools to build and optimize data pipelines, strengthen platform operations, and improve system reliability. Applying Lean principles, the engineer performs root-cause analysis and automates manual processes to reduce operational waste. The position contributes to technical designs and leads implementation of system enhancements that support the Investment Team’s decision-making.

The engineer provides production support for investment applications and data, administers and patches application servers and database environments, manages users and access controls, and maintains support documentation and procedures. The role participates in a 24/7 on-call rotation, code reviews, and incident post-mortems, and may act as a technical liaison with vendors. The position requires ongoing technical learning and an understanding of investment workflows, asset classes, and the underlying network and database environments.

This is a full-time, exempt role based in Denver, Colorado, with a hybrid work option of up to three days working from home per week after orientation and training, subject to performance, manager approval, and PERA policy. The work is performed in a standard office environment and involves computer and telephone use, prolonged sitting, and occasional movement or positioning of supplies weighing more than 20 pounds. Candidates must be located in the United States and must not require current or future sponsorship.

Requirements

• A technical (STEM) degree and two years of experience in a technical role are preferred, or an equivalent combination of education and experience.
• Advanced SQL proficiency, including complex queries, performance tuning, and database object management in enterprise environments such as Snowflake, SQL Server, or Oracle.
• Understanding of investment workflows and asset classes.
• Strong Python experience in data manipulation, API integrations, and automation.
• Strong PowerShell experience in Windows Server administration and automated batch processing.
• Hands-on experience designing, scheduling, and troubleshooting complex, multi-step enterprise workload automation job streams using tools such as Broadcom Automic/UC4, Airflow, or equivalent, including native scripting and conditional logic.
• Experience supporting and maintaining production enterprise applications, underlying Windows servers, and vendor-hosted or SaaS integrations, including REST APIs, SFTP interfaces, cloud-assisted data movements, and routine maintenance or upgrades.
• Experience managing and troubleshooting operating systems, servers, and storage, and using automation for platform management.
• Ability to attend technical training related to core-stack development and current system-support duties.
• Expertise in key technologies or platforms within the relevant stack.
• Ability to perform essential duties with or without reasonable accommodation.
• Must be located in the United States and must not require sponsorship now or in the future.

Nice To Haves

• A technical (STEM) degree and two years of experience in a technical role; equivalent combinations of education and experience are also considered.
• Experience with Broadcom Automic/UC4, Airflow, or equivalent enterprise workload orchestration tools.

Responsibilities

• Own medium-sized investment systems projects, including analysis, development, testing, and deployment; contribute to larger initiatives with IT and Investment subject matter experts.
• Manage and maintain investment platforms, including Portia, Longview, PACE, Ascend, Power BI, and Athena.
• Use Python, SQL, Snowflake, PowerShell, and orchestration or data transformation tools to improve the robustness of processes and data pipelines.
• Contribute to technical approach discussions and independently develop or propose designs for straightforward enhancements that meet established standards.
• Troubleshoot daily investment systems and data issues at Tier 1 and Tier 2 levels and resolve incidents.
• Participate in the 24/7 investment systems on-call rotation and take ownership of system stability and minimizing downtime.
• Administer and patch investment application servers and database environments to maintain availability for development.
• Administer investment-system users and roles and ensure secure authentication and compliant access controls.
• Develop and maintain system-support, troubleshooting, and Standard Operating Procedure documentation.
• Maintain knowledge of investment applications, business functions across asset classes, and underlying network and database environments.
• Stay current on investment technologies and industry practices through technical training.
• Participate in code reviews and incident post-mortem reviews, focusing on eliminating manual toil and systemic waste.
• Serve as a technical liaison or subject matter expert with vendors to resolve complex application or integration issues.
• Perform other duties as assigned.

Benefits

• Comprehensive benefits
• Generous paid time off
• Office amenities
• Training, mentoring, and development opportunities
• Internal career movement opportunities
• Hybrid work option of up to three days from home per week after orientation and training, subject to performance and manager approval

What This Job Offers

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