Skip to content

 

Job Application

 
 
 

Please answer the following questions in order to process your application.

 
 
Email Address *
 
I certify that I am a U.S. citizen, permanent resident, or a foreign national with authorization to work in the United States. *
 
 
 
File Attachments:
(2MB file maximum. doc, docx, pdf, rtf or txt files only)
 
Attach a Resume * 
 
Optional covering letter 
OR
Clear covering letter
 
 
 * denotes required field
 
 
 
Additional Information:
 
First Name
 
Last Name
 
Address
 
Country
 
Home Telephone
 
Mobile/Cell
 
Availability/Notice
 
Hourly Rate USD
 
Approximately how far are you willing to travel to work (in miles) ?
 
 
 

Key Privacy Information

When you apply for a job, ComputerJobs will collect the information you provide in the application and disclose it to the advertiser of the job.

If the advertiser wishes to contact you they have agreed to use your information following data protection law.

ComputerJobs will keep a copy of the application for 90 days.

More information about our Privacy Policy.

 
 

Job Details

 

Senior Azure SQL Developer (Contract/Full Time)

Location: Charlotte North Carolina Country: United States of America
 

Resource 1 is in need of a Sr. Azure SQL Developer for a contract OR contract-for-hire position in Chicago, IL. Individual will primarily be responsible for ETL (SSIS) loads from on-prem into Azure SQL. This is a very large, complex, highly available environment where performance is critical and includes the use of clustered columnstore indexing. The ideal candidate will have strong knowledge of Azure SQL Database and how to load data into it (On-prem to Cloud) as well as what the challenges are for loading data and or connectivity.

Responsibilities

  • Azure SQL Database data mart development and support
  • Data load design and implementation from on-premise sources into Azure SQL Database.
  • Design, development and implementation of the Enterprise Data Warehouse, data marts and related applications
  • Design and development of ETL solutions using MS SQL Server Integration Services (SSIS)
  • Ability to design and develop SSIS packages from scratch.
  • Change/modify, troubleshoot existing packages and related logic to improve performance.
  • Work with business SMEs and data architects to implement dimensional data models
  • Help define and implement standards and practices for data warehousing initiatives
  • Act as a SME for the Information Management team when interacting with internal business partners and external clients
  • Develop and execute release plans
  • Troubleshoot production dataflow and code
  • Provide optimization suggestions for queries that pull from EDW data marts

Qualifications

  • 7+ years hands-on experience in data warehousing development and design in large complex enterprise environment with large volumes of data
  • 2+ years of Azure SQL Database development, changes, maintenance and support 5+ years of ETL process design experience, preferably with SSIS
  • 5+ years in developing complex ETL processes using SSIS
  • 7+ years in writing, tuning and troubleshooting complex SQL/T-SQL scripts
  • Experience designing and implementing database schemas using Kimball/Inmon methodologies
  • Strong documentation experience, verbal communication skills and collaboration ability
  • Strong understanding of data normalization rules, denormalization and other techniques to support reporting and analytics
  • Ability to work independently without supervision

Technical Environment: Azure SQL Database, SQL Server, ETL, SQL Server Integration Services (SSIS), Enterprise Data Warehouse (EDW), Database Objects, Kimball/Inmon, Database Schemas, OLAP, Data Marts, Dimensional Data Models, Columnstore Indexing, SQL, Data Normalization & Data Denormalization


Posted Date: 01 Nov 2019 Reference: JSAZURE_SQL_704 Company: Resource 1 Contact: Nickolas Kusen