Data Integrations Engineer Save

ProPublica is hiring a data integrations engineer to lead work on the systems that power our publishing, audience and revenue data platforms. This important role serves to advance ProPublica’s mission — publishing web-first journalism with real-world impact — by crafting scalable, efficient solutions that provide greater understanding of our audiences and donors, which allow us to better serve their needs.

We’re looking for an engineer who believes in our mission and thrives in multifaceted roles, contributing both to the long-term product road map and to hands-on development. Your responsibilities will include shipping high-quality and resilient code, and working alongside designers, product managers, data analysts, engineers and agency partners. You’ll write code, configure no-code integrations, contribute to our documentation, mentor your peers and proactively solve problems.

As a member of our expanding, cross-functional product team, you’ll work closely with colleagues across ProPublica’s newsroom and business operations, ensuring that our data capabilities align and advance our organizational objectives. This position reports to our senior director of technology and will work closely with the audience data and insights analyst.

Responsibilities

• Collaborate on the strategy, planning and execution of data integration tools and features that support ProPublica’s journalistic, audience and revenue goals. Help us ensure we’re measuring what matters and using analytics to improve our operations.
• Lead development of scalable, secure systems for reliable data integrations.
• Implement data cleaning, validation and transformation practices to maintain high-quality, consistent data across integrated systems.
• Develop and maintain ETL/ELT pipelines to automate data flows, especially for platforms like Salesforce, Sailthru, Classy and Google Analytics integrated with Google BigQuery.
• Support the creation of systems to measure integration success and reliability over time, ensuring smooth recovery from system failures.
• Work with engineering leaders to uphold the data privacy of our readers and ensure our compliance with regulatory and legal requirements.
• Evaluate new products and features, troubleshoot issues and contribute to improvements that enhance the performance and reliability of integrations.
• Collaborate with stakeholders across ProPublica to understand their needs and translate them into actionable projects.
• Stay informed about tools and platforms that can improve our newsroom’s data integration capabilities.

Experience and Skills

The following skills are essential:

• Three-plus years of experience in system integrations, with a track record of implementing and maintaining scalable solutions.
• Experience designing and optimizing data models to support performance analytics and transactional SQL products, ensuring scalability and efficiency for diverse product and reporting needs.
• Proficiency with RESTful and GraphQL APIs, including creating and securing API integrations.
• Strong background in database management (SQL and NoSQL) and writing efficient queries for analysis and integration.
• Familiarity with ETL and ELT processes for maintaining clean, consistent data flows.
• Proficiency in at least one back-end programming language, such as Python or Node.js.
• Strong familiarity with modern CI/CD pipelines, containerization (e.g., Docker), and deployment-automation tools to ensure smooth and reliable deployment of integration services.
• Excellent problem-solving and troubleshooting skills, with experience in a highly collaborative team environment, supporting diverse stakeholders and adapting solutions to evolving business needs.
• Clear and effective verbal and written communication skills, with the ability to document technical processes and present complex integration workflows to both technical and nontechnical stakeholders.
• Ability to travel for occasional staff summits or other required events.

It’s also helpful if you have: 

• Experience with audience and reader data platforms, such as Salesforce, Google Analytics, Parse.ly, Sailthru or similar CRMs and analytics tools.
• Hands-on work with cloud-based data warehouses like Google BigQuery.
• Familiarity with newsroom workflows and a passion for journalism.

This job is full time and includes benefits. ProPublica is based in New York, but we’re open to remote candidates. We have offices in New York City; Washington, D.C.; Atlanta; Chicago; Austin, Texas; Phoenix; and Berkeley, California. Applicants must be eligible to work in the U.S.

The expected salary range for this position is $110,000 to $130,000.

This is a good-faith estimate of what we expect to pay for this position. The final salary figure will take into account a person’s experience, accomplishment and location. ProPublica is committed to paying its staff equitably, and these ranges should not be considered career salary limits or caps.