TSQL Level 4

Full-time

Description

About Our Company:

At Yes& Companies, we are a hospitality and lifestyle company that inspires ‘lasting togetherness’ through our brands, companies, and products.

We wake up every day to inspire togetherness through connecting, sharing and discovery. Life is better together. We’re better together.

We’re a multi generation company founded by a family, whose big picture begins with you. Work at a place filled with genuine people, leaders who care and an opportunity to make a difference without needing permission to lead.

Join in on the fun.

Role:

Assist with the design, implementation, and maintenance of transactional and reporting databases and reports. Assist in training other developers, ensuring that standards of quality, maintainability, efficiency, and scalability are kept.

Responsibilities:

Meet with Business Analysts, stake holders, and subject matter experts to understand business needs

Develop T-SQL procedures and functions for database management and to satisfy business needs

Develop SSIS package to integrate with external systems

Develop SSIS packages for ETL for data warehouse

Develop reports and analyses using SSRS and other tools

Review other developers’ code for soundness and efficiency

Requirements

REMOTE POSITION

MUST RESIDE IN THE UNITED STATES, SPECIFICALLY IN THE STATES OF NEVADA, UTAH, COLORADO, ARIZONA, MARYLAND ONLY

NO VISA SPONSHIP OPPORTUNITIES

NO RELOCATION ASSISTANCE

FULL TIME CONTRACTED POSITION W-2 DIRECT HIRE

5 or more years of hands-on experience

Understand data warehouse concepts, including cubes

Thorough understanding of complex relational database concepts, including normalized and de-normalized data models

Mastery of:

T-SQL CRUD

JOIN

UNION

Variables

Text manipulation

CASE statements

Thorough understanding of

Cursors

Windowed functions and Aggregate functions

Creating and using

Stored procedures

User-defined scalar functions

User-defined tabled-valued functions

Common table expressions, including recursive, and of sub-queries

Index and optimization techniques

Transactions and Rollback

MERGE

TRY/CATCH

OUTPUT

Scope of operations within and across nested objects

Execution plans

Importing data using T-SQL

Dynamic SQL

Scheduled jobs

Statelessness

SSRS

Understanding and experience with

RAISE ERROR

XML and JSON with T-SQL

SSIS for ETL

Excellent communication skills with both technical and non-technical colleagues

Revenue/Budgetary/Staff Responsibility

No budgetary responsibility

No direct reports

EEO/Drug Free Workplace

Salary Description

$85,000 - $95,000 annual