Enterprise Data Architect

Uncommon Schools, Inc.; New York (NY); Remote; USD 127,000 - 160,000; Full time

Job summary

Join a dynamic nonprofit organization dedicated to transforming education in underserved communities. As a key player in the Information Technology and Data Management team, you'll lead the charge in designing and managing data systems that empower educators and enhance student outcomes. This role combines technical expertise with strategic vision, allowing you to innovate and implement data solutions that drive meaningful change. With a commitment to equity and excellence, you'll be part of a team that values collaboration and professional growth, making a lasting impact on the future of education.

Benefits

19 days of paid time off

3 weeks of paid Winter and Summer holidays

Comprehensive Health, Dental, and Vision insurance

403(b) retirement savings program + employer match

Paid leave of absence options

Mental health and counseling support

Wellness benefits

Pre-tax flexible spending accounts

Qualifications

• 7-9 years of experience in data architecture and management.
• 4+ years of experience with RDBMS and data warehouse solutions.

Responsibilities

• Gather requirements for data architecture from stakeholders.
• Implement tools and systems to support data technology goals.
• Ensure compliance and document data architecture.

Skills

RDBMS

Data Warehouse Solutions

SQL

API Integration

Git

R, Python, Java, C#, JavaScript

SDLC Methodology

Job description

• Hiring Start Time: Immediate Start (Home Office)
• HO Team: Information Technology and Data Management

Company Description

Uncommon Schools is a nonprofit network of high-performing public charter schools dedicated to providing an exceptional K-12 education in economically disadvantaged communities. Operating in Boston, Camden, New York City, Newark, and Rochester, we are committed to closing the college completion gap and preparing every student for college and beyond. Our students consistently exceed national benchmarks, reflecting our dedication to their success. We invest deeply in our educators, offering weekly coaching, feedback, and professional development to ensure excellence in teaching and leadership. Join us to work hard, do good, and make a lasting difference!

Job Description

Systems Vision and Design:

• Gather information/requirements from stakeholders across Uncommon to ensure data architecture is in service of the goals and objectives of the organization.
• Evaluate current data architecture and databases
• Set and champion the appropriate long-term vision for the data at Uncommon
• Code new data architecture, integrating existing databases Use ETL (extract, transform, load) best practices in the creation of databases

Systems Management:

• Research and discover new methods to store and make data accessible to stakeholders.
• Work closely with the D&IT leadership teams to address outstanding items and prioritize remediation
• Select and implement the appropriate tools, software, applications, and systems to support data technology goals. Establish, document and communicate integration services, capabilities, roadmap, policies and procedures to key stakeholders, including D&IT’s in-house developers
• Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture.
• Identify and develop opportunities for data reuse, migration, or retirement.

Governance and Documentation:

• Preserve a repository of all data architecture artifacts
• Ensure that data strategies and architectures are in regulatory compliance
• Develop and promote data management methodologies and standards.
• Document the data architecture and environment in order to maintain a current and accurate view of the larger data picture.

Subject Matter Expert:

• Ensure user adoption of new processes by creating training materials and providing mentorship, guidance, support and performance feedback to front-end users of our data systems
• Independently create detailed communication and change management plans for work streams including simple, creative ways to explain complex information for clear decision-making
• Act as point of escalation for issues with data systems; Provide Tier 3 support to all D&IT functions on integrations with the data warehouse or between applications
• Collaborate with project managers and business unit leaders for all projects involving enterprise data.

Data Management and Reporting:

• Partner with DevOps functions in their day-to-day operations (reporting, auditing, integration) to support processes related to data
• Create and implement solutions, standards and controls to ensure data accuracy and integrity in the current state and in anticipation of a new systems
• Support the maintenance and upkeep of our existing and upcoming technology tools and understand the integration between them to find efficiencies and solve issues related to transactional work
• Contract & Payment: Lead renewal and payment of contracts
• Manage Relationship: Establish relationships with vendors, act as liaison between vendor and Uncommon on any projects, and own school-level issues & difficult conversations.
• Partner concerns: Work with Director to handle vendor issues

Qualifications

Education Requirements:

Experience Requirements:

• 7-9years of directly related experience
  • 4+ years of experience working with an RDBMS
  • 4+ years of experience working with a data warehouse solution (Redshift, Snowflake, etc.)
  • 4+ years of SQL experience
  • 3+ years of experience using APIs for the purposes of integration between applications
  • 3+ years of experience with Git
  • Ability to code proficiently in at least one of the following languages (R, Python, Java, C#, or JavaScript)
  • Experience with SDLC methodology (preferred)
  • Previous experience with frequent, incremental code testing and deployment

Additional Information

Our people are what make us Uncommon. We offer competitive compensation and comprehensive benefits that support the personal health, wellness, and finances of our staff and their families. Our compensation philosophy values equity & fairness and attracting & retaining top talent.

Compensation

Compensation for this role is between $127,800-$159,700.

Starting pay is determined using various factors, including but not limited to relevant professional experience, education, certifications, and tenure with Uncommon Schools. If you meet all job description requirements, you will likely receive an offer of $143,700.

• 19 days of paid time off
• 3 weeks of paid Winter and Summer org-wide holidays
• Comprehensive Health, Dental, and Vision insurance plans
• 403(b) retirement savings program + employer match
• Paid leave of absence options (parental, medical, disability, etc.)
• Mental health and counseling support + wellness benefits
• Pre-tax flexible spending, dependent care, and health saving accounts

*A detailed list of all benefits is located HERE .

At Uncommon, we believe that a supportive and welcoming environment helps our students, staff, and community thrive. We are dedicated to building a team that brings a wide range of perspectives and experiences, reflective of the communities we serve---with over 70% of our staff identifying as people of color. Our organization values respect and open dialogue on important topics that shape our school culture.

As an equal opportunity employer, Uncommon provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. We also ensure that individuals with disabilities receive all privileges and benefits associated with employment and are provided reasonable accommodations for the interview process and to perform core job functions. If you would like to request an accommodation, please email [emailprotected] .