JEI - Corporate Data Analytics Engineer

Jacobs Entertainment Inc

  • Lakewood, CO
  • 4 days ago
    Want to know if you’re a fit?
    Upload your resume and let our AI show you.

    Skills

    • Accidental Death and Dismemberment (AD&D)unmatched
    • Analysis Skillsunmatched
    • Artificial Intelligence (AI)unmatched
    • Business Intelligenceunmatched
    • Campaignsunmatched
    • Channel Strategiesunmatched
    • Communication Skillsunmatched
    • Compensation and Benefitsunmatched
    • Computer Scienceunmatched
    • Customer Relationship Management (CRM)unmatched
    • Data Analysisunmatched
    • Data Managementunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Structuresunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Detail Orientedunmatched
    • Dimensional Modelingunmatched
    • Financeunmatched
    • Financial Analysisunmatched
    • Food and Beverage Industryunmatched
    • Forecastingunmatched
    • Gamingunmatched
    • IBM Cognosunmatched
    • Identify Issuesunmatched
    • InfoGenesisunmatched
    • Information Technology & Information Systemsunmatched
    • Kronos Productsunmatched
    • Leadershipunmatched
    • Life Insuranceunmatched
    • LifeTime Value (LTV)unmatched
    • Lookerunmatched
    • Machine Learningunmatched
    • Marketingunmatched
    • Metadataunmatched
    • Metricsunmatched
    • Microsoft Officeunmatched
    • Multitaskingunmatched
    • Operational Supportunmatched
    • Oracleunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Predictive Modelingunmatched
    • Project/Program Managementunmatched
    • Property Managementunmatched
    • Query Analysisunmatched
    • Relational Databases (RDBMS)unmatched
    • SQL (Structured Query Language)unmatched
    • Star Schemaunmatched
    • Stored Proceduresunmatched
    • Structured Dataunmatched
    • Systems Administration/Managementunmatched
    • Time Managementunmatched
    • Training Data Setsunmatched
    • Tuition Reimbursementunmatched
    • Use Casesunmatched
    • Writing Skillsunmatched
    • erwin Data Modelerunmatched

    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

    Numbers & Facts

    LocationLakewood, CO

    Similar Jobs