Data Engineer II

Fortune MediaFortune Media
Data Engineer, Data Engineering
Job description
We are looking for a Data Engineer to join our growing, versatile Data Engineering team. This person will
be a key member of analytical projects and will contribute to data discovery, pipeline implementation, and
analytics modeling. This role requires a person with hands on technical experience who is comfortable
with delivering scalable solutions that meet (and exceed!) business needs and is comfortable working with
various tools and methodologies.
Responsibilities
Work closely with Data Engineering Lead to scope, document, and ingest data from structured
and unstructured sources into Fortune’s data warehouse.
Collaborate with BI & Analytics stakeholders to fully understand business and technical
requirements, and be able to communicate a clear path of work.
Design, develop, and deploy data models to meet BI & Analytics use cases.
Explore and structure web analytics data capture with our Product Analytics lead.
Identify opportunities for optimization with our existing pipelines and data warehouse
automations.
Document and provide support for existing implemented solutions.
Collaborate across the Data Engineering team to add value where necessary

Fortune Media

Data Engineer II

 Job description

We are looking for a Data Engineer II to join our growing, versatile Data Engineering team. This person will be a key member of analytical projects and will contribute to data discovery, pipeline implementation, and analytics modeling. This role requires a person with hands on technical experience who is comfortable with delivering scalable solutions that meet (and exceed!) business needs and is comfortable working with various tools and methodologies.

 Responsibilities

• Work closely with Data Engineering Lead to scope, document, and ingest data from structured and unstructured sources into Fortune’s data warehouse.
• Collaborate with BI & Analytics stakeholders to fully understand business and technical requirements, and be able to communicate a clear path of work.
• Design, develop, and deploy data models to meet BI & Analytics use cases.
• Explore and structure web analytics data capture with our Product Analytics lead.
• Identify opportunities for optimization with our existing pipelines and data warehouse automations.
• Document and provide support for existing implemented solutions.
• Collaborate across the Data Engineering team to add value where necessary

Requirements

2+ years relevant professional experience in a technical, data centric role (analyst, modeler, engineer). Preferably in digital media or publishing.

Technical Skills

• Experience with web analytics platforms (ex. Google Analytics, Amplitude) – Piano Analytics is a plus.
• Deep knowledge of SQL fundamentals – PostgreSQL and PLPGSQL are a plus.
• Proficiency in Python and ETL / data processing dependent libraries (think psycopg2, requests, pyspark / dask / pandas etc.).
• Experience in Data Modeling – taking raw data and surfacing as a usable data object by adding structure and implementing business logic.
• Experience with structuring ETL / ELTs and/or using ETL tools (ex. AWS Glue, DBT
• Experience with at least one of the major cloud platforms (ex. AWS, GCP) – we operate on an AWS stack
• Familiarity with OLTP databases
• Familiarity with Jira or other agile project management platforms
• Bonus – familiarity with NOSQL databases
• Bonus – familiarity with Shell / Bash scripting
• Bonus – familiarity with Google Tag Manager.

Soft Skills

• Experience in digesting business requirements and translating those needs into technical implementation.
• Communicating architecture and implemented solutions in understandable terms to non-technical partners.
• Agency – owning and delivering on your responsibilities.
• Coachability and willingness to learn.
• Team player and champion for collaboration.
• Transparent in communicating work.

Location: NYC (hybrid). Must be commutable to our office in Lower Manhattan

A few of Fortune’s perks and benefits:  

• 22 vacation days, 11 paid holidays and an honor-based sick leave policy 
• Health, dental, and vision coverage (90% paid for individuals and families), plus a high-deductible health plan option where Fortune contributes to a Health Savings Account (HSA) 
• 401(k) plan
• Generous parental leave 
• Dependent care/health care/commuter FSAs, and cell phone benefits