Data Engineer

At Fortune Media, we are reinventing how a storied brand, steeped in journalism and
business, adapts to today’s digital-first world. If the idea of helping to scale a 90-year-old
startup fascinates you, this is the right job for you. While Fortune is a storied brand in
business journalism, we are a small and lean organization. This is a unique opportunity to
make your mark on the media industry.

Job description

We are looking for a Data Engineer to join our growing and solutions driven Data
Engineering team. This person will be a core member of BI & Analytics projects and will
contribute to data discovery, warehouse automation, and analytics modeling.
The team is currently in the process of building out a new Redshift data warehouse and
analytics model, and the solutions you implement will have a direct impact on business
strategy. We want to develop data sets to answer questions like “what areas of marketing
attribution lead to increased user conversion?” or “how can we improve editorial
effectiveness?”.
We are a tight knit group, so you will exceed if you value collaboration and are hungry to
learn.

What you will do

• Report to our Data Engineering Lead where you will 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

Our Data Stack

Data Lake – AWS S3
Warehouse – AWS Redshift, AWS Aurora
ETL tooling – Python, AWS Glue
BI & Analytics Model – LookML
Visualization – Looker

Who we are looking for

2+ years of 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.
• Proficiency in Python and experience with building ETLs and/or using ETL tools (ex.
  AWS Glue, DBT).
• Experience with data modeling and business logic design.
• Experience with at least one of the major cloud platforms (ex. AWS, GCP)
• Familiarity with OLTP databases.
• Familiarity with Jira or other agile project management platforms.
• Familiarity with a visualization tool (ex. Looker, Tableau).
• Bonus – familiarity with Shell / Bash scripting.

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.