CharlotteRecruiter Since 2001
the smart solution for Charlotte jobs

Senior Azure SQL Developer

Company: Resource 1
Location: Charlotte
Posted on: November 11, 2019

Job Description:

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

Keywords: Resource 1, Charlotte , Senior Azure SQL Developer, IT / Software / Systems , Charlotte, North Carolina

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Technical Sales Analytical Instrumentation
Description: Our client is a world leader in laboratory equipment and services, and has an opportunity for a Sales Representative for its industry leading analytical instrumentation used in R D laboratories.
Company: The Recruiting Group, Inc.
Location: Charlotte
Posted on: 11/19/2019

Application Systems Engineer 2
Description: RESPONSIBILITIES:Kforce has a client in search of an Application Systems Engineer 2 in Charlotte, North Carolina NC .Summary:This person will be a senior systems engineer and technical expert in the (more...)
Company: Kforce Technology Staffing
Location: Charlotte
Posted on: 11/19/2019

Software Engineer (Charlotte or Tempe)
Description: Where good people build rewarding careers.Think that working in the insurance field can't be exciting, rewarding and challenging Think again. You'll help us reinvent protection and retirement to improve (more...)
Company: Allstate
Location: Charlotte
Posted on: 11/19/2019


IT Security Project Manager
Description: IT Security Specialist Summary: br br Signature Consultants has an opportunity for an IT Security Specialist. The candidate will be a key individual contributor to the Information Security team responsible (more...)
Company: Signature Consultants
Location: Charlotte
Posted on: 11/19/2019

IT Project Manager Sr
Description: IT Project Manager Sr needs 2 years experience as a Scrum Master IT Project Manager Sr requires: Scrum Master Certification SAFe certification and a year's practical experience
Company: Global Channel Management, Inc.
Location: Charlotte
Posted on: 11/19/2019

Embedded Software Engineer - Electrical Systems
Description: We are looking for an Embedded Software Engineer --The embedded--Software Engineer--will work in a team environment to design, implement, integrate, and test embedded software systems for commercial
Company: Job Juncture
Location: Charlotte
Posted on: 11/19/2019

RPA Developer
Description: Candidate must be able to work on W2 without sponsorship now or in the future. Acts as a lead in providing application design guidance and consultation, utilizing a thorough understanding of (more...)
Company: ATR International
Location: Charlotte
Posted on: 11/19/2019

Web Developer
Description: This Web Developer position is for someone experienced, who is looking for the next step in their career. The Web Developer opening with Robert Half Technology is for candidates who are passionate and (more...)
Company: Robert Half Technology
Location: Charlotte
Posted on: 11/19/2019

Linux Systems Engineer with Security Clearance
Description: You know that great feeling you get when you solve a really tricky problem with a brilliant solution We feel that a lot over here. We're looking for problem solvers that can create and deploy software (more...)
Company: Polaris Alpha-a Parsons company
Location: Charlotte
Posted on: 11/19/2019

Full Stack Web Developer
Description: Send resumes to austin.ledford rht.com Work within all in a LAMP stack: Linux, Apache, MySQL, PHP Develop
Company: Robert Half Technology
Location: Charlotte
Posted on: 11/19/2019

Log In or Create An Account

Get the latest North Carolina jobs by following @recnetNC on Twitter!

Charlotte RSS job feeds