DATA INTEGRATION ARCHITECT

$140,000 - $160,000/Yr

Common Sense Media - San Francisco, CA

Full-time - Mid Level

Remote - San Francisco, CA

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

CommonSense is the leading nonprofit organization working on behalf of kids and teens to make the world healthier, safer, and more equitable. Backed by the research that's the foundation of everything we do, we champion quality media that entertains and inspires, and support legislation that aims to close the digital divide. We ensure that students and educators think critically about technology and become responsible digital citizens. We safeguard children's health and well-being by protecting their data privacy and shielding them from potential online harm. The Data Integration Architect will play the lead role in designing, developing, and implementing a comprehensive back-end data architecture that enables seamless integration and communication between numerous applications and systems. This position is fully remote, with a preference for candidates located in the San Francisco Bay Area. The Data Integration Architect will report to the Sr. Engineering Manager and will be responsible for spearheading an overhaul of the organization's current internal data architecture, ensuring it aligns with organizational goals and supports the efficient flow of data across systems. Key responsibilities include performing a comprehensive discovery on all systems that contribute relevant data to the organization, designing and implementing data integration solutions, developing a firm understanding of the systems that consume and distribute the organization's data, and enforcing data governance policies and procedures. The role also involves producing and presenting detailed arguments for both sides of the buy vs. build debate, creating and maintaining comprehensive documentation for all implemented systems, and advising about the adoption of additional data inputs and/or tools.

Responsibilities

• Spearhead an overhaul of the organization's current internal data architecture, ensuring it aligns with organizational goals and supports the efficient flow of data across systems.
• Perform a comprehensive discovery on all systems that contribute relevant data to the organization: content management system (CMS), CRM, payment platforms, website and app analytics, etc.
• Design and implement data integration solutions, including ETL processes, data pipelines, APIs, and data lakes/warehouses.
• Develop a firm understanding of the systems that consume and distribute the organization's data: APIs, newsletters, app messaging, BI tools, etc.
• Develop plans for a scalable, resilient transfer of data, and reliable data backups.
• Develop and implement data architecture strategies, standards, and best practices.
• Monitor and optimize the performance of data integration processes to ensure timely and reliable data availability.
• Collaborate with stakeholders across the organization to secure buy-in for intended solutions.
• Enforce data governance policies and procedures to ensure data accuracy and consistency, while appropriately weighing organization-specific concerns about security and data privacy.
• Produce and present detailed, organization-specific arguments for both sides of the buy vs. build debate.
• Create and maintain comprehensive documentation for all implemented systems. Review the documentation with relevant stakeholders to ensure needed redundancies.
• Be deeply involved in all vendor, outsourcing, and/or resourcing decisions that result from this work.
• Advise about the adoption of additional data inputs and/or tools, as well as the potential removal/replacement of existing tools.
• Stay current with emerging data architecture technologies and industry trends.

Requirements

• Bachelor's or master's degree in computer science, information technology, or a related field.
• 5+ years of proven experience developing data pipelines, warehouses, lakes, and architectures.
• Strong understanding of industry standards for enterprise integration patterns and best practices.
• Proficiency in SQL and one or more programming languages such as Python (preferred), Ruby, JavaScript, Go, etc.
• Excellent problem-solving skills and the ability to think critically.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
• Excellent documentation and technical writing skills.

Nice-to-haves

• Experience with any iPass or ESB solutions is a plus.
• CMS knowledge, especially Drupal.
• CRM experience, especially Salesforce.
• Experience with reliable internal APIs, especially as part of a mobile app back-end.
• Experience with cloud platforms like AWS, Azure, or Google Cloud.
• Knowledge of DevOps practices and CI/CD pipelines.
• Experience with enterprise service bus (ESB) technologies such as MuleSoft, Apache Camel, or IBM Integration Bus.
• Knowledge of payment gateways like Stripe.
• Experience with Agile and Scrum methodologies.
• Knowledge of real-time data streaming and processing technologies such as Apache Kafka, Apache Flink, or AWS Kinesis.
• Understanding of hybrid cloud integration and cloud-native application development.
• Ability to conduct performance tuning and optimization for middleware platforms.
• Experience with consolidated logging and monitoring tools such as ELK Stack, Splunk, or Prometheus.

Benefits

• The chance to work with talented, passionate professionals.
• A great health and welfare benefits package, including medical, dental, vision, and a matching 401(k).
• An organization that offers work/life balance.
• The opportunity to really make a difference in the lives of kids and families!