Application Support Engineer

ACA Group; Medford (OR); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical coverage

Paid holidays

Wellness programs

Employee Resource Groups

Job summary

ACA Group in the United States is seeking a data-focused technology support professional to manage MS SQL-based investigations, diagnose data anomalies, and guide corrective actions for client trading platforms. Experience with REST APIs and Postman will be advantageous as you collaborate across teams to maintain data integrity and system configurations.

The role emphasizes strong analytical and communication skills, with duties spanning incident troubleshooting, data repairs, and proactive

Qualifications

• Proficient in analytical skills, adept at resolving issues through troubleshooting.
• Familiarity with financial concepts, including understanding transactions, holdings and securities.
• Bachelor’s degree, with a preference for technology or finance.

Responsibilities

• Perform in-depth analysis, troubleshooting, and diagnosis of incidents related to clients’ trades, holdings, and securities.
• Utilize MS-SQL to analyze, diagnose, and resolve technical and data anomalies.
• Fully manage support cases by logging, monitoring, updating, prioritizing, and resolving calls, emails, and indirect inquiries promptly.
• Collaborate with internal teams and clients to resolve data-related issues efficiently.
• Daily use of MS SQL, to search for issues and to write scripts to fix data within the database.
• Work collaboratively with developers and product owners to identify corrective actions or effective workarounds for incident resolution.

Skills

MS SQL

Analytical skills

Communication skills

Financial domain knowledge

Education

Bachelor’s degree in technology or finance

Tools

Postman

New Relic

AWS CloudWatch

Job description

About ACA

ACA Group is the leading governance, risk, and compliance (GRC) advisor in financial services. We empower our clients to reimagine GRC and protect and grow their business. Our innovative approach integrates consulting, managed services, and our ComplianceAlpha® technology platform with the specialized expertise of former regulators and practitioners and our deep understanding of the global regulatory landscape.

• Office Locations: NYC (office is near Grand Central), Pittsburgh, Medford, Oregon, Chattanooga and Portland, Maine.
• Must be able to go into one of these offices 2 days/week (Hybrid)
• All other locations will operate remotely until we establish an office in your area
• Must be able to work Mountain time OR PST

Position Summary

This role is integral to the daily operations of our technology support team, with a specific focus on the personal trading components of ACA Technology platforms. This includes identifying issues, troubleshooting, offering guidance on corrective measures, and managing system configurations. This would include maintaining data integrity and providing support to clients. The ideal candidate will have a strong analytical mindset, excellent communication skills, and the ability to troubleshoot and resolve data-related issues within MS-SQL efficiently.

Job Duties

Perform in-depth analysis, troubleshooting, and diagnosis of incidents related to clients’ trades, holdings, and securities. Utilize MS-SQL to analyze, diagnose, and resolve technical and data anomalies.

Good to have knowledge on REST APIs as well and using POSTMAN

Fully manage support cases by logging, monitoring, updating, prioritizing, and resolving calls, emails, and indirect inquiries promptly.

Collaborate with internal teams and clients to resolve data-related issues efficiently.

Daily use of MS SQL, to search for issues and to write scripts to fix data within the database.

Work collaboratively with developers and product owners to identify corrective actions or effective workarounds for incident resolution.

Provide expert guidance on corrective actions and system configuration adjustments.

Provide recommendations to key stakeholders and leadership, using insights to advocate for both internal and external users.

Document processes, resolutions, and best practices to enhance team knowledge.

Preferred Education And Experience

• Proficient in analytical skills, adept at resolving issues through troubleshooting.
• Familiarity with financial concepts, including understanding transactions, holdings, and securities.
• Bachelor’s degree, with a preference for a concentration in technology or finance.

Qualifications

• Exceptional command of the English language, with advanced reading, writing, and comprehension skills.
• Highly proficient in MS SQL, with demonstrated expertise in writing, interpreting, and understanding of stored procedures.
• Solid financial analytical acumen, with practical knowledge of financial instruments and concepts such as transactions, holdings, and securities.
• Understanding of API calls and their role in data integration and system interoperability.
• Demonstrated ability to work independently, manage multiple priorities, and effectively organize tasks in a dynamic environment.
• Proven success in fast-paced, small-team environments, with a collaborative and adaptable mindset.
• Highly motivated and goal-oriented, with a proactive approach to self-learning and professional development.
• Willingness to contribute to both internal initiatives and client-facing projects.

Nice to Have

• Experience with AWS services, particularly AWS CloudWatch,EC2, IAM and S3.
• Familiarity with New Relic for application performance monitoring. Proficiency with Postman for REST API testing and validation.

What working at ACA offers

We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. Our Total Rewards package includes medical coverage fully funded by ACA for employees and their family as well as access to Maternity & Fertility and Wellness programs. ACA also provides Personal Accident Insurance, Group Term Life Insurance, Employee Discount programs and Employee Resource Groups. You’ll be granted time off for designated ACA Paid Holidays, Privilege Leave, Casual/Sick Leave, and other leaves of absence to support your physical, financial and emotional well-being.

What we commit to

ACA is firmly committed to a policy of nondiscrimination, which applies to recruiting, hiring, placement, promotions, training, discipline, terminations, layoffs, transfers, leaves of absence, compensation and all other terms and conditions of employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected status.