Data Warehousing Specialist (R50033544)

FOX; Los Angeles (CA); Hybrid; USD 184,000 - 202,000; Full time

Benefits offered by this job

Medical/dental/vision

401(k) plan

Paid time off

Job summary

FOX Corporation is seeking a Senior Data Engineer within the Data Platforms team to build robust, scalable data engineering solutions using a modern tech stack in a fast-paced environment.

You will collaborate with Agile teams to design, develop and optimize data pipelines, focusing on data quality, security and real-time ingestion. Remote/onsite flexibility includes up to 25% telecommuting within the LA area.

Qualifications

• Bachelor's degree in Computer Science, Computer Engineering, Data Science, Mathematics, Statistics, Engineering or related field plus five years of progressive data engineering experience.
• Experience building data pipelines with Python and PySpark.
• Experience building Lakehouse or batch/streaming data pipelines in Databricks.

Responsibilities

• Collaborate with Agile teams to design and develop data engineering solutions.
• Build distributed, low-latency data pipelines with high availability and timely delivery of data.
• Design and develop optimized data engineering solutions for Big Data workloads to handle increasing data volume.
• Build real-time data ingestion solutions for streaming workloads.
• Adhere to best practices and design patterns across Data Engineering solutions.
• Ensure code is clean, performant and well-tuned for production.
• Focus on data quality and implement monitoring to ensure production data accuracy.
• Create design and test documentation (Data Flow Diagrams, Design Specs, Source-to-Target mappings).
• Perform data analysis to troubleshoot issues and support resolution.
• Automate end-to-end data pipelines and validations; enforce data security and privacy with access controls and encryption.
• Proactively learn new technologies and educate the team, collaborating with analytics to improve data models for BI.

Skills

Python

PySpark

Data modeling

SQL

Cloud data engineering

Education

Bachelor's degree in Computer Science/Engineering/Data Science/Math/Statistics or related field

Tools

Snowflake

Fivetran

dbt

Kafka

Kinesis

Spark

Hadoop

Flink

Airflow

Astronomer

AWS S3

AWS EC2

AWS EMR

AWS Lambda

AWS RDS

AWS Redshift

AWS Glue

Job description

OVERVIEW OF THE COMPANY

Fox CorporationUnder the FOX banner, we produce and distribute content through some of the world's leading and most valued brands, including: FOX News Media, FOX Sports, FOX Entertainment, FOX Television Stations and Tubi Media Group. We empower a diverse range of creators to imagine and develop culturally significant content, while building an organization that thrives on creative ideas, operational expertise and strategic thinking.

JOB DESCRIPTION

Job Duties

As part of the Data Platforms team, Fox Cable Network Services, LLC seeks a Data Warehousing Specialist (Senior Data Engineer) to play an essential role in building robust, scalable, efficient and high-quality Data Engineering solutions using the latest tech stack in a fast-paced environment.

• Collaborate with and across Agile teams to design and develop data engineering solutions.
• Build distributed, low latency, reliable data pipelines ensuring high availability and timely delivery of data.
• Design and develop highly optimized data engineering solutions for Big Data workloads to efficiently handle continuous increase in data volume and complexity.
• Build highly performing real-time data ingestion solutions for streaming workloads.
• Adhere to best practices and agreed upon design patterns across all Data Engineering solutions.
• Ensure the code is elegantly designed, efficiently coded and effectively tuned for performance.
• Focus on data quality and consistency, implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
• Create design (Data Flow Diagrams, Technical Design Specs, Source to Target Mapping documents) and test (unit/integration tests) documentation.
• Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
• Focus on end-to-end automation of data engineering pipelines and data validations (audit, balance controls) without any manual intervention.
• Focus on data security and privacy by implementing proper access controls, key management and encryption techniques.
• Take a proactive approach in learning new technologies, stay on top of tech trends, experimenting with new tools and technologies and educate other team members.
• Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
• Communicate clearly and effectively to technical and non-technical leadership.

Telecommuting is permitted up to 25%/week within normal commuting distance of Fox office in Los Angeles, CA.

Job Requirements

Requires a Bachelor's degree in Computer Science, Computer Engineering, Data Science, Mathematics, Statistics, Engineering or related field, plus five (5) years of progressive, post-baccalaureate data engineering experience or related experience in architecting, designing and building data engineering solutions and data platforms, including experience building data engineering pipelines using Python and PySpark; and building Lakehouse or batch/streaming data pipelines in Databricks.

Specific skills:

• Data warehousing on Snowflake;
• Data acquisition and transformation tools such as Fivetran and dbt;
• Real-time data stream processing using Apache Kafka, Kinesis, or Spark structured streaming;
• Distributed data processing frameworks such as Apache Hadoop, Apache Spark, or Flink;
• Automated workflow scheduling and orchestration tools such as Astronomer or Apache Airflow;
• Various AWS services including S3, EC2, EMR, Lambda, RDS, Redshift, and Glue Catalog

Any level of experience in the specific skills is acceptable.

Equal Opportunity Statement

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, disability, protected veteran status, or any other characteristic protected by law. We will consider for employment qualified applicants with criminal histories consistent with applicable law.

Pursuant to state and local pay disclosure requirements, the pay rate/range for this role, with final offer amount dependent on education, skills, experience, and location is $183,851.00-202,236.00 annually. This role is also eligible for various benefits, including medical/dental/vision, insurance, a 401(k) plan, paid time off, and other benefits in accordance with applicable plan documents. Benefits for Union represented employees will be in accordance with the applicable collective bargaining agreement.

• medical/dental/vision
• insurance
• a 401(k) plan
• paid time off
• and other benefits in accordance with applicable plan documents
• Benefits for Union represented employees will be in accordance with the applicable collective bargaining agreement

View more detail about FOX Benefits.

#LI-DNi