Data Integration Architect Job at Magnify Ventures, LLC, San Francisco, CA

U2JBQ2hpQUdjUG53VDg0d25jdUhvcVlHenc9PQ==
  • Magnify Ventures, LLC
  • San Francisco, CA

Job Description

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

  • 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.


Position 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.


Prefered Qualifications

  • 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.


Our 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!


Common Sense values the diversity of its employees and is an equal opportunity employer. For more information on our values, please visit our statement on

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. #J-18808-Ljbffr

Job Tags

Full time, Remote job,

Similar Jobs

Kelly Services, Inc.

SMT Operator Job at Kelly Services, Inc.

Kelly Services, Inc. - JobID: 40BC159F97FD400ABDB0A419A38BD090 [Heavy Equipment Operator / Loader Operator] As an Operator at Kelly Services, Inc., you'll: Operate equipment of various sizes and weights, safely and efficiently; Perform numerous functions associated with...

Thornton Tomasetti

Senior Engineer - Forensics Job at Thornton Tomasetti

 ...Thornton Tomasetti applies engineering and scientific principles to solve the world's challenges. An independent organization of creative...  ...full potential and cultivate a rewarding career. Our Forensic practice investigates problems in the built environment and provides... 

Jobot

Senior BAS/BMS Controls Specialist Job at Jobot

 ...specialist on our team, you will be responsible for conducting preventative maintenance, repair, installation, and commissioning of BAS/BMS controls. Responsibilities include performing start-up, checking, testing, system diagnostics, and commissioning from system-level... 

Brenau University

Nurse Practitioner Program Coordinator Job at Brenau University

 ...cart, rented vehicle or ones personal vehicle). Employees who travel must be at least 25 years of age, have a valid Georgia drivers...  ...Minimum Qualifications Have a minimum of a doctoral degree in nursing or related field Board Certified as an NP Management... 

El Centro Family Health

Dental Clinic Receptionist Job at El Centro Family Health

 ...Job Description Job Description RESPONSIBILITIES : The Dental Receptionist is responsible for projecting a positive first impression of the organization, by communicating effectively with coworkers and the general public, and greeting patients and other visitors...