ProPublica · 6 hours ago

Data Integrations Engineer

New York, NY

Full-time

Remote

Mid Level

$110K/yr - $130K/yr

3+ years exp

Maximize your interview chances

JournalismNews

Insider Connection @ProPublica

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

System integrationsData modelingRESTful APIsGraphQL APIsDatabase managementSQLNoSQLETL processesELT processesPythonNode.jsCI/CD pipelinesContainerizationDeployment automationSalesforceGoogle AnalyticsGoogle BigQueryParse.lySailthru

Required

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.