Application Support Engineer

Application Support Engineer

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.
• 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.