Data Engineer at redsox

DEPARTMENT OVERVIEW: The Business Strategy & Analytics team works with departments throughout the Red Sox organization and the broader Fenway Sports Group ecosystem to help drive data-driven decision-making in all aspects of the company’s business. Responsibilities include predictive analytics, business intelligence, market research, customer segmentation, workflow automation, dynamic ticket pricing, data engineering, data science, and more. POSITION OVERVIEW: The Business Strategy & Analytics team is seeking a talented self-starter with a background and interest in cloud data architecture to join the team as a Data Engineer. This role will be responsible for supporting the Red Sox data architecture and business strategy teams by helping oversee the organization’s Google Cloud Platform (GCP) data environment. This role will learn from and partner with key Red Sox personnel to become an expert on the organization’s data environment, providing support for departments such as ticketing, sales, marketing, and business operations. Boston’s Pay Transparency laws require disclosure of salary ranges in job advertisements and the base salary is commensurate with experience, ranging from $65,000-$85,000. RESPONSIBILITIES: • Own, oversee, and support our existing GCP customer data architecture and design decisions. • Monitor and address issues as they arise, reducing and eliminating outages for downstream users while also building out monitoring dashboards and alerting systems. • Design, build, and maintain reliable ETL pipelines using Python and SQL to ingest new data sources to BigQuery environment. • Partner with internal teams to identify, automate, and streamline recurring data workflows. • Stay up-to-date on modern trends and solutions in the cloud data architecture space by pursuing educational opportunities both internally and externally. • Embed governance, metadata, and data quality controls into data architecture. CHARACTERISTICS/QUALIFICATIONS: • Hands-on experience with cloud-based data warehouses and data lakes across platforms such as GCP, Azure, or AWS. • Proficiency in Python and SQL. • Experience with ETL frameworks, dbt modeling, CI/CD pipelines, and monitoring tools like Grafana. • Experience in maintaining and supporting a complex data environment. • Excellent attention to detail and organizational skills. • Intellectual curiosity and a strong desire and aptitude to learn new topics and tools. • A passion for solving unstructured problems and the ability to take projects from start to finish under tight timelines. • Strong communication (written and verbal) and presentation skills. • Ability to collaborate successfully with a variety of internal partners and stakeholders. • 1-2 years of work experience preferred but not required. At the Boston Red Sox we go beyond embracing diversity. We’re committed to living by our values, strengthening our community, and creating a workplace where people genuinely feel like they belong.    Too often, job seekers don’t apply to positions because they don’t meet every qualification. If you love this role and are great at what you do, we encourage you to apply. Your unique skills and experiences might just be what we’ve been looking for.   Prospective employees will receive consideration without discrimination based on race, religious creed, color, sex, age, national origin, handicap, disability, military/veteran status, ancestry, sexual orientation, gender identity/expression or protected genetic information.