Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Fortune Media (USA) Corporation in NYC is seeking a Senior Data Engineer to design, build and maintain production ELT pipelines that load data into our Amazon Redshift warehouse. You will integrate data from REST APIs, reports, and web portals to feed Looker analytics and support multiple Fortune teams.
You will lead data migrations, implement testing and monitoring, and optimize pipeline performance. The role requires 5+ years in data engineering, strong Python/SQL, and the ability to work 4
The role Fortune is hiring a Senior Data Engineer to build and run the ELT pipelines that load data into our Amazon Redshift warehouse. You'll bring in data from first- and third-party sources, build the analytics tables our teams report from, and lead projects for the advertising, subscription and memberships businesses. This role will report into the SVP of Product & Technology.
Design, build and maintain production ELT pipelines, primarily in Python, that ingest, clean and upsert data into Fortune\'s Redshift warehouse. Pull data from REST APIs, emailed reports, shared online documents, third-party web portals (via browser automation) and large hourly event streams (via AWS Glue). Own pipelines for key platforms including BigQuery, Google Ad Manager, Google Search Console, Apple News, LinkedIn, YouTube, Piano and affiliate marketing partners. Own data migrations between business systems similar to: moving data into Salesforce Sales Cloud and Cvent, and subscriber data from Piano into Recurly. This includes mapping, cleaning, deduplicating and validating records so they arrive accurate and usable. Design and maintain aggregated analytics tables and data models that power reporting in Looker. Add testing, monitoring and documentation so pipelines break less often and get fixed faster when they do. Optimize Redshift performance and cost (distribution and sort keys, workload management, query tuning). Work with business units (marketing, sales, product, editorial, finance and others) to understand what data they need and deliver it. Mentor other engineers and analysts through code reviews, design reviews and pairing.
5+ years of data engineering experience, including ownership of production pipelines. Strong Python and SQL. Hands-on experience with a cloud data warehouse, ideally Amazon Redshift (BigQuery or Snowflake also considered). Experience with AWS data services such as Glue, S3, Lambda and IAM. Experience pulling data from third-party sources: paginated and rate-limited APIs, file drops, emailed reports and web portals. Experience leading data migrations between business systems (e.g., CRM, event and subscription platforms), including data mapping, cleaning, deduplication and validation. Dimensional modeling experience, including building tables for Looker. Experience with workflow orchestration (e.g., Airflow) and version control (Git), CI/CD and code review. Able to explain technical work to people outside engineering. Ability to work from our NYC office 4 days per week.
Experience in digital media or publishing: audience, ad revenue, subscription or syndication data. Familiarity with Google Ad Manager, Search Console, Apple News, YouTube, LinkedIn or Piano data. Browser automation experience (e.g., Playwright or Selenium). dbt or similar transformation frameworks. Experience migrating or rebuilding legacy databases. Experience designing engagement or scoring metrics.
$155,000-$175, 000 base salary, plus eligibility for a discretionary variable annual bonus. This range is a good faith estimate and may ultimately vary based on a number of relevant factors.
NYC; 4 days in office.
A commitment to an open, inclusive, and diverse work culture.
At Fortune Media, our mission is to change the world by making business better. We achieve that by providing trusted information, great storytelling, rigorous benchmarking and world-class community building. And our key values are humility, ownership, and transparency.
The policy of Fortune Media is to provide equal employment opportunities to all applicants and employees without regard to race, color, caste, creed, religion, sex, sexual orientation, gender identity or expression, marital status, citizenship status, age, national origin, ancestry, disability, or any other characteristic protected by applicable law. Fortune Media affirmatively seeks to advance the principles of equal employment opportunity and values diversity and inclusion.
Fortune Media is a global media organization dedicated to helping its readers, viewers, and attendees succeed in business through unrivaled access and best-in-class storytelling. Fortune’s mission is to drive the conversation about business. With a global perspective, the guiding wisdom of history, and an unflinching eye to the future, we report and reveal the stories that matter today—and that will matter even more tomorrow. With the trusted power to convene and challenge those who are shaping industry, commerce and society around the world, Fortune lights the path for global leaders—and gives them the tools to make business better. Our values inform our mission. We believe that business can be a powerful platform for good, and we are committed to holding it to that standard.