Analyst, Business Intelligence & Data Engineering

The Washington Nationals are hiring an Analyst, Business Intelligence & Data Engineering to manage ETL pipelines and the data warehouse supporting revenue and marketing departments. The role focuses on data engineering, system optimization, data quality and governance, and analysis that supports data-driven decisions.

Responsibilities

Design, implement, and monitor the Nationals ETL pipelines and data warehouse, orchestrated through Airflow/Cloud Composer, ingesting ticketing, concessions, retail, loyalty, and MLB-owned data to enable data-driven decisions across revenue departments

Develop and maintain dbt models with automated data tests to ensure accurate, well-documented datasets

Implement automation processes to streamline data workflows, reducing manual intervention and increasing efficiency

Work closely with cross-functional teams to design and implement data models that align with business requirements and support analytical needs

Identify and implement enhancements to data systems, ensuring scalability, efficiency, and data quality

Conduct in-depth data analysis using SQL, Python, or other tools to derive actionable insights and drive strategic decision-making

Monitor and optimize database and query performance to ensure timely and accurate data retrieval

Collaborate with business analysts and IT teams to understand data requirements and facilitate seamless integration with analytical tools

Work with external data vendors to triage and remedy data quality issues

Recommend and advocate for data policies and frameworks for the ongoing management of data

Implement and enforce data governance policies, ensuring data quality, integrity, and security throughout the data lifecycle

Maintain comprehensive documentation of ETL processes, data models, data governance policies, and system configurations, with code managed in GitLab

Other duties as assigned

Preferred

Familiarity with sports industry data and metrics is a plus

Familiarity with Google BigQuery preferred

Familiarity with Google Cloud Platform (or with AWS/Azure and willingness to learn) preferred

Experience with workflow orchestration tools such as Apache Airflow / Google Cloud Composer preferred

Experience with dbt(data build tool) for SQL-based data transformation, testing and documentation preferred

Proficiency with Git-based version control(GitLab) including branching, merge requests and code review preferred

Proficiency in Python development preferred

Proficiency with database structures, schemas, and architectures preferred

Sports Industry Metrics

Google BigQuery

Google Cloud Platform

Amazon Web Services

Microsoft Azure

Workflow Orchestration

Apache Airflow

Google Cloud Composer

dbt

SQL Data Transformation

Data Testing

Data Documentation

Git Version Control

GitLab

Merge Requests

Code Review

Python Development

Database Structures

Database Schemas

Database Architecture

Willingness to Learn

Benefits

Paid vacation and sick leave, paid holidays throughout the year and a holiday break in December

Medical, dental, vision, life and AD&D insurance

Short- and long-term disability insurance

Flexible spending accounts

401(k) and pension plan

Access to complimentary tickets to Nationals home games

Employee discounts

Free onsite fitness center

Company

Major League Baseball team based in Washington, D.C.

Washington, District of Columbia, USA

https://nationals.mlb.com/

Founded in 2005

501-1000 employees

Qualifications

Must have U.S. work authorization

2+ years of experience in a technical systems integration role, with demonstrated capabilities in data management best practices, long-term maintainability of code, and ability to effectively solve problems pertaining to data infrastructure and integrity

Proficiency in Microsoft Excel, PowerPoint, and Word required

Proficiency in SQL required

Proficiency in Tableau and/or similar data visualization tool required

Ability to extract key insights from large, disparate datasets and synthesize into key recommendations for leadership

Excellent communication skills and ability to tailor key messages to the appropriate audience

Strong attention to detail

Strong sense of ownership and accountability - a self-starter

Utmost standards of integrity in all business dealings

Computer Science

Familiarity with sports industry data and metrics is a plus

Familiarity with Google BigQuery preferred

Familiarity with Google Cloud Platform (or with AWS/Azure and willingness to learn) preferred

Experience with workflow orchestration tools such as Apache Airflow / Google Cloud Composer preferred

Experience with dbt(data build tool) for SQL-based data transformation, testing and documentation preferred

Proficiency with Git-based version control(GitLab) including branching, merge requests and code review preferred

Proficiency in Python development preferred

Proficiency with database structures, schemas, and architectures preferred

2+ years of experience in a technical systems integration role, with demonstrated capabilities in data management best practices, long-term maintainability of code, and ability to effectively solve problems pertaining to data infrastructure and integrity.

Required skills

SQL, Tableau, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Data Management, Technical Systems Integration, Data Infrastructure and Integrity, Python, Google BigQuery, Apache Airflow / Google Cloud Composer, dbt, GitLab, Data Analysis

Preferred skills

Familiarity with sports industry data and metrics is a plus, Familiarity with Google BigQuery preferred, Proficiency in Python development preferred

Experience

2+ years