Data Integrations Engineer

Summary

Join ProPublica, an independent, nonprofit newsroom, as a Data Integrations Engineer. Lead the development and maintenance of data integration systems supporting our publishing, audience, and revenue platforms. Collaborate with designers, product managers, data analysts, engineers, and agency partners to create scalable, efficient solutions. Contribute to the long-term product roadmap and hands-on development, ensuring data quality and compliance. Work closely with colleagues across ProPublica's newsroom and business operations. This role reports to the senior director of technology and involves close collaboration with the audience data and insights analyst. The position offers a full-time schedule with benefits and remote work options.

Requirements

• 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

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

Preferred Qualifications

• 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

Benefits

• This job is full time and includes benefits
• We’re open to remote candidates