Back to Job Search

SQL Data Warehouse Developer

  • Location: Charlotte, Mecklenburg County, North Carolina, 28262
  • Salary: 49.84
  • Job Type:Contract

Posted about 1 month ago

Long-Term Contract Opportunity with a FULL suite of benefits!

As one of the largest financial institutions in the world, our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.

Position: MS SQL Server Data Warehouse Developer
Location: Charlotte, NC 28262
Term: 9 months

Day-to-Day Responsibilities:

  • Interpret and analyze business requirements to assist with the design, development and delivery of a technology solutions that meets the needs of the end users while maintaining compliance with change management processes and procedures.
  • The developer will also have support duties on occasions and/or after hours support as needed.
  • Acts in a lead technical role providing technical guidance and consultation with application teams, clients, and Engineering Managers for their technology domain environments including but not limited to cloud, middleware, operating systems, applications, Software-as-a-Service, and Platform-as-a-Service products.
  • Designs, codes, tests, debugs and documents programs using Agile development practices.
  • Provides the strategy and design for projects associated with their technology domain including, upgrades and deployments.
  • Utilizes advanced technologies and methods to integrate their technology domain with other technology domains, enabling the creation of new or expanded heterogeneous environments.
  • Develops new documentation and departmental technical procedures.
  • Directs the gathering of performance statistics to assist in determining hardware and communication tools needed to support projected transaction volumes, response time and system availability targets.
  • As an escalation point, provides guidance and direction to less experienced staff in resolution of highly complex technical problems.
  • Leads projects and manages the work of less experienced staff.
  • Assures quality, security and compliance requirements are met for supported technology domain.
  • Leads projects and as an escalation point, provides guidance and direction to less experienced staff in resolution of highly complex technical problems.
  • Assures quality, security and compliance requirements are met for supported technology domain.


Is this a good fit? (Requirements):

  • 5+ years of ETL / Data Warehouse experience
  • 5+ years MS SQL Server experience; e.g. DDL, TSQL, Stored Procedures, Functions
  • 3+ years MS SQL Database Administration; e.g. index, partitioning, execution plan analysis 
  • 3+ years SDLC knowledgeable. 
  • Kimball Methodology, Star Schemas, Slowly changing dimensions. 
  • Excellent problem-solving skills. 
  • Strong communication skills, a positive attitude and the ability to work well in a team environment. 
  • The ability to work in a multi-tasking team environment. This role supports multiple in-flight development projects at the same time. 
  • Ability to analyze and document system recommendations and changes.

Preferred:

  • 1+ years Autosys, UNIX shell scripting.
  • 1+ years Informatica Power Center development.
  • 1 + year of SQL Server SSIS, SSRS and SSAS experience
  • 3+ years MS Team Foundation Server (TFS), or similar version control software
  • Microsoft Certified Solution Developer (MCMCSD, MCAD)
  • BS/BA degree or higher in information technology
  • Financial industry experience is desirable, especially in the finance / product control / middle office domain. Accounting knowledge also a big plus.
  • Ability to analyze and document system recommendations and changes.
  • Basic project management abilities. Able to work within a large project plan and able to manage own tasks and time.
  • Integrity and pride in own work. Attention to detail. Strives to deliver a quality solution with minimal defects.