The Venetian Las Vegas | Hiring | Data Engineer – Enterprise Analytics | Las Vegas, NV | BigDataKB.com | 3 Oct 2022

Position Overview:

The primary responsibility of the Data Engineer – Enterprise Analytics is to create and manage reliable and scalable data pipeline, and to contribute to the development of data model, data mart, and logic for KPIs requested by the business leadership. The Data Engineer – Enterprise Analytics also participates in data modeling and development by interpreting business logic required to turn complex ideas into a sustainable value add process.

All duties are to be performed in accordance with departmental and The Venetian Resort’s policies, practices, and procedures.

#dice

Essential Duties & Responsibilities:

• Collaborate with Enterprise Analytics team and other business stakeholders to understand business problems and build/automate data structures ingested by analytics products (e.g.: reports, dashboards, cubes, etc.).
• Create BI solutions, including dashboards (Power BI) and reports (SSRS, Excel, and Cognos).
• Assist in development of logic for KPIs requested by the business leadership.
• Maintain and troubleshoot existing ETLs, SSIS packages, SQL stored procedures and jobs.
• Develop a deep understanding of the Star and Snowflake modeling, dimensional models and ETL processes.
• Write an efficient SQL code for use in data pipelines and data processing.
• Drive data quality processes like data profiling, data cleansing, etc.
• Use innovative problem solving and critical thinking approaches to troubleshoot challenging data obstacles.

Additional Duties & Responsibilities:

• Test, optimize, troubleshoot, and fine-tune queries for maximum efficiency.
• Maintain and continue development of existing Microsoft Power Apps solutions (including but not limited to Power Apps, Power Automate, Power BI, Flows, etc.).
• Assist in QA and UAT processes to foster an agile development cycle.
• Create documentation on table design, mapping out steps and underlying logic within data marts to facilitate data adoption with management’s guidance.
• Identify areas of improvement not just in owned work, but also other areas of the business.
• Create and maintain daily, weekly, monthly, quarterly reports and dashboards.
• Consolidate fractured enterprise reporting into a standardized product for easy visualization and cross-departmental understanding.
• Create reporting structures that accurately link cross-departmental data, which allows for on demand delivery of ad-hoc reports.

Additional Duties & Responsibilities:

• Safety is an essential function of this job.
• Consistent and regular attendance is an essential function of this job.
• Performs other related duties as assigned.

Company Standards of Conduct

All The Venetian Resort Team Members are expected to conduct and carry themselves in a professional manner at all times. Team Members are required to observe the Company’s standards, work requirements and rules of conduct.

Additional Duties & Responsibilities:

Minimum Qualifications:

• 21 years of age.
• Proof of authorization/eligibility to work in the United States.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, Analytics, or related field is required.
• Master’s degree in related discipline is preferred.
• Must be able to obtain and maintain a Nevada Gaming Control Board registration and any other certification or license, as required by law or policy.
• Strong foundational understanding of data types, data structures and database systems and their specific use cases is required.
• Experience with modern BI platforms (e.g.: Power BI, Tableau, MicroStrategy, Google Analytics) is required.
• 1+ years of experience in writing SQL queries, data mining and databases (tables, views, window functions, scalar and aggregate functions, primary/foreign keys, indexes DML/DDL statements, joins and unions) is required.

Minimum Qualifications:

• Must be comfortable working with large structured and unstructured datasets. Experience in either Microsoft Power Suite (Power Apps, Power Automate, Power BI, etc.), Microsoft Azure, Google Big Query, or RPA tools is preferred.
• Experience with programming/scripting languages such as Python or R is preferred.
• Extensive knowledge of Microsoft Excel (Excel formulas, data wrangling, VBA macros, graphs, and pivot tables) is required.
• Excellent critical thinker and effective problem solver with creative solutions.
• Ability to communicate clearly and effectively in English, both in spoken and written form.
• Proficient in Microsoft Word and PowerPoint.
• Ability to communicate clearly and effectively in English, both in spoken and written form.
• Strong interpersonal skills with the ability to communicate effectively with guests and other Team Members of different backgrounds and levels of experience.
• Must be able to work varied shifts, including nights, weekends and holidays.

Physical Requirements:

Must be able to:

• Lift or carry 10 pounds, unassisted, in the performance of specific tasks, as assigned.
• Physically access all areas of the property and drive areas with or without a reasonable accommodation.
• Maintain composure under pressure and consistently meet deadlines with internal and external customers and contacts.
• Ability to interact appropriately and effectively with guests, management, other team members, and outside contacts.
• Ability for prolonged periods of time to walk, stand, stretch, bend and kneel.
• Work in a fast-paced and busy environment.
• Work indoors and be exposed to various environmental factors such as, but not limited to, CRT, noise, dust, and cigarette smoke.