Middle Office SQL Analyst/SQL Developer
About the position 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. Responsibilities • 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 Requirements • 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 Benefits • medical, dental and vision insurance • a 401(k) plan • tuition reimbursement • a work culture focused on innovation and creation of lasting value for our clients and employees Apply tot his job