CRM Business Data Analyst jobs in District of Columbia

Summary:

This position, reporting to the Senior Director, Business Strategy & Analytics, 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, ingesting ticketing, concessions, retail, loyalty, and MLB-owned data to enable data-driven decisions across revenue departments
• 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

• Uphold the Nationals' values of Excellence, Performance and Accountability
• Other duties as assigned

Requirements:

Minimum Education and Experience Requirements

• Undergraduate degree, with major in engineering, computer science, information systems, or a related field
• 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
• Familiarity with sports industry data and metrics is a plus

Knowledge, Skills, and Abilities necessary to perform essential functions

• Proficiency in Microsoft Excel, PowerPoint, and Word required
• Proficiency in SQL required
• Familiarity with Google BigQuery preferred
• Familiarity with Google Cloud Platform (or with AWS/Azure and willingness to learn) preferred
• Proficiency in Tableau and/or similar data visualization tool required
• Proficiency in Python development preferred
• Proficiency with database structures, schemas, and architectures preferred
• 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
• Position will require some weekend and/or evening work

Physical/Environmental Requirements

• Office: Working conditions are normal for an office environment.