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 datadriven 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 companys 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 worldclass analytical/modeling skills and outstanding business acumen to lead application of various models experimental design and bestinclass 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 nontechnical 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
- Maintainuniformandpersonalgroomingincompliancewithappearancestandards.
- Will be required to be available for work nights weekends and on all major holidays.
- Bachelors or Graduate degree in Information Systems Statistics Computer Science Engineering Mathematics or related quantitative discipline or equivalent practical experience.
- 23 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.
- 12 years of experience in ETL development in a business environment with a variety of large and complex data sets
- 12 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 largescale 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 crossfunctional 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 40year 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 youre 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 Companyis 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 Companyparticipates in the EVerify program in certain locations.
We encourage qualified applicants with arrest and conviction records to apply.