Data Engineer

POSITION TITLE:  Data Engineer (Hybrid)

DEPARTMENT:  Analytics and Technology

LOCATION:  Arlington, VA

STATUS:  Full-time, Exempt

MANAGER:  Sr. Director, Analytics and Technology

PBS Distribution (PBSd)* is a leading distributor of public media content around the world, entertaining audiences across platforms and formats. The company, a joint venture of PBS and GBH Boston, provides premium content through multiple digital channels and video services.  PBS Distribution operates six subscription streaming channels — PBS Masterpiece (US and CA), PBS KIDS, PBS Living, PBS Documentaries, and PBS America (U.K.)  as well as numerous Free Ad-supported Streaming TV (FAST) Channels in the U.S and U.K.  In addition, the company reaches viewers through transactional video-on-demand (TVOD), subscription video-on-demand (SVOD) licensing, Advertising-based Video on Demand (AVOD), DVD and Blu-ray, theatrical releasing, educational platforms, non-theatrical and inflight sales, and serves broadcasters and producers providing program sales and co-production financing.

At PBS Distribution, we want to best represent the communities that we serve. The global community is diverse, and we are our best when we have a team that reflects that.  PBS Distribution is proud to be an equal opportunity workplace, celebrating, supporting, and thriving when our team can show up fully and authentically.

POSITION SUMMARY:

The Data Engineer is responsible for the department's data value add work, including developing data models, maintaining a data warehouse and analytics environment, and writing scripts for data integration and analysis.  This role will work closely and collaboratively with members of the Analytics and Technology teams to define requirements, mine and analyze data, integrate data from a variety of sources, and deploy high quality data pipelines in support of the analytics needs across the enterprise. They will also support the comprehensive Data Warehouse and manage other proprietary systems.

RESPONSIBILITIES:

• Configure and maintain servers and databases.
• Build, operate, and maintain ETL processes that gather data from internal and external systems.
• Model data pipelines in DBT to prepare data for analysis. 
• Write internal tools to assist with data cleaning and labeling. 
• Adhere to high standards for code quality and testing. 
• Clarify data requirements and priorities with other project teams. 
• Expose data to internal interfaces and users across the enterprise.

WORK EXPERIENCE:

• 4+ years of experience building and maintaining backend software or services
• 2+ year of experience working with large scale data (1+ TBs, 2B+ rows) 
• 3+ year of SQL experience
• 1+ year building web interfaces using JavaScript libraries like React a plus
• Familiarity with general Finance and Accounting terms and data a plus
• Exposure to building Machine Learning Models in areas like Revenue Forecasting and Optimization strongly preferred

EDUCATION/TRAINING:

• Bachelor’s degree in Computer Science, Engineering, or related field or equivalent experience

SKILLS:

• 3+ years of experience building complex server-side data processing applications, optimizing complex SQL queries at scale
• 2+ years of experience modeling data in relational and columnar databases, building data pipelines using tools like DBT
• Able to work independently with minimal supervision while adhering to company policies, legal requirements, and customer specifications
• Strong verbal, written, and interpersonal communication skills

PBS Distribution (PBSd) is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind. 

*PBS Distribution is a for-profit organization with a mission to drive profitable growth by building key partnerships and distributing inspiring content.  PBS Distribution is headquartered in Arlington, VA with an additional office In Boston, MA.