job summary: Looking for a data warehousing engineer for our entertianment/media client. Hyrbid Tues-Thursday. Contract with potential to hire full time. to build complex data engineering pipelines using Python and Airflow to hydrate datamarts in Snowflake and Data Lake in AWS Cloud. Qualifications: Minimum 7 years in data engineering/ data warehousingProficient: in Python, sourcing data from APIs, in SQL Experience working on Airflow, with AWS, with python, with Snowflake Datawarehouse Star and Snowflake Schema, SCDs, ETL (Informatica) location: Universal City, California job type: Contract salary: $60 - 69 per hour work hours: 9am to 6pm education: Bachelors responsibilities: Responsibilities: Build complex data engineering pipelines using Python and Airflow to hydrate datamarts in Snowflake and Data Lake in AWS Cloud.Quick thinking in troubleshooting production scale data pipelines and analytical thinking in identifying data issues.Integrate code with defined CI/CD framework and AWS services required for building secure data pipelines.Work in an agile software development team to complete backlog items, working in conjunction with other developers within NBCUniversal and other data engineers & architects.Test and create automated tests for your code, ensuring every function, service, and object is compatible with your team's work and with the many systems within the NBCUniversal system portfolio.Act alongside other senior data engineers, help formulate best practices and setting up toolsets and procedures for the team, leveraging internally available tools and communicating with other internal development & product teams.Stay up-to-date on new development and platform technologies, make recommendations for the right tool for the job, and take the lead in setting up those tools and training other developers on them.Communicate with business partners around NBCUniversal to understand the needs of the user, and implement those ideas in the code.Create documentation for developers as well as business users to help them understand your products.Maintain cloud-based platforms and environments of supported applications, troubleshooting and patching functional issues and data issues in lower or production environments when necessary.Perform other duties as assigned. Qualifications: Minimum 7 years of related experience in data engineeringstrong understanding of Datawarehousing conceptsProficient: in Python for building UDFs and pre-processing scriptsin sourcing data from APIs and cloud storage systemsin SQL with analytical thought process Experience working on Airflow orchestrationworking on any of the cloud platforms - AWS would be preferredwith CI/CD tools in a python tech stackworking on Snowflake Datawarehouse working in secured internal network environmentsworking in story and task-tracking tools for agile workflows Motivated and Self-Starting: able to think critically about problems, decipher user preferences versus hard requirements, and effectively use online and onsite resources to find an appropriate solution with little interventionPassionate about writing clear, maintainable code that will be used and modified by others, and able to use and modify other developers' work rather than recreate itBachelor's Degree in related field, preffered qualifications: Experience level: ExperiencedMinimum 7 years of experienceEducation: Bachelors skills: SQLSQLData WarehouseData AnalysisData Warehouse Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled. Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance. We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.