Offer summary

Qualifications:

Minimum of 5 years of hands-on experience with T-SQL and relational databases., Strong understanding of data warehouse concepts and complex data models., Proficiency in developing stored procedures, functions, and ETL processes using SSIS., Excellent communication skills for collaboration with technical and non-technical teams..

Key responsibilities:

Design, implement, and maintain transactional and reporting databases.

Develop T-SQL procedures, functions, and SSIS packages for data integration and ETL.

Create reports and analyses using SSRS and other tools.

Review code for efficiency and adherence to standards.

Job description

Job Type

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