Middle Office SQL Analyst/SQL Developer

About the team:

At the Capco Technology Delivery Center, we are dedicated to the financial services industries. Our professionals combine innovative thinking with unrivalled industry and domain expertise to offer our clients consulting expertise, complex technology and package integration, transformation delivery, and managed services, to move their organizations forward. Through our collaborative and efficient approach, we help our clients successfully innovate, increase revenue, manage risk and regulatory change, reduce costs, and enhance controls. Our teams stay at the forefront of industry trends and technologies that are driving innovation. From strategy to launch, we are adept at delivering across the full product lifecycle. 

About the Job:

As a member of the Capco Technology Delivery Team, you’ll bring practical knowledge of agile development methodologies and engineering best practices. As a Middle Office SQL Analyst/SQL Developer, you’ll use your experience and skills to contribute to the quality and implementation of our software products for our customers.

• Lead and execute middle office projects and investigations independently
• Analyze and manipulate large datasets using SQL Server and other database systems
• Develop solutions and automation using a programming language such as Python, Java, or C#
• Diagnose and optimize database performance through query plan analysis
• Support back office processing operations and identify improvement opportunities
• Ensure data integrity and accuracy across the platform
• Gain a thorough understanding of the data that moves through the system
• Design, develop, and deploy high-quality code to address bug fixes, system enhancements, and new feature implementation based on business needs
• Collaborate within an Agile environment, contributing to sprint planning, stand-ups, sprint reviews, and retrospectives

• Minimum 5 years of experience working with SQL and large datasets
• The ability to investigate and work with large datasets.
• Proven expertise in SQL Server (primary requirement)
• Experience with database indexing strategies and performance tuning.
• Strong experience in troubleshooting and an advanced knowledge of diagnosing query plans and database optimization techniques
• Experience working in Agile environments, with familiarity in using tools like Jira, Azure DevOps, etc.
• Experience in at least one of: Python, Java, or C#
• Experience with additional database systems (Oracle, MySQL, PostgreSQL, etc.)
• Familiarity with ETL processes and data warehousing concepts
• Proficient in scripting. (any scripting language)
• Understand trade life cycle in the financial sector
• Willingness to work in the Jersey City office 3 days/week

A career at Capco is a chance to help reshape the competitive landscape in financial services.  We launch new banks, transform existing ones, and help our clients navigate complex change.  As consultants, we work on the front-end business design all the way through to technology implementation.

We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering.

Capco is a young and growing firm. We maintain an entrepreneurial spirit and growth mindset, and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or  ability to focus on our clients and make a difference to the business.  We offer the opportunity for everyone to learn rapidly, take on tough challenges, and get promoted quickly. We take pride in our creative, collaborative, diverse, and inclusive culture, where everyone can #BYAW.

We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees. 

If this sounds like you, we would love to hear from you.  This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.

We have been informed of several recruitment scams targeting the public. We strongly advise you to verify identities before engaging in recruitment related communication. All official Capco communication will be conducted via a Capco recruiter.

#LI-MB1

#LI-HYBRID