Sr. SQL Developer

Our 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., * Design, 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.

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., * 8+ 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-Haves

• Oracle 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 Requirements:

• Bachelor’s Degree in Computer Science, Business Analytics, Mathematics, or related field, or equivalent experience.

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.

If anyone reaches out to you about an open position connected with Eliassen Group, please ensure that you are working directly with us by confirming the following:

· When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.

Eliassen Group is a strategic consulting firm that helps organizations reach further and achieve more through our technology, business advisory, and life sciences solutions. For nearly 40 years, we have combined exceptional people, deep domain expertise, and intelligent capabilities to expand our clients’ capacity and accelerate meaningful outcomes. We are driven by a purpose to positively impact the lives of our employees, clients, consultants, and the communities we serve.