Analyst, Business Intelligence & Data Engineering

Washington Nationals; Washington (District of Columbia); On-site; USD 70,000 - 75,000; Full time

Benefits offered by this job

Paid vacation & sick leave

Medical, dental, vision insurance

401(k) and pension plan

Complimentary Nationals game tickets

Free onsite fitness center

Employee discounts

Job summary

Washington Nationals is seeking a Senior Data Engineer to manage ETL pipelines and a data warehouse, ensuring scalable data flows across revenue and marketing. You will build dbt models, automate workflows, and collaborate with analysts and IT to meet analytical needs.

The role requires 2+ years in data/integration roles, strong SQL and Tableau skills, and a hands-on approach to data quality and governance. Onsite work in Washington, DC with a comprehensive benefits package.

Qualifications

• U.S. work authorization required.
• 2+ years in a technical systems integration role with data infrastructure experience.
• Proficiency in Excel, PowerPoint, and Word.
• Proficiency in SQL.
• Proficiency in Tableau or similar data visualization tool.
• Ability to extract insights from large datasets and summarize for leadership.
• Strong communication and ownership mindset.
• Office environment with occasional weekend/evening work.

Responsibilities

• Design, implement, and monitor ETL pipelines and data warehouse using Airflow/Cloud Composer.
• Develop and maintain dbt models with automated data tests.
• Automate data workflows to reduce manual intervention.
• Collaborate with cross-functional teams to align data models with business needs.
• Identify enhancements for scalability, efficiency, and data quality.
• Analyze data with SQL, Python, and other tools to derive actionable insights.
• Monitor database/query performance for timely, accurate data retrieval.
• Work with external data vendors to triage data quality issues.
• Document ETL processes, data models, governance policies, and configurations (GitLab).

Skills

SQL

Python

Data modeling

Communication

Problem solving

Ownership

Education

Bachelor's degree in Computer Science or related field

Tools

Airflow

dbt

GitLab

Tableau

Google BigQuery

Cloud platforms

Job description

This position, reporting to the Senior Manager, Business Intelligence & Data Engineering, is responsible for managing ETL (extract, transform, load) pipelines, ensuring seamless data flow and accessibility across Nationals revenue and marketing departments. This technical role requires expertise in data engineering, system optimization, and an understanding of the sports industry’s data landscape.

Essential Duties and 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.

Compensation

The projected annual salary range for this position is $70,000 - $75,000 per year.Actual pay is based on several factors, including but not limited to the applicant’s: qualifications, skills, expertise, education/training, certifications, and other organization requirements. Starting salaries for new employees are frequently not at the top of the applicable salary range.

Benefits

The Nationals offer a competitive and comprehensive benefits package that presently includes:

• 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

Equal Opportunity Employer

The Nationals are dedicated to offering equal employment and advancement opportunities to all individuals regardless of their race, color, religion, national origin, sex, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, matriculation, political affiliation, genetic information, disability, or any other protected characteristic under applicable law.

Experience Required

• Must have U.S. work authorization.
• Must successfully clear a background check.
• 2 year(s): 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.
• Office: Working conditions are normal for an office environment. Position will require some occasional weekend and/or evening work.
• Uphold Core Values: Innovation, Integrity, and Teamwork. These core values set the tone in everything we do, help us succeed on and off the field, make a difference in the community and provide the best guest experience in sports. It is important that the person in the position commits themselves to these core values so that we can constantly move forward in the same direction – Together.

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.

Education Required

Bachelors or better in Computer Science or related field

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.