Job Description
- Design, build, deliver and support Data Warehouse and ETL structures and, SQL procedures and query solutions.
- Act as an internal consultant, providing architecture, vision, problem anticipation, and problem solving for the assigned project(s), as well as a Subject Matter Expertise for data and analytic users.
- Provide subject matter expertise for the data associated with gaming and hospitality systems.
- Provide senior level application and on-call support for data and integration solutions.
- Participate and at times lead project teams within an agile environment.
- Successfully engage in multiple initiatives concurrently, including application and on call support, minor projects, major projects, functional requirements, systems specifications, and subject matter expertise.
- Prepare clear and concise documentation for delivered solutions and processes, integrating documentation with corporate knowledgebase.
- In partnership with the Product Management team, provide subject matter expertise for determining business requirements to address business opportunities or issues across business functions for data centric solutions.
- Maintain familiarity with technological trends and innovations in the data warehousing and data management domains.
- Interpret and satisfy business needs by building and enhancing systems to transform, cleanse and provision corporate data assets in a governed, secure and high-performance manner.
- Provide subject matter expertise for data and analytics.
- Participate in the ongoing Data Management maturation process.
- Proof of authorization/eligibility to work in the United States.
- Bachelor’s degree or equivalent in relevant discipline
- Must be able to obtain and maintain Nevada Gaming Control Board Registration and any other certification or license, as required by law or policy.
- 8 years ETL experience using SQL Server SSIS 2008r2-2016.
- 10 years with T-SQL programming.
- Must exhibit a high level of mastery of the Microsoft BI Stack, including: SSIS (or something equivalent), SharePoint, PowerPivot, etc.
- Must understand Relational and Dimensional database modeling.
- Should be experienced in automated file handling with ETL tools via FTP and other means.
- Should have administrative experience with SQL Server 2008-2016.
- Preferred experience with cloud; python scripting languages, and web site operations is a plus.
- Prefer experience with key concepts of Data Management such as Data Quality and MDM.
- Experience with Data Preparation for Data Science a plus.
- Experience with Big Data, Advanced Analytic techniques and Real Time data a plus.
- Must be willing and capable of adopting new technologies and paradigms such as Big Data technologies (Hadoop, hive, etc.), event-based analytics, etc.
- Must be able to adhere to SOPs and methodologies and be willing to improve them when necessary.
- Must have strong organizational skills, customer service focus, attention to detail, and process orientation.
- Must be willing to be 24 x 7 on-call support.