Data Engineer
Key Responsibilities
- Design and implement scalable data architectures to support the collection, storage, and processing of large datasets.
- Write efficient SQL queries to extract, manipulate, and analyze data from relational databases, ensuring optimal performance.
- Develop and manage ETL (Extract, Transform, Load) workflows to integrate data from various sources into our data warehouse. Experience with tools like Apache Airflow or Google Cloud Dataflow is a plus.
- Utilize Google Cloud Platform (GCP) services, such as BigQuery, Cloud Storage, and Dataflow, to build robust data solutions.
- Implement data validation and cleansing processes to ensure high data quality and integrity throughout the pipeline.
- Work closely with data scientists and analysts to understand their data needs and provide support in data exploration and reporting.
- Continuously monitor and optimize data processing and storage performance, ensuring timely access to data for business insights.
- Maintain clear documentation of data architecture, ETL processes, and data models to support team collaboration and knowledge sharing.
Requirements
- 3+ years of experience in data engineering or a related field, with a solid understanding of data architecture and design principles.
- Strong skills in writing complex SQL queries and optimizing database performance.
- Experience with ETL tools and frameworks for data integration and transformation.
- Familiarity with Google Cloud services, particularly BigQuery, Cloud Storage, and Dataflow.
- Proficiency in programming languages such as Python or Java for data manipulation and pipeline development.
- Proficiency with relational databases, including MS SQL, MySQL, and Oracle.
- Strong analytical and problem-solving abilities, with attention to detail.
- Excellent verbal and written communication skills to collaborate effectively with team members and stakeholders.
Preferred Qualifications
- Experience with big data technologies (e.g., Apache Hadoop, Spark).
- Knowledge of machine learning concepts and frameworks.
- Familiarity with data visualization tools (e.g., Tableau, Looker).
Additional Company information
- In September 2022, MSE acquired the regional sports network, then-called NBC Sports Washington and newly rebranded as Monumental Sports Network. Monumental Sports Network now holds the exclusive local television media rights to Capitals’, Wizards’, and Mystics’ games. The network is both a linear channel and a digital operation. Prior to acquiring the linear platform, the digital platform was launched by MSE in 2016, as the first-of-its-kind regional sports network for digital, mobile, and streaming platforms. Those linear and digital platforms are now combined and join Caps Radio, Wizards Radio, MSE Outdoor and Monumental Productions for a full suite of six media enterprises.
- In addition to Capital One Arena – a venue which hosts 3M+ visitors across over 250 events annually, MSE also manages MedStar Capitals Iceplex (training facility for the Capitals), MedStar Health Performance Center (training facility for the Wizards, Mystics, and Go-Go) and EagleBank Arena (a 12,000+ live event venue on George Mason University’s campus).
- In July 2020, MSE partnered with William Hill (subsequently acquired by Caesars Entertainment) to open the first ever in-arena sportsbook in North America, now called Caesars Sportsbook.
- MSE opened “District E powered by Ticketmaster” in the spring of 2023, a flagship esports and entertainment venue. This 14,000-square-foot live-event theater offers a 365-day-a-year series of immersive experiences in esports, music, culinary excellence, event programming, and community events.