Advanced Database Engineer

  • SG Gaming
  • 606 S 9th St, Las Vegas, NV 89101, USA
  • Nov 09, 2020
[Information Technology]

Job Description

Gaming:Are you ready to level up your career?At Scientific Games, we are committed to making the best games, platforms and systems in the world. We are looking for smart, passionate and creative people to join our team and help us transform the gaming world. We are a global, industry-leading gaming technology company that embraces challenge, fosters an inclusive culture, values integrity, innovation and winning, and is committed to developing and supporting its people.Whether you are a member of our award winning game studios, our industry leading systems group, product management, manufacturing group, services or any of our other amazing Gaming teams, you will be creating compelling games played around the world. We are dedicated to being the industry's only COMPLETE global solutions provider with products that will enhance the entire gaming operation, both on the casino floor and behind the scenes.If you are ready to play...Come join us and let's make games!Scientific Games:Scientific Games (SG) is a global leader focused on delivering an ever-expanding portfolio of lottery and gaming products and services to the world's government-regulated and government-sponsored entities. Scientific Games' global reach is made possible through the expertise, skill and dedicated efforts of its 8,000+ employees who serve lottery and gaming customers in more than 100+ countries on 6 continents.Position SummaryThe Advanced Data Engineer is responsible for architecting and developing a scalable global analytics Enterprise Data Warehouse EDW that will serve as the backbone of all reporting and dashboards for the new Analytics CoE. The Advanced Data Engineer will need to develop an on-prem solution initially, then later lead a migration effort to a cloud-based solution. This role will work with the analytics team and other internal customers to understand business requirements and translate that into a data model implemented in the database. This role will be the lead for developing and administering the database environment and applicable ETL processes enabling its success and serve as key contributor in developing our overall data strategy. An Advanced Data Engineer is should have a strong background in data and the capacity to translate business needs into a technical footprint.Essential Job Functions:Design databases to support business applications, ensuring system scalability, security, performance and reliabilityDevelop database architectural strategies at the modeling, design and implementation stages to address business or industry requirementsCollaborate with system architects, software architects, design analysts, and others to understand business or industry requirementsDevelop data models for applications, metadata tables, views or related database structuresSet up database clusters, backup, or recovery processesCreate stored procedures, views, functions, tables, and ensure their stability, reliability, and performanceWrite and optimize SQL statements for data access and retentionTest databases for performance, fine-tune when necessaryCollaborate with developers on database design, query tuning, and schema refinementRespond to feedback from users regarding performance and work with developers to improve the performance of queries and indexesTune T-SQL queries and stored procedures to improve performance and sustainabilityProvide support for the deployment of database scripts in development, test, pre-production, and production environmentsMonitor database performance parameters to provide fast query responses to front-end usersReview and learn about the data structures and data storage of company applicationsContinually focus on updating technical knowledge and skillsRefine and automate regular processes, track issues, and document changesAssist developers with complex query tuning and schema refinementPerform scheduled maintenance and support release deployment activitiesShare domain and technical expertise, providing technical mentorship and cross-training to other peers and team membersPerforms all other related duties as assignedQualificationsExperience:10+ Years - Developer in Microsoft SQL Server database environment5+ Years - ETL processesEducation:Bachelor's Degree or equivalent work experienceKnowledge, Skills, & Abilities:Must be an expert in the following:SQLDDLDMLData ModelingData AcquisitionQuery Optimization/TuningDebuggingStrong background in data and the capacity to translate business needs into a technical footprintPreferred:Gaming Industry experience is a plusCloud database experienceOther coding languages:VBAVBPHPCSSJava/JavaScriptPhysical Requirements: In-office and remote work environmentsWork Conditions: Based in the Las Vegas office with the ability to travel. May require up to 10% travel and include weekend and evening hours.Scientific Games Corporation and its affiliates (collectively, "SG") are engaged in highly regulated gaming and lottery businesses. As a result, certain SG employees may, among other things, be required to obtain a gaming or other license(s), undergo background investigations or security checks, or meet certain standards dictated by law, regulation or contracts. In order to ensure SG complies with its regulatory and contractual commitments, as a condition to hiring and continuing to employ its employees, SG requires all of its employees to meet those requirements that are necessary to fulfill their individual roles. As a prerequisite to employment with SG (to the extent permitted by law), you shall be asked to consent to SG conducting a due diligence/background investigation on you.This job description should not be interpreted as all-inclusive; it is intended to identify major responsibilities and requirements of the job. The employee in this position may be requested to perform other job-related tasks and responsibilities than those stated above.SG is an Equal Opportunity Employer and does not discriminate against applicants due to race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. If you'd like more information about your equal employment opportunity rights as an applicant under the law, please click here for EEOC Poster.
Associated topics: data analytic, data architect, data integration, data integrity, data manager, data quality, data warehousing, erp, hbase, teradata