SQL Data Steward

Lensa is the leading career site for job seekers at every stage of their career. Our client, Hyatt, is seeking professionals in Omaha, NE. Apply via Lensa today!

Description

Opportunity is calling. Grow with Hyatt.

This position can be worked at our Global Contact Center in Omaha, Nebraska or Marion, Illinois. This position can also be worked remotely. Please note this position can only be worked remotely from the following states: Arizona, Colorado, Florida, Georgia, Illinois, Indiana, Iowa, Kansas, Louisiana, Michigan, Minnesota, Missouri, Nebraska, North Carolina, North Dakota, Ohio, Oklahoma, South Carolina, South Dakota, Tennessee, Texas, Utah, and Wisconsin.

The SQL Data Steward works closely with the SQL Database Administrator while building and maintaining all databases within the GPGS SQL environment. This SQL Data Steward must be proficient in ETL processes (including using Python to connect to APIs), data modeling, Microsoft SQL Server software, Business Intelligence tools, SSDT, SSIS, SSRS and T-SQL (including writing stored procedures, functions and triggers). This position is primarily responsible for the data architecture, data flows, and documentation related to all GPGS databases.

Position Responsibilities

• Implement and maintain SQL maintenance plans and maintain SQL server security and permissions.
• Design and implement tables, views, and stored procedures to support data cleansing and reporting requirements.
• Ability to prioritize and execute tasks in a high-pressure environment.
• Designs, builds, and schedules SQL server jobs to automate data extraction tasks using SQL Server Integration Services (SSIS), Python, and other technologies.
• Design and support applications to interact with SQL Server databases to produce interactive data entry.
• Maintains data dictionaries and documentation for department data sources and databases.
• Partners with other teams and departments to ensure data is complete, accurate, and properly accessible through automated and manual audits and investigations.
• Supports cross-function project teams with data extraction and access needs.
• Demonstrate a commitment to Hyatt core values.
  
  

Qualifications

Experience:

• 3 – 5 years Microsoft T-SQL (or equivalent) experience (including reading and writing queries as well as building objects like tables, views, stored procedures, and functions).
• 1 – 2 years experience maintaining Microsoft SQL server (or similar DBMS) environments (specifically access control and schema design).
• 2 – 3 years implementing and maintaining ETL pipelines and calling REST APIs (SSIS and Python or similar).
• Familiarity with one or more hospitality reservation or property management systems preferred.
  
  

Education

• Bachelor’s Degree in Computer Science or related field or equivalent experience preferred.
  
  

Computer Skills Needed

• 2 years Microsoft Office (Excel & Access) required.
• 3 years SQL design experience required.
• Intermediate to Advanced experience with SQL (any variant) required.
• Experience with Python, PowerShell, Alteryx or other scripting languages or automation tools preferred.
  
  

Additional Comments And Requirements

• Ability to conduct business in the English language required.
• Ability to conduct business in the Spanish language is helpful.
• Ability to work independently as well as in a team environment.
• Attention to detail.
• Strong technical documentation skills.
• Able to prioritize and execute tasks in a high-pressure environment.
• Ability to travel as needed.
• Schedule flexibility to include nights and weekends as needed.
• Ability to work from home or office based on business needs.
  
  

Wage Information

The pay range for this position starts at $28.22 MIN to $37.50 MID. This position is eligible to earn overtime.

The final pay rate offered to the successful candidate will depend on experience, skill level and other qualifications for the role, as well as the location of the performance of work. Pay for the successful candidate will meet local requirements, including the local minimum wage rate.

Benefits Information

Benefits available with this position include the following:

• Medical / Dental / Vision Insurance
• Flexible Spending Account
• 401k
• Retirement Savings Plan
• Basic Life Insurance
• Employee Stock Purchase Plan
• Annual allotment of free hotel stays at Hyatt hotels globally (subject to availability)
• In addition to allotment of free hotel stays, discounted hotel stays (subject to availability)
• Paid Time Off accruing at an approximate rate of 24 minutes per day, up to a maximum of 144 hours per year
• Seven paid holidays per year
• Three paid floating holidays per year (two if hired with Hyatt after July 1 st )
• Wellbeing benefits, including monthly fitness reimbursement, complimentary HeadSpace subscriptions, and access to employee assistance program resources
  
  

Hyatt is an equal employment opportunity and affirmative action employer. We do not discriminate on the basis of race, color, gender, gender identity, sexual orientation, marital status, pregnancy, national origin, ancestry, age, religion, disability, veteran status, genetic information, citizenship status or any other group protected by law.

Primary Location: US-NE-Omaha

Organization: Global Property and Guest Services Hub - Omaha

Pay Basis: Yearly

Job Level: Full-time

Job: Quality Assurance/Hotel Operations Analysis

Req ID: OMA001346

Hyatt is an equal employment opportunity and affirmative action employer. We do not discriminate on the basis of race, color, gender, gender identity, sexual orientation, marital status, pregnancy, national origin, ancestry, age, religion, disability, veteran status, genetic information, citizenship status or any other group protected by law.