Senior Data Engineer
The Senior Data Engineer is responsible for designing, building, and supporting enterprise data warehouse and ETL solutions that enable analytics and reporting across the Casino Resort organization. This role serves as a subject matter expert for data integration, data modeling, and analytics platforms supporting gaming and hospitality systems.
Data Engineering & Architecture
- Design, develop, deploy, and support data warehouse and ETL solutions.
- Build systems to transform, cleanse, and provision enterprise data assets in a secure, governed, and high-performance environment.
- Design and implement relational and dimensional data models.
- Develop and maintain scalable data pipelines and integration frameworks.
Data & Analytics Support
- Serve as a subject matter expert for enterprise data and analytics platforms.
- Provide guidance to analytics and business intelligence users on data architecture and best practices.
- Support the ongoing evolution of the organization's data management capabilities.
Application & Platform Support
- Provide Level 3 application support and participate in on-call support rotations for data and integration platforms.
- Troubleshoot and resolve data pipeline or system integration issues.
- Maintain documentation for data systems, ETL processes, and analytics environments.
Project Collaboration
- Participate in and occasionally lead agile project teams delivering data-centric solutions.
- Collaborate with Product Management and business stakeholders to define requirements for data initiatives.
- Work on multiple initiatives simultaneously, including application support, project work, system enhancements, and architectural planning.
Continuous Improvement
- Stay current with emerging technologies and trends in data warehousing, data management, and analytics.
- Identify opportunities to improve data governance, performance, and operational efficiency.
Additional Responsibilities
- Follow all organizational policies, procedures, and standards of conduct.
- Ensure workplace safety and compliance with company policies.
- Perform other duties as assigned.
Education
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline (or equivalent experience).
Experience
- 8+ years of ETL development experience using SQL Server SSIS (2012–2022)
- 10+ years of T-SQL programming experience
- Strong experience with Microsoft BI technologies, including: SSIS, SSRS, Power BI / PowerPivot, SharePoint
Cloud & Data Platforms
Experience with one or more of the following platforms:
- Google Cloud Platform: BigQuery, Cloud Composer
- Azure: Azure SQL
- Databricks
Technical Skills
- Strong understanding of data warehouse architecture and data modeling
- Experience with automated data pipelines and file integrations (FTP and other methods)
- SQL Server administration experience preferred
- Experience with Python, Java, .NET, C#, or ASP.NET is a plus
- Experience with data quality, master data management (MDM), and data governance concepts preferred
Analytics & Data Science
- Experience or familiarity with: Data preparation for analytics and data science, Big data technologies (Hadoop, Hive, etc.), Advanced analytics or real-time data processing, Business intelligence tools such as Tableau or Microsoft Power BI
Development & Delivery
- Experience working in Agile / Scrum environments
- Experience using Azure DevOps or similar tools preferred
Industry Experience
- Gaming and hospitality industry experience preferred
Additional Requirements
- Must be 21 years of age
- Must be authorized to work in the United States
- Must be able to obtain and maintain Nevada Gaming Control Board registration and any required licenses
- Must be willing to participate in 24/7 on-call support rotation
- Must be able to work flexible schedules, including nights, weekends, and holidays when required
Skills & Competencies
- Strong problem-solving and analytical skills
- Excellent organizational and documentation skills
- Strong interpersonal and communication abilities
- Ability to collaborate with technical teams and business stakeholders
- High attention to detail and strong process orientation