Originallyfounded in 1991as 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;
- Create new business 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, and Coupa;
- Assist the Director of Database Management with upgrading and maintaining the configuration of multiple databases;
- Assist in change requests, as well as test and analyze the implications of those requests.
Qualifications
- High School Diploma, required; Bachelor's degree, preferred;
- 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
- Roughly 20 hours per week
- 3 days of work a week
- In person work required 2 out of 3 days (Tuesday, Wednesday, or Thursday); remote possible 1 out of 3 days
- This role requires on-site work at both our East Harlem and Mott Haven Campuses
Compensation
- DREAM offers competitive compensation. The rate for this position is between $28 and $30 per hour.
Our Commitment to Diversity, Equity, and Inclusion At DREAM, diversity, equity, and inclusion are a matter of mission. From our schools to our playing fields, DREAM is committed to building a team where each individual can bring their full identity and experience to work because representation matters-it enriches our team culture, enhances our ability to innovate, and strengthens our impact in and out of the classroom. DREAM engages staff that represent and appreciate the diversity of our majority Black and Hispanic student body, while working to ensure that our practices are equitable, welcoming, and productive. We are dedicated to creating a world where youth, especially youth of color, have permission to dream-along with the tools and opportunities to make their dreams reality.
Come dream with us DREAM Maxims All Kids Can. This Kid Can. DREAM is Family. Fun is a Serious Value. Teamwork Makes the DREAM Work. Fail. Persist. Exceed. DREAM Big.
Applying to DREAM We know applying for a new job can be a daunting process. In addition, studies have shown that historically underrepresented individuals often only apply to roles if they meet 100% of the qualifications. We encourage all applications! You may be just the person we need. If you have any questions about your application or interview process, do not hesitate to ask your recruiter; we are here to help! DREAM provides reasonable accommodations for qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local laws. If accommodation is needed to participate in the job application or interview process, please contact your recruiter.