Senior Data Warehouse Engineer - ELT & Analytics

Boston Celtics; Boston (MA); On-site; USD 150,000 - 175,000; Full time

Job summary

The Senior Database Engineer at Boston Celtics will design, build, and maintain our internal data warehouse, creating an architecture that supports operational data use across the organization. You will develop robust ELT pipelines and establish engineering best practices to deliver a unified, trusted data ecosystem powering analytics, reporting, ML, and consumer engagement initiatives.

You will work with cross-functional teams to transform business needs into scalable data solutions, ensuring

Qualifications

• Bachelor’s degree or equivalent in data engineering, computer science, Information Systems, Data Science or similar field
• Minimum of 5 years of data engineering experience
• Expert understanding of both relational and non-relational databases and query optimization techniques
• Familiarity with APIs, data ingestion patterns, and data integration techniques with a strong understanding of distributed data processing and storage concepts
• Exceptional attention to detail with strong problem-solving skills and ability to debug complex data issues
• Experience implementing data governance practices, including data quality frameworks, data lineage, metadata management, access controls, and compliance with organizational and regulatory standards
• Proven ability to collaborate cross-functionally with BI teams, marketers, and other business stakeholders to translate data requirements into scalable technical solutions
• Self-starter who thrives in a fast-paced environment
• Preferred experience with Tableau, Salesforce, Ticketmaster, Fanatics systems and data
• Ability to work flexible hours, including evening, weekends, and holidays as needed

Responsibilities

• Design, build, and maintain scalable and reliable data pipelines to ingest data from various sources to optimize ETL/ELT workflows to efficiently process large volumes of data
• Lead end-to-end data architecture decisions and development to ensure scalability, reliability, and long-term platform evolution
• Work across platforms to integrate data from CRM and ticketing platforms, CDP, website, mobile app, and external systems into a unified, reliable ecosystem
• Establish best-practices in warehouse architecture that ensures consistency, governance, and high-quality data across the platform
• Ensure pipelines are fault-tolerant, observable, and recoverable with appropriate logging and alerting system
• Oversee and deploy cost-optimization strategies as it relates to our data infrastructure
• Drive automation initiatives to reduce manual workflows and improve pipeline reliability
• Contribute to improving data accessibility and usability across the organization.
• Support both batch and streaming architecture where applicable
• Document data pipelines, data sources, and system architecture
• Coach engineer(s) through code reviews, technical guidance, and support in developing strong engineering practices
• Collaborate with cross-functional partners to translate business needs into scalable data solutions
• Continuously improve pipeline performance, scalability, and cost efficiency
• Contribute to strategic initiatives and special projects assigned by the Sr. Vice President of Business Strategy & Operations

Skills

Data engineering

Data governance

Data quality

Data lineage

Metadata management

APIs

Data ingestion

Distributed data processing

SQL

Cross-functional collaboration

Problem solving

Self-starter

Education

Bachelor’s degree or equivalent in data engineering or related field

Tools

Tableau

Salesforce

Ticketmaster

Fanatics systems

Job description

The Senior Database Engineer at Boston Celtics will design, build, and maintain our internal data warehouse, creating an architecture that supports operational data use across the organization. You will develop robust ELT pipelines and establish engineering best practices to deliver a unified, trusted data ecosystem powering analytics, reporting, ML, and consumer engagement initiatives.

You will work with cross-functional teams to transform business needs into scalable data solutions, ensuring