Sr. SQL Developer

DescriptionHybrid 2x per week in Norcross, GAOur client is seeking a Sr. SQL Developer with strong, in-depth SQL Server/T-SQL experience to support a complex payments environment. Experience with Oracle/PL/SQL is highly preferred. This role is focused on SQL development, data warehousing, data modeling, ETL, performance optimization, and production support across complex financial transaction flows. The developer will work extensively with existing code and processes and must be able to quickly understand how data moves through multiple systems and make enhancements with minimal ramp-up.The application processes daily batch transaction files, performs complex transaction matching, separates and categorizes transaction fees and costs, and reconciles bank files against internal records. The team operates in a collaborative environment with daily standups and shifting priorities, requiring adaptability, strong problem-solving skills, and the ability to work independently.Due to client requirements, applicants must be willing and able to work on a W2 basis. For our W2 consultants, we offer Medical, Dental, and Vision benefits, 401(k) with company matching, and life insurance.Rate: $52.00 to $57.00/hr. w2ResponsibilitiesDesign, develop, and maintain complex SQL/T-SQL solutions.Read, interpret, troubleshoot, and modify existing SQL code, stored procedures, and database processes.Support data warehousing, dimensional data modeling, and ETL development.Develop and maintain mappings, interfaces, packages, procedures, and scheduled jobs.Perform query tuning, database optimization, and performance troubleshooting.Support transaction matching, bank reconciliation, fee categorization, and other financial data workflows.Perform data validation, migration, cleansing, and auditing between source and target systems.Develop and maintain physical and logical data models.Support metadata, reporting specifications, and business reporting requirements.Troubleshoot production issues, determine root cause, and implement fixes.Collaborate with business stakeholders, data owners, and other developers.Maintain technical documentation and development standards.Participate in daily standups and adapt to changing business and production priorities.Experience Requirements8+ years of strong SQL/T-SQL development experience with Microsoft SQL Server.Strong data warehousing and dimensional data modeling experience, including facts, dimensions, and slowly changing dimensions.Hands-on SSIS / ETL experience building, supporting, and troubleshooting integrations, packages, and scheduled jobs.Strong experience with query tuning, database optimization, data validation, and production support.Experience working with financial, banking, or payments-related data, ideally involving transaction processing or reconciliation.Ability to read, interpret, and modify complex existing code and become productive quickly in an established application environment.Nice-to-HavesOracle and PL/SQL development experience – highly preferred.Direct experience with payment processing, bank-file reconciliation, transaction matching, or fee categorization.Reporting or dashboard development experience.Experience with Jira, Bitbucket, Salesforce, or similar tools.Familiarity with AI development tools.Bachelor’s degree in Computer Science, Information Systems, Mathematics, Analytics, or a related field.Education RequirementsBachelor’s Degree in Computer Science, Business Analytics, Mathematics, or related field, or equivalent experience.