Senior Analytics Engineer

COLLETTE TRAVEL SERVICE INC

Pawtucket (RI)

Hybrid

USD 140,000 - 180,000

Full time

13 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health & Wellness
Time Off
Volunteer Time
Financial Security
Family Support
Travel discounts

Job summary

Collette Travel Service Inc. is seeking an experienced Analytics Engineer to design and develop trusted, scalable data analytics products.

This role interfaces with business and technology stakeholders to model data and build data pipelines transforming raw data into business-ready datasets for marketing, web insights, BI, and AI-powered analytics. The ideal candidate brings deep GA4 expertise, strong SQL and data warehousing skills, and experience with Snowflake, Fabric, and Power BI.

Qualifications

  • 10+ years of analytics engineering, data engineering, BI, or related field.
  • Deep hands-on GA4 and web analytics expertise.
  • Strong SQL, data modeling, warehousing, and ELT skills.
  • Experience with cloud platforms such as Microsoft Azure.
  • Excellent communication and stakeholder management skills.
  • Experience with data governance, metadata, lineage, and data quality.
  • Travel/retail/consumer industries experience is a plus.

Responsibilities

  • Design analytics data models for web traffic, acquisition, engagement, and campaigns.
  • Develop and maintain ELT pipelines for GA4 and marketing sources.
  • Partner with Marketing, Digital, Product, and business stakeholders to translate requirements into datasets.
  • Own data quality, lineage, and performance for curated analytical datasets.
  • Collaborate on BI reports/dashboards with Power BI and Snowflake Cortex.

Skills

GA4
Snowflake
Microsoft Fabric
Power BI
SQL
Data Modeling
ELT
Python
Stakeholder Management
Communication

Education

BS in CS/IS/Data Eng

Tools

GA4
Snowflake
Microsoft Fabric
Power BI
SQL Server

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Enterprise Data & Analytics Full time Professional Pawtucket, RI, US

3 days ago Requisition ID: 2683

Sr. Analytics Engineer to join our growing Data and Analytics Team. This is a hybrid role based at our headquarters in Pawtucket, RI.

About Collette: Let Us Show You the World!

There has never been a better time to be in the travel industry. See the world, connect with others, and experience the immersive benefits of one of the trendiest industries when you join the Collette team! As the longest-running tour operator in North America, our family-owned business leads the industry in innovation and expertise. Collette’s passionate team works hard to fulfill travel dreams and is always looking for talent that will help to shape the company’s future. Being part of the Collette team means having a willingness to grow, a desire to learn and ask questions, and a zest for seeing the world. From giving back to local communities to creating incredible experiences for a world of travelers and being part of a value-oriented team that cares for one another – Collette is all about the people. So, what are you waiting for? Your journey starts here.

Job Summary:

We are seeking a highly experienced, hands-on, and strategic Analytics Engineer to design and develop trusted, scalable data analytics products. This role will interface directly with business and technology stakeholders. You will define requirements, model data for analytics, and develop data pipelines that transform raw and operational data into well-modeled, business-ready datasets that support marketing, web insights, behavioral analytics, business intelligence, and AI-powered analytics.

The ideal candidate demonstrates strong business acumen, communication, SQL, data modeling, and analytics development skills. They have deep technical expertise in Google Analytics, Snowflake, Microsoft Fabric, and Power BI. The ideal candidate combines business analysis with hands-on experience developing reusable ELT transformations, dimensional models, semantic-ready datasets, and data quality controls. This individual will play a critical role in enabling data-driven decision-making and advancing enterprise data modernization initiatives.

Primary Functions:

Web, Digital & Marketing Analytics

  • Serve as a technical subject matter expert for Google Analytics and enterprise web analytics data.
  • Design analytics data models that support web traffic, acquisition, engagement, conversion, campaign, and customer behavior analysis.
  • Develop and maintain reliable data pipelines and transformations for Google Analytics data and related digital marketing sources.
  • Integrate web behavioral data with customer, booking, sales, marketing, and other enterprise data to enable cross-channel analytics.
  • Partner with and enable Marketing, Digital, Product, and business stakeholders to translate measurement requirements into scalable analytical datasets.
  • Establish consistent definitions and reusable data models for sessions, users, traffic sources, campaigns, events, conversions, and digital journeys.
  • Validate web analytics data quality and reconcile reporting differences across source platforms, analytical datasets, and BI solutions.

Data Architecture & Engineering

  • Design conceptual, logical, and physical data models for domain-specific solutions based on business requirements, using 3NF and dimensional modeling approaches as appropriate.
  • Design reusable analytics data products and structures across the Data Warehouse, Data Marts, Data Lakehouse, and Reporting/Analytics layers.
  • Design and develop modular, reusable ELT transformations that meet data quality, SLA, and performance requirements.
  • Apply analytics engineering practices including version control, automated testing, documentation, lineage, code review, and CI/CD.
  • Own data quality, reconciliation, observability, and performance for curated analytical datasets.
  • Support production analytics data products and resolve data issues across the analytical value chain.

Leadership Qualities:

  • Enable and teach key stakeholders and users to leverage new data & analytics products.
  • Demonstrate understanding of and document current state business and systems processes.
  • Outstanding attention to detail with high levels of concentration.
  • Strong analytical and problem-solving skills
  • Ability to multi-task with a strong drive for results.
  • Demonstrated ability in prioritizing and handling multiple projects.
  • Excellent project management skills with a proven ability to meet established deadlines.
  • Extensive latitude for independent judgment, must be able to work independently
  • Talent for quickly learning new disciplines, approaches, technology, etc.
  • Excellent communication and interpersonal skills.

Business Intelligence & Analytics

  • Partner with BI developers and analysts to deliver Power BI semantic models, reports, dashboards, and data agents using trusted analytical datasets.
  • Contribute to and support Snowflake Cortex and Microsoft Copilot Data Agents by providing governed, well-documented, AI-ready data products.

Data Governance & Quality

  • Partner with Data Governance teams to establish metadata management, lineage, master data management, and data quality standards.
  • Manage Data Governance (Metadata Mgmt., Data Lineage, Data Quality, Data Access & Security, Data Privacy, Compliance)
  • Implement architectural controls supporting privacy, security, and retention requirements.
  • Collaborate with governance and catalog teams to ensure data discoverability and trusted data assets.

Knowledge and Skills:

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field.
  • 10+ years of experience in analytics engineering, data engineering, business intelligence, data architecture, or related disciplines.
  • Deep hands-on expertise with Google Analytics 4 (GA4), including its event-based data model and web behavioral analytics concepts.
  • Strong expertise in SQL, data modeling, data warehousing, dimensional modeling, ELT, and analytical data product development.
  • Experience with cloud platforms such as Microsoft Azure.
  • Hands-on experience with modern data technologies including:
    • Snowflake
    • Microsoft Fabric
    • Power BI
    • Google Analytics 4 (GA4) / Web Analytics
    • SQL Server
  • Advanced SQL skills and working proficiency in Python.
  • Experience with modular SQL transformation frameworks and practices.
  • Experience with source control, automated data testing, CI/CD, data governance, metadata, lineage, and data catalogs.
  • Excellent communication, presentation, and stakeholder management skills.
  • Knowledge of Data Lakehouse, Medallion, dimensional, and domain-driven data architecture principles.
  • Experience with marketing and/or behavioral analytics solutions.
  • Experience within travel, hospitality, retail, financial services, or other large-scale consumer-facing industries.

Join us in building a world-class data ecosystem that transforms data into a strategic business asset.

We believe in taking care of our team—inside and outside of work.

The pay range for this position is $140,000 – $180,000.

What We Offer:

  • Health & Wellness: Medical, Dental, and Vision coverage—plus a Peloton One Membership to keep you moving
  • Time Off: Generous PTO, paid holidays, and your birthday!
  • Volunteer Time: Paid hours to give back to causes you care about
  • Financial Security: 401(k) with company match
  • Family Support: Paid parental leave, paid bereavement leave and access to our Employee Assistance Program
  • Exclusive travel discounts, incentives and more!
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Analytics Engineer
Senior Analytics Engineer

Collette Travel Service, Inc. • Pawtucket (RI)

Hybrid
USD 140,000 - 180,000
Health benefits
Paid time off
Volunteer time off
+3
Senior Analytics Engineer
Senior Analytics Engineer

Collette • Pawtucket (RI)

Hybrid
USD 140,000 - 180,000
Health & Wellness
Time Off
Volunteer Time
+3
Dir. Digital Analytic Architect & Engineering
Dir. Digital Analytic Architect & Engineering

COLLETTE TRAVEL SERVICE INC • Pawtucket (RI)

Hybrid
USD 180,000 - 215,000
Health & Wellness
Generous PTO
401(k) match
+1
Director, Digital Analytics Architecture and Engineering
Director, Digital Analytics Architecture and Engineering

Collette • Pawtucket (RI)

Hybrid
USD 180,000 - 215,000
Health & Wellness
Generous PTO
Volunteer hours
+3
Marketing Operations Manager, MarTech
Marketing Operations Manager, MarTech

COLLETTE TRAVEL SERVICE INC • Pawtucket (RI)

On-site
USD 75,000 - 105,000
Health & Wellness
Time Off
Volunteer Time
+3
Senior Analytics Engineer
Senior Analytics Engineer

Education First • Boston (MA)

On-site
USD 135,000 - 170,000
Annual tours
Paid vacation
401(k) match
+2
Senior Analytics Engineer
Senior Analytics Engineer

EF Education First Ltd. • Boston (MA)

Hybrid
USD 135,000 - 170,000
Travel on tours
Paid vacation
401(k) matching
+2
Marketing Automation Manager
Marketing Automation Manager

Collette Travel Service, Inc. • Pawtucket (RI)

Hybrid
USD 75,000 - 110,000
Health & Wellness benefits
PTO and holidays
Volunteer time off
+3
Data Scientist I: Analytics & AI for Travel Growth
Data Scientist I: Analytics & AI for Travel Growth

Preferred Travel Group • Idaho

On-site
USD 80,000 - 100,000
Marketing Operations Manager, MarTech
Marketing Operations Manager, MarTech

Collette • Pawtucket (RI)

Hybrid
USD 75,000 - 105,000
Health & Wellness
Generous PTO
Volunteer Time
+2