Business Intelligence Analyst

Summary

Job DescriptionJob DescriptionThis 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-makingMonitor 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 issuesRecommend 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 DecemberMedical, dental, vision, life and AD&D insuranceShort- and long-term disability insuranceFlexible spending accounts401(k) and pension planAccess to complimentary tickets to Nationals home gamesEmployee discountsFree onsite fitness centerEqual 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.

Job Description

Job DescriptionJob DescriptionThis 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-makingMonitor 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 issuesRecommend 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 DecemberMedical, dental, vision, life and AD&D insuranceShort- and long-term disability insuranceFlexible spending accounts401(k) and pension planAccess to complimentary tickets to Nationals home gamesEmployee discountsFree onsite fitness centerEqual 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.