Design, develop, and optimize complex SQL queries and stored procedures to support data integration and reporting needs.
Collaborate with cross-functional teams, including data architects, business analysts, and application developers, to understand integration requirements and ensure data integrity.
Participate in the design and implementation of database structures, schemas, and data models to facilitate efficient data storage and retrieval.
Perform data analysis and profiling to identify data quality issues and propose solutions for remediation.
Develop and maintain ETL processes to extract, transform, and load data from various sources into target databases.
Monitor database performance, troubleshoot issues, and implement optimization strategies to enhance query performance and system efficiency.
Ensure compliance with data governance and regulatory requirements within the financial services industry.
Document database designs, processes, and procedures to maintain a clear record of technical specifications.
Mentor junior developers and provide guidance on best practices in SQL development and database management.
Requirements:
Bachelor’s degree in Computer Science, Information Technology, or a related field.
5+ years of experience as an SQL Developer or in a similar role, preferably within the financial services industry.
Strong proficiency in SQL, T-SQL, and experience with relational database management systems (e.g., Microsoft SQL Server, Oracle).
Experience with ETL tools (e.g., SSIS, Informatica, Talend) and data integration methodologies.
Solid understanding of database design principles, indexing strategies, and query optimization techniques.
Familiarity with data modeling tools and methodologies.
Knowledge of financial services products and regulatory requirements is a plus.
Excellent analytical and problem-solving skills, with a strong attention to detail.
Strong communication and interpersonal skills, with the ability to work collaboratively in a team environmen
