Data Engineer, 2

Job Title

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 Role’s Minimum Qualifications and Job Requirements:

Education:

Bachelor's 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).

• You've worked with data at scale using Apache Spark, Beam or a similar framework.

• You're familiar with data streaming architectures using technologies like Pub/Sub and Apache Kafka.

• Ideally, you’ll 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 law. In addition, the Company will provide reasonable accommodations for qualified individuals with disabilities. Accommodation requests can be made by emailing [email protected].

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: https://www.e-verify.gov/employees

Pay Range

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 Inc's total compensation package for employees. Other compensation may include annual bonuses, and short- and long-term incentives. In addition, People 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.