JEI - Corporate Data Analytics Engineer

Jacobs Entertainment Inc

  • Lakewood, CO
  • 4 days ago

    Highlights

    Partner with the analytics team on effective use of AI across the department, including forecasting (covers, occupancy, gaming volume, labor demand), predictive modeling (customer lifetime value, churn, reinvestment), and other applied use cases; evaluate tools, advise on appropriate techniques, and help translate business questions into well-scoped AI/ML problems. Integrate workforce and payroll data from UKG Labor / Kronos, applying Slowly Changing Dimension techniques so labor history (roles, pay rates, property assignments) is preserved for accurate hourly labor efficiency and historical reporting.

    Numbers & Facts

    LocationLakewood, CO

    Description

    A Legacy of Excellence

    Entertaining Your World

    Jacobs Entertainment, Inc. (JEI) is a developer, owner and operator of gaming and entertainment facilities across the United States. Core to the company's value is our commitment to ethical leadership, outstanding training, and open employee communication.

    Jacobs Entertainment is currently in search of a "Corporate Data Analytics Engineer" for our corporate office in Lakewood. If you are seeking an opportunity where your contributions and skills will be both valued and your ability to influence change will be immediate, we would love to speak with you.

    Our employees are supported with a comprehensive benefits program that include the following:

    • $200 Referral Bonus
    • Tuition Reimbursement
    • Ongoing learning and development programs
    • Work towards your future advancement within the company-most of our supervisors and managers are promoted from within
    • 7 paid Holidays
    • 80 hours of Vacation after 1 year of employment
    • 48 Hours of Paid Sick Leave available immediately and renews annually
    • We offer a variety of affordable medical, dental, vision and flexible spending account plans after 60 days
    • Employee Assistance Program FREE of charge
    • Company paid Life Insurance and AD&D
    • Matching 401K program after 90 days

    Essential Job Responsibilities and Duties:

    • Design, build, and maintain robust star-schema data models and SQL views within the Enterprise Data Warehouse (EDW) to support regional operations
    • Build and optimize semantic layers, metadata packages, definitions, and security access models to ensure consistent metrics across the organization
    • Consolidate data structures across disparate regional properties to create a unified view of property performance, guest behavior, and revenue tracking
    • Author clean, well-documented, and performant SQL queries to streamline data pipeline processing and minimize warehouse query runtimes
    • Proactively monitor data pipelines and ETL (Extract, Transform, Load) processes, troubleshooting and resolving integration failures, data quality issues, or pipeline bottlenecks to ensure the timely and accurate delivery of data
    • Feature-engineer dataset tables and prepare structured data views to feed predictive artificial intelligence and machine learning models
    • Partner with the analytics team on effective use of AI across the department, including forecasting (covers, occupancy, gaming volume, labor demand), predictive modeling (customer lifetime value, churn, reinvestment), and other applied use cases; evaluate tools, advise on appropriate techniques, and help translate business questions into well-scoped AI/ML problems
    • Integrate, map, and model guest journey data from the marketing CRM, including omni-channel campaigns, segmentation performance, email open/click behaviors, and promotional attribution
    • Model and interpret core gaming metrics, including Slot/Table Drop, Win/Hold percentages, Theoretical Win (Theo), and coin-in data, in partnership with operations and finance leadership
    • Build and maintain a working understanding of Property Management Systems (PMS) data, including ADR (Average Daily Rate), RevPAR (Revenue Per Available Room), occupancy tracking, and multi-property booking behaviors
    • Map data from Player Tracking Systems, managing rewards, tier progressions, reinvestment rates, and marketing offer redemptions
    • Model food and beverage transaction data from InfoGenesis POS, including check-level detail, menu mix, voids, and comps, to support outlet performance and F&B analytics
    • Integrate workforce and payroll data from UKG Labor / Kronos, applying Slowly Changing Dimension techniques so labor history (roles, pay rates, property assignments) is preserved for accurate hourly labor efficiency and historical reporting

    Skills, Education and Other Requirements:

    • 3-5 years of experience in data modeling, analytics engineering, or business intelligence engineering
    • Advanced SQL mastery, with expert-level ability to write complex analytical queries, stored procedures, database indexes, and performance-tuning optimizations
    • Strong foundational knowledge of relational databases, dimensional modeling, and Enterprise Data Warehouse infrastructure
    • Familiarity or hands-on experience using erwin Data Modeler to view, interpret, or contribute to enterprise-level logical and physical data diagrams
    • Practical experience building enterprise semantic layers, data packages, or structured metadata layouts for enterprise reporting platforms (e.g., IBM Cognos, Looker, or Power BI)
    • Bachelor's Degree in a Quantitative, Computer Science, Information Systems, or related field, or equivalent work experience
    • Ability to work effectively from a designated regional location, with a strong geographic preference for Reno, NV or Denver, CO
    • Strong analytical skill and aptitude for working with data and logical thinking
    • Attention to detail
    • Ability to manage multiple projects at the same time
    • Ability to write detailed reports and correspondence
    • Must possess ability to read and interpret documents such as internal controls and procedure manual
    • Ability to obtain a Colorado Gaming License
    • Identification that establishes identity
    • Identification that establishes the right to work in the United States

    Machinery, Work Equipment, Programs, Software, Hardware Used

    • Computer
    • Agilysys InfoGenesis POS
    • erwin Data Modeler
    • Hotel PMS: Oracle Opera, Infor HMS
    • BI: IBM Cognos Analytics (Framework Manager, Data Modules)
    • SQL / Enterprise Data Warehouse (EDW)
    • UKG Labor / Kronos
    • MS Office
    • IGT Advantage Gaming System preferred (Aristocrat Oasis or Light & Wonder also accepted)
    • dbt (Data Build Tool) preferred

    Similar Jobs