DREAM is seeking a solutionoriented 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 Teams 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
Bachelors 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 problemsolving 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 employees needs;
Dental and vision plans;
Disability benefits;
Life insurance;
Up to 12 weeks fully paid of Parental Leave;
Flexible spending account options;
Pretax 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 fulltime 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 performancebased increase. The incoming salary range for this position is $45000 to $50000 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 performancebased increases. Because we value staff tenure in each role we do not currently cap salary ranges.
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 mattersit 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 dreamalong with the tools and opportunities to make their dreams reality.
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.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.