Investment Systems Engineer - Automate & Stabilize Pipelines

Colorado-Public-Employees; Denver (CO); Hybrid; USD 108,000 - 134,000; Full time

Benefits offered by this job

Hybrid work option

Work-from-home days after orientation

Job summary

PERA is seeking an Investment Systems Engineer in Colorado to own and optimize critical investment platforms (Portia, Longview, PACE, Ascend, Power BI, Snowflake). You will leverage Python, SQL, and PowerShell to build robust data pipelines and lead system enhancements that enable the Investment Team’s decision-making.

You will participate in a 24/7 on-call rotation, ensure reliability of vital financial technology, and contribute to technical designs while driving automation to reduce toil and

Qualifications

• Degree in a technical (STEM) field and two years of experience in a technical role preferred, or equivalent combination of education and experience.
• Experience managing and troubleshooting operating systems, servers and storage, and using automation for platform management.
• Advanced SQL proficiency for complex querying, performance tuning, and database object management across enterprise environments.

Responsibilities

• Owns medium investment projects by providing analysis, development, testing, and deployment.
• Manages and maintains key investment platforms (Portia, Longview, PACE, Ascend, Power BI, Snowflake) with automation and data transformation tools.
• Contributes to technical design and independently develops designs for simple developments that meet standards.
• Troubleshoots daily investment systems/data issues (Tier 1/Tier 2) and resolves incidents.
• Participates in 24/7 on-call rotation to ensure system stability and minimize downtime.
• Administers and patches investment application servers and database environments for high availability.
• Develops and maintains SOPs and high-quality system documentation.
• Keeps up-to-date with evolving investment technologies and best practices.

Skills

SQL

Python

PowerShell

Snowflake

Power BI

Automation

REST APIs

SFTP interfaces

Automic UC4

Airflow

Education

Bachelor's degree in a technical field

Tools

Broadcom Automic UC4

Airflow

Snowflake

SQL Server

Oracle

Windows Server

Job description

PERA is seeking an Investment Systems Engineer in Colorado to own and optimize critical investment platforms (Portia, Longview, PACE, Ascend, Power BI, Snowflake). You will leverage Python, SQL, and PowerShell to build robust data pipelines and lead system enhancements that enable the Investment Team’s decision-making.

You will participate in a 24/7 on-call rotation, ensure reliability of vital financial technology, and contribute to technical designs while driving automation to reduce toil and