Philadelphia Inquirer · Philadelphia, PA
The Data Engineer will focus on modernizing, building out and maintaining our data technology infrastructure and processes. Processes include ETL tasks,
data modeling and manipulation, and building out data pipelines to power our applications and products. The role is a unique opportunity to create and shape the technology, methods and data related processes.
The Philadelphia Inquirer is a public benefit corporation owned by the nonprofit Lenfest Institute for Journalism. Together, we’re at the center of a critical
mission to create a lasting future for ambitious, engaging, and useful local journalism. We’re doing this, in part, by deepening our connection with the communities we serve. Our integrated digital and print platforms are the Philadelphia region’s largest media network. We’re passionate about building a sustainable model for indispensable local journalism, and we take pride in
finding diverse, dynamic, and talented individuals to help push our team
What You’ll Do
Develop and maintain database architecture.
Design and implement secure data pipelines to prepare, process,
ingest and organize data into data warehouses from disparate
on-premise and cloud data sources.
QA and troubleshoot performance of data pipelines and queries
accessing data warehouse
Clean, transform and model data to power our analytics and user facing products
Ensure proper data governance and privacy practices
Partner with Analytics team on buildout of advanced data products
Assist with automation and orchestration
Who We’re Looking For
Familiar with Python, Scala, and Java
Familiarity with Stitch ETL platform and the Singer.io framework
RDBMS database development using SQL queries and stored
Experience with Google Cloud Platform and AWS
Strong experience with database platforms (e.g. MySQL, SQLServer, MongoDB, etc.)
- Experience writing scripts to automate the provisioning and
- maintenance of systems in a distributed, virtualized infrastructure; Docker experience preferred
- Familiarity with managed cloud-based options for building machine
Other Things to Know
We know not everyone reading this will fit exactly what we’ve described.
We encourage everyone to apply who shares our passion for
indispensable journalism and our drive to create a sustainable
business model to support it. As an equal opportunity employer,
The Inquirer is committed to fostering a diverse and inclusive
culture, and we especially encourage members of underrepresented
communities to apply, including women, people of color,
LGBTQ people, and people with special needs.