DATA ENGINEER II - ENTERPRISE ANALYTICS Job at The Venetian Las Vegas, Las Vegas, NV

WUVBMldGTXVzRE4wWHAxWGs0TmRKRHAvS1E9PQ==
  • The Venetian Las Vegas
  • Las Vegas, NV

Job Description

Position Overview:

The primary responsibility of the Data Engineer II – Enterprise Analytics is assisting in designing, developing, and deploying data-driven solutions as part of Enterprise Analytics data strategy and goals. Data Engineer II – Enterprise Analytics is responsible for creating reliable ETLs and scalable data pipelines to support Analytics and BI environment (including modeling and machine learning, visualizations, reports, cubes & applications, etc.). Data Engineer II – Enterprise Analytics participates in data modeling and development of data models and data marts by interpreting business logic required to turn complex ideas into a sustainable value add processes.

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

Essential Duties & Responsibilities:

  • Collaborate with Enterprise Analytics BI Analysts and Data Scientists, 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).
  • Development of logic for KPIs requested by the business leadership.
  • Troubleshoot existing and create new ETLs, SSIS packages, SQL stored procedures and jobs.
  • Assist in Star and Snowflake modeling, creating 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.
  • Develop best practices and approaches to support continuous process automation for data ingestion and data pipelines.
  • 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 existing and create new Microsoft Power Apps solutions (including but not limited to Power Apps, Power Automate, Power BI, Flows, etc.) according to business needs.
  • Perform 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 minimum guidance from the Enterprise Analytics management.
  • Identify areas of improvement not just in owned work, but also other areas of the business.
  • Mentor and train junior Data Engineers on best practices, query and ETL optimization techniques.
  • 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.

Additional Duties & Responsibilities:

  • Create reporting structures that accurately link cross-departmental data, which allows for on demand delivery of ad-hoc reports.
  • 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.
  • 2+ years of experience in building data pipelines and ETL processes is required.
  • 2+ years of experience creating visualizations and reports (Power BI, Tableau, MicroStrategy, Google Analytics) is required.
  • 2+ years of experience in writing advanced SQL, data mining and working with traditional relational databases (tables, views, window functions, scalar and aggregate functions, primary/foreign keys, indexes DML/DDL statements, joins and unions) and/or distributed systems (Hadoop, Big Query) is required.

Minimum Qualifications:

  • 1+ years of experience with programming/scripting languages such as Python, R or Big Query is required.
  • Experience in either Microsoft Power Suite (Power Apps, Power Automate, Power BI, etc.), Microsoft Azure, Google Cloud Platform, or RPA tools is preferred.
  • Excellent understanding of data types, data structures and database systems and their specific use cases is required.
  • Strong understanding of data modeling principles including Dimensional modeling, and Data Normalization principles is required.
  • 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.

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.

Job Tags

Similar Jobs

Headway

LP (Remote) Job at Headway

 ...deciding how many clients you see through Headway, so that you can set the hours that work for you. Grow your caseload by providing marketing support and patient referrals. Well also support your patients by Providing customized support to clinicians and patients... 

ADEX Medical Staffing

Registered Nurse - F1/OPT Visa Sponsorship Job at ADEX Medical Staffing

 ...Create your own destiny in the United States! On a Student Visa or OPT? Join our green card sponsorship program and receive a permanent Employment Authorization Document (EAD) and a green card and we will place you in a U.S. hospital. Qualifications: Candidates must... 

Sid Jacobson JCC

Certified Personal Trainer Job at Sid Jacobson JCC

 ...The Personal Trainer I is responsible for introducing members to the joys of fitness and maintaining a positive experience for increased member retention. This position lead, instruct, and motivate individuals to perform various exercises to minimize injuries and improve... 

Career Systems Development Corporation

Mental Health Consultant- SBX Job at Career Systems Development Corporation

Description: Job Summary: Responsible for developing, implementing, and monitoring the Mental Health Program to include staff development, mental health counseling of students, according to the Job Corps Federal Regulations and the (PRH) Policy and Requirements ...

NBCUniversal

Summer 2025 Internship, NBC & Telemundo Miami Job at NBCUniversal

 ...NBCUniversal internships are true learning and growth opportunities that help set students up for an exciting future career in media. We are committed to developing early career talent, and we are focused on helping our interns realize their potential and their dreams...