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