Data Engineer, 2

Job Title

Data Engineer 2

Job Description

Hybrid 3x a week- NYC

In-office Expectations : This position is hybrid in-office with the ability to work remotely for up to 2 days per week.

About The Team The Team and / or Brand.

People Inc. is a leading digital media company that owns and operates a portfolio of highly respected brands across various brands including Allrecipes BHG MyRecipes Food & Wine and more. With a commitment to providing high-quality content and innovative digital experiences People Inc reaches millions of users globally and continues to drive growth and engagement across its platforms.

People Inc. is looking for a Data Engineer with strong Python and SQL skills to join the team. The successful candidate will help build our data integration pipelines that feed into our data lakes and warehouses while maintaining data quality and integrity in our data stores. We are looking for someone who collaborates effectively but can also work independently. This person will also work closely with key stakeholders and understand and implement business requirements and see to it that data deliverables are met.

The Roles Minimum Qualifications and Job Requirements :

Education :

Bachelors Degree preferred in a quantitative field such as computer science statistics mathematics engineering data science or equivalent experience.

Experience :

Build highly-consumable and cost-efficient data products that synthesize data from a variety of source systems.

Stage raw data and enrich it with business value so that downstream workflows can get consistent dimensions and metrics.

Ingest raw data with Fivetran and Python and surface in BigQuery for the company to use.

Design workflows that ensure reliable and consistent data creation. Repair and enhance them as needed in response to changing data or excessive costs.

Develop Looker Views and Models to democratize access to data products.

Partner closely with other developers on your scrum team with the support from many others across the organization.

Keep up with new technologies and approaches to solve problems and improve existing systems.

Work directly with Product QA front-end and our back-end developers in a dedicated scrum team to fully realize the product vision.

Participate in a well-oiled 2 week agile system to continuously add new features & functionality to the business.

Specific Knowledge Skills Certifications and Abilities :

A minimum of 5 years of experience in building and optimizing data pipelines with Python.

You have experience writing complex SQL queries to analyze data.

Window functions and nested subqueries are second nature to you.

You have commendable experience with at least one cloud service platform (GCP and AWS preferred).

Youve worked with data at scale using Apache Spark Beam or a similar framework.

Youre familiar with data streaming architectures using technologies like Pub / Sub and Apache Kafka.

Ideally youll also have a meticulous eye for design and rigorously check your own work for quality and precision even before QA and stakeholder review.

You are eager to learn about new tech stacks big data technologies data pipelining architectures etc. and propose your findings to the team to try and optimize our systems.

It is the policy of People Inc. to provide equal employment opportunity (EEO) to all persons regardless of age color national origin citizenship status physical or mental disability race religion creed gender sex sexual orientation gender identity and / or expression genetic information marital status status with regard to public assistance veteran status or any other characteristic protected by federal state or local addition the Company will provide reasonable accommodations for qualified individuals with disabilities. Accommodation requests can be made by emailing .

The Company participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program please click here : Range

Salary : New York : $130000 - $160000

The pay range above represents the anticipated low and high end of the pay range for this position and may change in the future. Actual pay may vary and may be above or below the range based on various factors including but not limited to work location experience and performance. The range listed is just one component of People Incs total compensation package for employees. Other compensation may include annual bonuses and short- and long-term incentives. In additionPeople Inc. provides to employees (and their eligible family members) a variety of benefits including medical dental vision prescription drug coverage unlimited paid time off (PTO) adoption or surrogate assistance donation matching tuition reimbursement basic life insurance basic accidental death & dismemberment supplemental life insurance supplemental accident insurance commuter benefits short term and long term disability health savings and flexible spending accounts family care benefits a generous 401K savings plan with a company match program 10-12 paid holidays annually and generous paid parental leave (birthing and non-birthing parents) all of which may vary depending on the specific nature of your employment with People Inc. and your work location. We also offer voluntary benefits such as pet insurance accident critical and hospital indemnity health insurance coverage life and disability insurance.

NMG#

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 130000 - 160000