Data Architect

Overview

We are looking for an insightful Data Architect to join our growing team of data and software engineers. The candidate will be responsible for visualizing and designing our organization’s enterprise data management framework, aligned with enterprise strategy and business architecture, guiding the team around establishing and expanding data pipeline architecture, as well as optimizing data flows and aggregation for cross functional teams. The ideal candidate is experienced in enterprise data architecture, master data management, and data modeling. We are looking for someone who enjoys both optimizing existing data systems and building them from the ground up.

The Data Architect will lead data initiatives like Master Data Management (MDM) and data warehousing to ensure optimal, strategic data performance. They must be self-directed and comfortable supporting the data needs of multiple business units, systems, and products. The right candidate will be excited by the prospect of building upon early-stage efforts around enterprise data architecture and the data engineering capabilities.

*This position is open to remote candidates.*

Your Responsibilities Include

• Translate business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses
• Define the data architecture framework, standards, and principles, including modeling, metadata, security, reference data such as finance codes and operational categories, and master data such as customers, vendors, and employees
• Define reference architecture, which is a pattern others can follow to create and improve data systems
• Define data flows, i.e., which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition
• Collaborate and coordinate with multiple departments, stakeholders, partners, and external vendors
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies.
• Keep our data separated and secure across all boundaries through multiple data centers and AWS regions.

Knowledge and Skills You Bring to the Organization

• Experience in data modeling and design, including advanced working SQL knowledge and experience working with relational databases, query authoring as well as working familiarly with a variety of databases
• Experience in system development life cycle, project management approaches, and requirements, design, and test techniques
• Experience with Social Media analytics, such as Facebook, YouTube, Instagram, etc.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Experience building processes supporting data transformation, data structures, metadata, dependency, and workload management
• A successful history of manipulating, processing, and extracting value from disconnected datasets
• Experience supporting and working with cross-functional teams in a dynamic environment
• 5+ years of experience as a Data Architect
• Candidates who have a degree in Computer Science, Statistics, Informatics, Information Systems, Database Analytics, or another related field, in addition to the years of experience, will be preferred.
• Experience using the following software/tools:
  • Experience with data tools: Snowflake (or other Data Warehouse software), AWS Glue, Fivetran, Hevo data or other ETL tools
  • Experience with Master Data Management tools and techniques
  • Experience with relational SQL and NoSQL databases
  • Experience with AWS cloud services: EC2, EMR, RDS, Athena, S3
  • Familiarization with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
  • Familiar with Customer Data Platforms (CDP) such as Segment, Insider, or Bloomreach

About Us

Stand Together helps social entrepreneurs supercharge their efforts to help people improve their lives. We connect them with passionate partners and the resources necessary to make a greater difference.

Through our philanthropic community, we tackle some of the nation’s biggest challenges so that every person has the opportunity to realize their extraordinary potential.

Stand Together partners with people from diverse perspectives and backgrounds-including people in education, business, community non-profits, and public policy-to accomplish more together than any of us could on our own.

Our Values

Working at Stand Together is different from many other organizations. We have a relentless commitment to a culture based on a business philosophy called Market Based Management ® (MBM ® ). Informed by the principles that allow a free and open society to flourish, MBM® prepares individuals to innovate, improve, and transform while fostering a healthy, growing organization that creates long-term value for its clients and supporters and fulfillment for its employees.

We believe that diversity in experiences, perspectives, knowledge and ideas fuels creativity, broadens knowledge, and helps drive success. That’s why we’re proud to be an equal opportunity employer and strive to treat all employees and applicants with honesty, dignity, respect and sensitivity. We welcome all qualified applicants regardless of color,race, religion, religious creed, sex, gender or gender identity, gender expression, sexual orientation, national origin, citizenship, ethnicity, ancestry, age, physical disability, mental disability, medical condition, pregnancy (including medical needs which may arise from pregnancy, childbirth, or related medical conditions), military and veteran status, genetic information, marital or familial status, political affiliation, or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances.

#PM19