Data Warehousing Specialist

OVERVIEW OF THE COMPANYFox 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 DESCRIPTIONJob 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. Specific duties include: 1) Collaborate with and across Agile teams to design and develop data engineering solutions. 2) Build distributed, low latency, reliable data pipelines ensuring high availability and timely delivery of data. 3) Design and develop highly optimized data engineering solutions for Big Data workloads to efficiently handle continuous increase in data volume and complexity. 4) Build highly performing real-time data ingestion solutions for streaming workloads. 5) Adhere to best practices and agreed upon design patterns across all Data Engineering solutions. 6) Ensure the code is elegantly designed, efficiently coded and effectively tuned for performance. 7) 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. 8) Create design (Data Flow Diagrams, Technical Design Specs, Source to Target Mapping documents) and test (unit/integration tests) documentation. 9) Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues. 10) Focus on end-to-end automation of data engineering pipelines and data validations (audit, balance controls) without any manual intervention. 11) Focus on data security and privacy by implementing proper access controls, key management and encryption techniques. 12) 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. 13) 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. 14) 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: Also requires experience in the following: 1) Data warehousing on Snowflake; 2) Data acquisition and transformation tools such as Fivetran and dbt; 3) Real-time data stream processing using Apache Kafka, Kinesis, or Spark structured streaming; 4) Distributed data processing frameworks such as Apache Hadoop, Apache Spark, or Flink; 5) Automated workflow scheduling and orchestration tools such as Astronomer or Apache Airflow; and 6) Various AWS services including S3, EC2, EMR, Lambda, RDS, Redshift, and Glue Catalog*Any level of experience in the specific skills is acceptable.Telecommuting is permitted up to 25%/week within normal commuting distance of Fox office in Los Angeles, CA.#LI-DNiWe 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.View more detail about FOX Benefits.SummaryLocation: Los Angeles, California, USAType: Full time