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 forward.
Job Summary
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.
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 procedures
- 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 learning models
* 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 submit an application, including women, people of color, LGBTQ people, and people with special needs*
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
Other details
- Pay Type Salary
Apply Now
Top Skills
What We Do
Since 1829, The Philadelphia Inquirer has been “asking on behalf of the people” by providing essential journalism for the diverse communities of the Philadelphia region. The Inquirer, a for-profit public benefit corporation owned by the non-profit Lenfest Institute, produces Pulitzer Prize-winning journalism that changes lives and leads to lasting reforms. Its multiple brand platforms — including newspapers, Inquirer.com, e-Editions, apps, newsletters, and live events — reach a growing audience of more than 10 million people a month.
“In a free state, there should always be an inquirer asking on behalf of the people: Why? Why? Why?” — John Norvell, Inquirer co-founder
