Data Integration Architect
Common Sense Media
IT
San Francisco, CA, USA
Posted on Thursday, June 13, 2024
Job Details
Job Location
Remote - San Francisco, CA
Remote Type
Fully Remote
Position Type
Full Time
Salary Range
$140,000.00 - $160,000.00 Salary/year
Job Category
Engineering
Description
Common Sense 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.
Job Overview
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.
LOCATION: San Francisco Bay Area. Open to remote.
REPORTS TO: Sr. Engineering Manager
SALARY: $140,000 - $160,000.
STATUS: Full-time, exempt.
Key Responsibilities
Common Sense will consider for employment qualified applicants with arrest and conviction records. However, job offers are made on the condition that the applicant subsequently passes a criminal background check. If the background check indicates a prior criminal conviction, we will conduct an individualized assessment to determine whether the conviction should result in denial of employment. Pursuant to the San Francisco Fair Chance Ordinance, we will consider employment for qualified applicants with arrest and conviction records.
Job Location
Remote - San Francisco, CA
Remote Type
Fully Remote
Position Type
Full Time
Salary Range
$140,000.00 - $160,000.00 Salary/year
Job Category
Engineering
Description
Common Sense 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.
Job Overview
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.
LOCATION: San Francisco Bay Area. Open to remote.
REPORTS TO: Sr. Engineering Manager
SALARY: $140,000 - $160,000.
STATUS: Full-time, exempt.
Key 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.
- 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.
- 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.
- 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!
Common Sense will consider for employment qualified applicants with arrest and conviction records. However, job offers are made on the condition that the applicant subsequently passes a criminal background check. If the background check indicates a prior criminal conviction, we will conduct an individualized assessment to determine whether the conviction should result in denial of employment. Pursuant to the San Francisco Fair Chance Ordinance, we will consider employment for qualified applicants with arrest and conviction records.