Reporting & Automation Developer (SSRS, JAMS, PowerShell)

Ultimus Fund Solutions; Minneapolis, Northern (MN, KY); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Ultimus Leverpoint seeks an Application Developer focused on reporting and automation to support Transfer Agency operations. The role concentrates on designing SSRS reports and building JAMS jobs to automate business workflows within the Power Agent environment.

Responsibilities include writing optimized SQL queries, supporting Power Agent automation, and triaging technical tickets while collaborating with business stakeholders to deliver reliable reporting solutions and operational improvements.

Qualifications

• 2+ years of experience developing and supporting applications in a Microsoft SQL Server environment.
• Firsthand experience developing SSRS reports.
• Experience scripting in PowerShell or C# for automation and job orchestration.
• Direct experience supporting or developing within Envision Power Agent.

Responsibilities

• Designs, develops, assesses, and deploys SSRS reports to support the Transfer Agency department and operational reporting requirements.
• Develops, configures, and maintains JAMS jobs, dependencies, triggers, and schedules to automate business processes and system workflows.
• Writes and optimizes SQL queries, stored procedures, and datasets used within Power Agent, reporting, and automation processes.
• Monitors, triages, and resolves Application Development tickets related to Envision Power Agent, SSRS reports, and JAMS jobs.
• Supports application releases, upgrades, and operational improvements within the Power Agent environment.

Skills

Troubleshooting

Multitasking

Analytical thinking

Communication

Tools

SQL Server

SSRS

JAMS

Power Agent

.NET/C#

PowerShell

Azure

Windows Server

Job description

Ultimus Leverpoint seeks an Application Developer focused on reporting and automation to support Transfer Agency operations. The role concentrates on designing SSRS reports and building JAMS jobs to automate business workflows within the Power Agent environment.

Responsibilities include writing optimized SQL queries, supporting Power Agent automation, and triaging technical tickets while collaborating with business stakeholders to deliver reliable reporting solutions and operational improvements.