Collette is looking for a
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.Compensation & BenefitsWe 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
- Career Growth: Tuition reimbursement to help you level up your skills
- Exclusive travel discounts, incentives and more!
