Originally founded in 1991 as Harlem RBI, DREAM has grown to annually serve more than 2,500 youth across East Harlem and the South Bronx through a network of seven PreK-12, extended-day, extended-year DREAM Charter Schools and community sports-based youth development programs. Through our commitment to rigorous academics, social-emotional learning, deep family and community engagement, and health and wellness, we create lifelong learners who are equipped to fulfill their vision of success in and out of the classroom. We dream big, as well, with an aggressive five-year plan to expand to serve 3,500 students across seven schools—growing our organization’s impact and leveling the playing field for all children. To learn more, visit wearedream.org.

DREAM is seeking a solution-oriented individual to serve as a Database Associate. Reporting to the Director of Database Management, the Database Associate will work on the database and data pipeline management of systems across the organization. The Database Associate will play a key role in building our business intelligence tools to support the Network Support Team's business needs.

Responsibilities

Data Pipeline and Dashboards
Work with various databases in the organization, supporting system management such as user permissions, access control, and web services access required for pipeline management in Fivetran;
Assist in pair coding and debugging of our data pipelines into our data warehouse in BigQuery, including pipeline troubleshooting (FundEZ, Dayforce, Lever, Salesforce, etc.) and SQL coding in BigQuery;
Support in building dashboards (including Organizational Excellence Dashboards and Team Dashboards for Advancement, Finance, IT, Talent, and HR, among others) and recommending insights for different stakeholders across the Network teams;
Maintain and integrate organizational data and collaborate with the NEST departments on Org Excellence dashboards
Create new business intelligence tools with multiple sources of data based on the user and business needs.
Database Management
Support with database solutions as needed across different database systems, including but not limited to Salesforce, Dayforce, Happyfox;
Assist the Director of Database Management with upgrading and maintaining the configuration of multiple databases;
Assist in change requests, as well as test and research the implications of new features.

Qualifications

Bachelor’s degree, required;
One year of experience in database management, required;
Strong database management skills and experience with the data pipelining (Extract, Transform, and Load) process, strongly preferred;
Experience with SQL (preferably and Python), strongly preferred;
Demonstrate interest in and passion for databases and data;
Excellent problem-solving and troubleshooting skills;
Ability to work on multiple requests from different stakeholders while maintaining a high degree of customer service and execution.

Working Expectations

The Database Associate is part of the IT Team, which currently works 3 days in the office and up to 2 days remote, per week (subject to change).

Benefits and Paid Time Off

We offer comprehensive benefits including:
Flexible Medical Health Plans, subsidizing the majority of costs for the employee, their spouse/domestic partner and children;
The ability to select between a variety of medical plans according to what best suits the employee’s needs;
Dental and vision plans;
Disability benefits;
Life insurance;
Up to 12 weeks fully paid of Parental Leave;
Flexible spending account options;
Pre-tax commuter benefits (parking and transit);
Fitness and entertainment discounts;
A variety of support through our employee assistance program (EAP);
A 403(b) retirement plan with employer matching up to 4% after one year of employment
Referral bonuses;
All full-time Network Support Team employees are eligible for approximately 48 days off throughout the year including holidays, sick days, personal days and summer Fridays.
Benefits are subject to change.

Compensation

DREAM offers a competitive salary commensurate with relevant experience with the potential for an annual performance-based increase. The incoming salary range for this position is $45,000 to $50,000 per year. New hires are typically brought into the organization at a salary closer to the start of the range depending on qualifications, internal equity, and the budgeted amount for the role. All staff are eligible for annual performance-based increases. Because we value staff tenure in each role, we do not currently cap salary ranges.