City Experiences is seeking a Data Engineer for our Business operations

Salary Range: $65,000 - $100,000

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.

About You:

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

About the Opportunity:

We are looking for a passionate data engineer (DE) to own creation of various data lakes and to create pipelines to/from existing data sets. The role will support the City Experience Marketing team who need a broad set of data to develop insights to anticipate consumer purchasing behavior, improve reach, and drive conversion. 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. The DE will support City Experiences’ enterprise data management and data optimization activities. Working primarily across all data capturing elements, the DE will be responsible for integrity, stability, and completeness of all piped datasets in supporting business continuity in replication. You will have an impact on delivering data through migrating proprietary first party data out of our Anchor booking engine for City Experiences brands.

Teaming-up with our in-house software development team Encore®, the DE will be responsible for developing new data pipelines from our DWH powered by AWS. Members of this team will be challenged to innovate using big data technologies. The ideal candidate combines world-class analytical/modeling skills and outstanding business acumen to lead application of customer models, experimental design, and best-in-class measurement tools across our marketing teams with a core focus on data delivery. The Data Engineer, Data Management will be responsible for data definition, ETL, data management tools and processes, data modeling, and developing and maintaining a modern data warehouse to support company wide data management, data analytics and data science functions.

Essential Duties & Responsibilities:

• Work closely with our engineering team to build, augment, and maintain a centralized customer database. Collect, analyze, define, and document data from a variety of sources that will enable development of rich customer insights and analysis.
• Extract transforms and load data from a wide variety of sources into our Data Warehouse.
• 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.
• Additional job duties assigned.

Requirements & Qualifications:

• Bachelor’s or Graduate degree in Information Systems, Statistics, Computer Science, Engineering, Mathematics, or related quantitative discipline, or equivalent practical experience.
• 2-4 years of experience in data engineering, data warehousing and supporting big data analytics projects, including using AWS technologies (Redshift, S3, EMR, RDS, EC2, DynamoDB, Lambda, Kinesis, etc.), BigQuery, and other big data technologies.
• 1-2 years of experience in ETL development in tools like AWS Glue, Lambda Functions, AWS Kinesis, AWS Data Pipelines and similar 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.
• 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 warehouse
• 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.
• Ability to navigate complex business organizations and manage multiple cross-functional stakeholders
• Team oriented, collaborative, and cooperative with a strong work ethic

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 or/harassment of any type, including but not limited to discrimination and or harassment based upon race, religion, religious creed, color, national origin, ancestry, citizenship, sex, sexual orientation, gender, gender identity, gender expression, age, pregnancy or relation medical conditions, childbirth, breastfeeding, parental status, veteran and/or military statue, disability (physical or mental) medical condition, genetic information or characteristics, political affiliation, domestic violence survivor status, marital status, or other characteristics prohibited by federal, state, or local law. Additional, the Company participates in the E-Verify program in certain locations.

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

Job Type: Full-time

Pay: $65,000.00 - $100,000.00 per year

Benefits:

• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Vision insurance

Experience level:

• 3 years

Schedule:

• Monday to Friday

Application Question(s):

• What is your expected salary range?
• Do you now, or will you in the future, require sponsorship for employment visa status (e.g., H-1B visa status, etc.) to work legally for our Company in the United States?

Experience:

• SQL: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)

Work Location: Remote

Please Note :
www.bankofmontserrat.ms is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.bankofmontserrat.ms provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.