Data Engineer

City Experiences is seeking a Data Engineer for our Technology operations

About You:

This person will be adaptable, dynamic, and embody City Experiences’ RESPECT Service System.

About the Opportunity:

This person will be a key member of the Data team helping us to analyze data in our Data Mesh and other sources. The role supports the entire Hornblower team who need a broad set of data to develop insights to anticipate consumer purchasing behavior, improve reach, enable data-driven operations and planning decisions. Data is at the center of every insight we will develop as we create business analytics solutions that serve the needs of our internal customers and external partners. This role is critical to the company’s success to identify ways to improve the customer experience and the business overall. You will have an impact on the Hornblower brands. Members of this team will be challenged to innovate using big data technologies including data meshes and data lakes. The ideal candidate combines world-class analytical/modeling skills and outstanding business acumen to lead application of various models, experimental design, and best-in-class measurement tools across our teams. 

Essential Duties & Responsibilities:

• Work closely with our engineering team to collect, analyze, define, and document data from a variety of sources in our data mesh that will enable development of rich business insights and analysis.  
• Design new methodologies, pulling necessary data, building data models with accuracy from various data sources. 
• Design, develop, launch, automate and maintain reliable data pipelines in production. 
• Optimize SQL query performance, reports and ETL processes. 
• Perform root cause analysis and resolve production and data issues. 
• Design and implement reporting solutions based on users’ needs. Develop dashboards, reports, and tools to help monitor performance and drive growth ensuring data hygiene and data integration across sources. 
• Collaborate with business stakeholders to establish clear analytical objectives, approaches, and timelines.  
• Identify data infrastructure issues and drive to resolution.
• Summarize, visualize, communicate, and document analytic concepts, processes, and results for technical and non-technical audiences. 
• Provide thought leadership and innovation in process, technique, and implementation. 
• Work in an agile team.
• Additional job duties assigned. 

Requirements & Qualifications:

• Strong customer service, organization, and interpersonal skills.
• Maintain a high level of organization, detailed oriented and meet deadlines.
• Handle multiple tasks/projects at one time.
• Establish and maintain effective working relationships as required by job responsibility.
• Listen effectively, assess the situation, determine relevant issues, & suggest solutions.
• Have a working knowledge of computer skills, including but not limited to proficiency with Microsoft Office Suites.
• Must be able to effectively understand and convey written and verbal information to coworkers and
• Maintain uniform and personal grooming in compliance with appearance standards.
• Will be required to be available for work nights, weekends and on all major holidays.
• Bachelor’s or Graduate degree in Information Systems, Statistics, Computer Science, Engineering, Mathematics, or related quantitative discipline, or equivalent practical experience. 
• 2-3 years of experience in data engineering, data warehousing and supporting big data analytics projects including Trino, MySQL and StarRocks databases. Some experience with AWS technologies for example Redshift, S3, EMR, RDS, EC2, DynamoDB, Lambda, Kinesis, etc. 
• 1-2 years of experience in ETL development in a business environment with a variety of large and complex data sets 
• 1-2 years of experience in a quantitative role in analytics  
• Expertise in SQL and working with structured and unstructured datasets, as well as data visualization technologies such as Looker or Tableau. 
• Working knowledge of a scripting language (e.g., Python, R) and experience extracting data from REST APIs and script scheduling. Experience with Airflow and NiFi a plus.
• Deep proficiency with schema design and dimensional data modeling. 
• Experience with big data and cloud platforms to deploy large-scale data science solutions 
• Experience integrating web analytics tools (e.g., Google Analytics) into a data mesh 
• Experience with one or more ETL tools (MuleSoft, Hevo, Boomi, etc.) 
• Knowledge in CRM or lifecycle marketing functions with strong analytical grasp of ecommerce and lifecycle channel measurement KPIs  
• Comfortable leveraging data from multiple data sources to produce actionable business insights. 
• Comfortable with spreadsheet and presentation tools (Excel, PowerPoint). 
• Ability to navigate complex business organizations and manage multiple cross-functional stakeholders 
• Team oriented, collaborative, and cooperative with a strong work ethic 
• Agile team player

About Us:

City Experiences’ passion is to provide amazing experiences on land and water. Our 40-year success through organic growth and acquisitions has resulted in a portfolio of over 25+ brands that welcome upwards of 30 million guests/riders annually. If you’re an enthusiastic team player who thrives in an environment where communication, creativity, and cooperation are encouraged, this may just be the opportunity for you.

The RESPECT Service System embodies City Experiences’ mission, vision, values and operating principles. By creating a company culture that puts RESPECT at its core, we believe it will drive us to achieve our goal of becoming a Global Experiences and Transportation Leader.

The Company is proud to be an Equal Employment Opportunity and Affirmative Action employer. We prohibit discrimination and harassment against any applicants or employees based upon their race, color, religion, national origin, sex, age, sexual orientation, gender identity or expression, mental or physical disability, status as a protected veteran, or other characteristics prohibited by applicable law. 

 Additionally, we encourage all qualified applicants including those with past arrest or conviction records to apply. The Company participates in the E-Verify program in certain locations. 

We encourage qualified applicants with arrest and conviction records to apply.