Sr. Data Engineer

Every great story has a new beginning, and yours starts here.Welcome to Warner Bros. Discovery… the stuff dreams are made of.Who We Are… When we say, "the stuff dreams are made of," we're not just referring to the world of wizards, dragons and superheroes, or even to the wonders of Planet Earth. Behind WBD's vast portfolio of iconic content and beloved brands, are the storytellers bringing our characters to life, the creators bringing them to your living rooms and the dreamers creating what's next…From brilliant creatives, to technology trailblazers, across the globe, WBD offers career defining opportunities, thoughtfully curated benefits, and the tools to explore and grow into your best selves. Here you are supported, here you are celebrated, here you can thrive.Your New Role:This role will work with a fast-paced team to create the data technology stack that can be used to deliver end-user insights used for developing the next generation of digital products and product strategies. You'll also help build out an internal data pipeline and develop ways to optimize data technologies to shape our digital data strategy.Your Role Accountabilities:Gain an understanding of brand and enterprise data warehouse/reporting requirements that will inform the data architecture and modeling approach. Employ these learnings to construct appropriate ETL/ELT processes, database queries, and data/permission models that support data aggregation and reporting on actionable insights.Passion to write code, which is efficient, organized, simple, scalable & reusablemeeting business requirements.Enthusiasm to learn and finding opportunity to enhance and adopt in the daily engineering activities is highly desired.Deliver end-to-end JIRA User stories meeting quality expectations of the team.Collaborate closely with internal and matrixed departments, including but not limited to Operations, Technology, PMO, Product Teams and Data Strategy/Insights to design, build, test, and deploy data warehouse solutions and reporting tools.Gain an understanding of multiple datasets to be able to perform ad-hoc analysis for different business units.Prepare effort estimation including researching and estimating costs of software development, unit testing. May provide estimates for upgrades of vendor packages upgrades and integration with existing systems.Participate in QA testing for data pipeline projects as well as implementation changes to the suite of analytical tools.Write reproducible data analysis over Peta bytes of data using cutting edgetechnologies.Mentor junior team members.Flexibility to work in second shift.Qualifications & Experiences:9-12 years of experience in data engineeringBachelor's degree in computer science, information systems, or information technology.Experience with scripting languages: Python, Scala, AWS Glueetc.Experience in Conceptual/Logical/Physical Data Modelling & expertise in Relational and Dimensional Data ModellingAdvanced SQL knowledge & performance tuning & cost optimization of complex SQL'sStrong experience with MPP databases(Teradata & Snowflake)Experience with Snow pipe, tasks, streams, clustering, Time travel, Cache, data sharingExperience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.Experience building and optimizing 'big data' data pipelines, architectures, and data sets.Experience with AWS cloud services - Athena, Quick sight, Kinesis, Lambda, IAM PoliciesExperienced in software delivery through continuous integration & automated deployments (for example git, bitbucket, Jenkins, etc.)Strong Experience with data pipeline and workflow management tools e.g., Airflow, RedwoodExperience with Atlassian Suite (JIRA, Confluence)Experience using and creating APIs.Experience supporting and working with cross-functional teams in a dynamic environment.Champions the capabilities and benefits of analytical data assets. Partner effectively across departments and stakeholdersMust be comfortable working in a Linux/Unix environment.Experience with ASW Analytics services like AWS Data Exchange, Data Pipeline, AWS Glue Data Brew, AWS Glue, AWS Lake FormationFamiliarity with ASW Developer tools services like CodeDeploy, CodePipelineExperience with public/private API integration, web scrapping, data streaming architectureKnowledge on Business content interchange (BCI).Not Required but preferred experience:Public speaking and presentation skills.Experience with data science tools such as NumPy, Pandas, R,MATLABetc.Experience with data processing engines like sparkExperience with DBT.How We Get Things Done…This last bit is probably the most important! Here at WBD, our guiding principles are the core values by which we operate and are central to how we get things done. You can find them at www.wbd.com/guiding-principles/ along with some insights from the team on what they mean and how they show up in their day to day. We hope they resonate with you and look forward to discussing them during your interview.The Legal Bits…Warner Bros. Discovery embraces the opportunity to build a workforce that reflects the diversity of our society and the world around us. Being an equal opportunity employer means that we take seriously our responsibility to consider qualified candidates on the basis of merit, regardless of sex, gender identity, ethnicity, age, sexual orientation, religion or belief, marital status, pregnancy, parenthood, disability or any other category protected by law.If you're a qualified candidate and you require adjustments or accommodations to search for a job opening or apply for a position, please contact us at recruitadmin@wbd.com.

#J-18808-Ljbffr IT & Technology