Application Developer, Reporting and Automation

Ultimus Fund Solutions

Cincinnati (OH)

On-site

USD 85,000 - 105,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ultimus Fund Solutions is seeking an Application Developer, Reporting and Automation Specialist to design and develop SSRS reports and automation workflows within the Envision Power Agent environment. You will build and maintain JAMS Enterprise Scheduler jobs and troubleshoot related tickets, partnering with business stakeholders to deliver reliable reporting and automated processes.

The role emphasizes accuracy, efficiency, and operational integrity while supporting Transfer Agency operations.

Qualifications

  • 2+ years of experience developing and supporting applications in a Microsoft SQL Server environment.
  • Hands-on experience creating SSRS reports and dashboards.
  • 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 Transfer Agency and operational reporting.
  • Develops, configures, and maintains JAMS jobs, dependencies, triggers, and schedules to automate business processes.
  • 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, and JAMS jobs.
  • Supports application releases, upgrades, and operational improvements within the Power Agent environment.

Skills

SSRS reports
PowerShell
C#
SQL
JAMS scheduling
Envision Power Agent
Azure DevOps
Windows Server

Job description

SUMMARY

The Application Developer, Reporting and Automation Specialist is responsible for supporting Envision Power Agent and Transfer Agency related applications, primarily focused on designing and developing SSRS reports, building and maintaining JAMS Enterprise Scheduler jobs, and resolving support tickets related to Transfer Agency operations within the Power Agent environment. Additionally, this role will work closely with business stakeholders and technical team members to deliver reliable reporting solutions, automate operational workflows, and resolve application issues in a timely and controlled manner while maintaining a strong focus on accuracy, efficiency, and operational integrity.

TECHNOLOGY STACK
  • Microsoft SQL Server.
  • SQL Server Reporting Services SSRS.
  • JAMS Enterprise Scheduler by Fortra.
  • Envision Power Agent.
  • .NET and C#.
  • PowerShell.
  • Azure DevOps.
  • Windows Server and Microsoft Azure.
KEY ACCOUNTABILITIES
  • 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.
WORKING RELATIONSHIPS
  • Collaborates with business analysts and Transfer Agency stakeholders to gather requirements and translates them into technical solutions.
  • Contact as needed with clients regarding general information, resolution of issues, inquiries, or reporting requirements.
  • Contact with members of team and internal teams regarding follow-up on inquiries, open workflow, etc.

May perform other duties as required and assigned.

EDUCATION AND EXPERIENCE
  • 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.
  • Equivalent education and experience will be considered.
KNOWLEDGE
  • Azure DevOps or similar CI CD platforms.
  • SQL queries and stored procedures.
  • Transfer Agency operations or financial services environments.
  • Microsoft Office Suite.
  • Adobe Acrobat.
SKILLS AND ABILITIES
  • Troubleshoots issues utilizing creative and critical thinking skills.
  • Multitasking, analytical, and organizational skills.
  • Initiative-taking, strategic, and meticulous approaches with a strong commitment to quality, efficiency, and effectiveness.
  • Demonstrates personal integrity, responsibility, and accountability.
  • Effectively uses resources such as time and information in conjunction with associates.
  • Participates in solving problems and making decisions.
  • Presents and expresses ideas and information, written and oral, clearly, and concisely.
  • Actively listens to others to achieve understanding and supports an open exchange of ideas and information.
  • Identifies needs, arranges for, and obtains resources to accomplish individual and department goals.
  • Establishes and develops effective working relationships with associates and clientele during both favorable and unfavorable situations.
  • Modifies team and individual priorities and deadlines in response to added information, changing conditions, or unexpected obstacles and ensures completion.

Ultimus Leverpoint is an equal opportunity employer and does not discriminate on the basis of the applicant's or employee's race, color, religion, national origin, ancestry, gender, sexual orientation, age, disability, veteran or military status, genetic information, citizenship or any other status entitled to protection under federal, state or local anti-discrimination laws. No questions on our employment application are intended to secure information that is to be used for impermissible purposes.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Application Developer, Reporting and Automation
Application Developer, Reporting and Automation

Dayforce • Omaha (NE)

On-site
USD 80,000 - 110,000
Reporting & Automation Engineer (SSRS, JAMS, Power Agent)
Reporting & Automation Engineer (SSRS, JAMS, Power Agent)

Ultimus Fund Solutions • Cincinnati (OH)

On-site
USD 85,000 - 105,000
Enterprise Applications Engineer II
Enterprise Applications Engineer II

Howard Energy Partners • San Antonio (TX)

On-site
USD 90,000 - 120,000
Power Platform Developer
Power Platform Developer

Raventek Solution Partners • Washington

Remote
USD 90,000 - 130,000
Power Platform Developer
Power Platform Developer

RavenTek • Washington

Hybrid
USD 110,000 - 160,000
Application Analyst II Power Platform and M365
Application Analyst II Power Platform and M365

Renewable Energy Systems (RES) • Denver (CO)

Hybrid
USD 80,000 - 100,000
Medical, Dental and Vision
401(k) plan with company match
PTO and Holidays
+3
Senior Power Apps/Power BI Developer
Senior Power Apps/Power BI Developer

i4DM • Millersville (MD)

Remote
USD 95,000 - 140,000
.Net Developer
.Net Developer

Quantum Technologies LLC • Pennsylvania

On-site
USD 90,000 - 130,000
.Net Developer
.Net Developer

Robotic Process Automation LLC • Pennsylvania

On-site
USD 117,000 - 165,000
.Net Developer
.Net Developer

Valiant Technologies LLC • Pennsylvania

On-site
USD 120,000 - 170,000