Job Description

Job Title: SQL Server Developer

Duration: 10 months with a 12-month extension

Pay: $52-$55/HR on W2

MUST BE ON OUR W2. We can't sponsor H1B at this time.

Location: Remote

Industry Experience:

• Required: Financial Institution

• Nice to Have: Marketing Campaign

We are seeking a skilled SQL Server Developer to support a critical Teradata SQL platform migration while ensuring continuity of bank marketing campaigns. The ideal candidate will have extensive experience in SQL development, ETL workflows, database optimization, and data warehousing . This role requires collaboration with business partners to gather requirements, develop solutions, and maintain existing core campaign processes.

• Gather requirements and develop fact and dimension tables while configuring ETL workflows .

• Develop complex SQL queries and optimize databases for improved performance.

• Troubleshoot and resolve production ETL issues .

• Optimize stored procedures, T-SQL, views, and functions for efficiency.

• Automate SQL processes and track/document any changes.

• Design, develop, and maintain data warehouses .

• Develop and automate SSIS packages for ETL processes.

• Create database objects (tables, views, indexes, triggers) to support relational and dimensional models.

• Develop scripts for data manipulation and integrity enforcement .

• Generate tabular and parameterized reports using SQL Server Reporting Services (SSRS) .

• Manage report schedules, subscriptions, and security settings within SSRS.

• Support the migration to a new Teradata SQL platform while maintaining existing bank marketing campaigns .

• SQL Server 2012

• SQL Server Management Studio (SSMS)

• MS BI Suite (SSIS/SSRS)

• SQL Server Data Tools (SSDT)

• Excel VBA/Macros, MS Office Suite 2010

• Tableau 10, JIRA, WebEx

• Agile/Scrum methodology

• Excellent communication skills with the ability to interact with clients.

• Strong SQL and Python programming experience.

• Familiarity with demographic, interest, and transactional data from industry aggregators.

• Experience with digital and email online platforms .

• Ability to create and modify stored procedures for recurring and ad-hoc processes.

• Maintain and improve campaign processes and business logic.

• Perform rigorous quality control on campaign logic and data processes.

• Collaborate with business partners to gather requirements, design, test, and implement marketing campaigns across multiple channels (direct mail, email, inbound/outbound calls).

• 7+ years of experience in Microsoft SQL using Management Studio .

• Strong written and verbal communication skills.

• Ability to work independently or collaboratively in a team environment.

• BS/MS in Computer Science, Mathematics, or a related field (or equivalent work experience).

• Experience with SQL Server Integration Services (SSIS) .

• Knowledge of Siebel CRM, SFMC/ExactTarget, or Portrait Interaction Optimizer .

• Experience with Tableau for data visualization.

• Familiarity with SAS & scripting languages .

• Experience with MS Visio for process mapping.

• Background in Retirement Plan Benefits or broader financial services .

This is an exciting opportunity to be a key contributor in a large-scale data migration project while ensuring continuity of marketing operations. If you are a self-starter with strong SQL development skills , we encourage you to apply!

Job Tags

Similar Jobs