> Markdown version of [/jobs/ext/1508215-jei-corporate-data-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/1508215-jei-corporate-data-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # JEI - Corporate Data Analytics Engineer - **Company:** Jacobs Engineering Group Inc. - **Location:** Lakewood, CO, United States - **Experience:** Experienced - **Salary:** $135,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Information Systems, Databases, Extract Transform Load (ETL), Data Structures, Data Warehousing, Relational Databases, Dimensional Modeling, IBM Cognos Business Intelligence, Microsoft Office, Oracle (Applications), Performance Tuning, Power BI, SQL Stored Procedures, SQL Databases, Transaction Data, Enterprise Data Management, Kronos, Data Build Tool (dbt), Data Layers, Information Technology, Infor, Looker Analytics, Data Pipelines - **Published:** July 30, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=011195dc30f6deaf ## About the Role * 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 ## Description * 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Winning talents through play - Corporate Gaming with AKEYI](https://www.wearedevelopers.com/videos/1062-winning-talents-through-play-corporate-gaming-with-akeyi) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)