Senior Application Support Engineer

The Opportunity

The Senior Application Support Engineer specializing in financial concepts, including understanding transactions, holdings, and securities.  You will be responsible for executing daily tasks within the technology support team, specifically focusing on the personal trading aspect 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

• Office Locations: NYC (office is near Grand Central), Pittsburgh, Medford, Oregon, Chattanooga, Portland, Maine and Boston
• Must be able to go into one of these offices 2 days/week (Hybrid)

What you’ll do:

• Perform in-depth analysis, troubleshooting, and diagnosis of incidents related to clients' trades, holdings, and securities. 
• Fully manage cases by logging, monitoring, updating, prioritizing, and resolving calls, emails, and indirect inquiries promptly. 
• Execute fixes, code enhancements, and optimizations with minimal assistance within MS SQL. 
• Work collaboratively with developers and product owners to identify corrective actions or effective workarounds for incident resolution. 
• Support clients in implementing fixes for MS SQL ETL failures, including updates to stored procedures and ETL configurations. 
• Provide recommendations to key stakeholders and leadership, using insights to advocate for both internal and external users. 

Skills and attributes for success:

• Strong knowledge of MS SQL with the ability to write and interpret detailed SQL statements and stored procedures. 
• Deep understanding of Extract, Transform, Load (ETL) concepts. 
• Solid financial analytical skills with familiarity with financial concepts, including transactions, holdings, and securities. 
• Understand API calls. 
• Excellent proficiency in reading, writing, and comprehending English. 
• Capable of working independently, managing multiple tasks, and effectively prioritizing. 
• Skilled at thriving in a fast-paced, small-team environment. 
• Highly motivated and goal-oriented; proactive in self-learning and career advancement; willing to contribute to both internal and client-facing projects. 
• Nice to have:  AWS experience, AWS CloudWatch, New Relic, Postman

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. 

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 and dental coverage and 401(k) plans, and a wide range of paid time off options as well as a flexible work environment. You’ll also be granted time off for designated ACA Paid Holidays, Summer Fridays, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being. We also offer unique benefits such as Student Debt Forgiveness and Pet Insurance. 

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. 

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 basis, in accordance with applicable law.