TSQL Level 4

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

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