The Role
The Data Modeling and Integration Lead is responsible for shaping data management practices, building data models, integrating systems, and creating data products and dashboards to support organizational decision-making and impact.
Summary Generated by Built In
iMentor is seeking a Data Modeling and Integration Lead to play a pivotal role in shaping how the organization manages and uses data to drive impact. This role will be responsible for cleaning, transforming, and modeling data, ensuring that the information iMentor relies on is accurate, consistent, and ready to power decision-making. It will design and maintain data models across systems, troubleshoot and resolve issues, and manage and improve data pipelines and processes that allow teams to use data with confidence.
This role will also build the capacity to construct reusable data products, including efficient and effective PowerBI dashboards that help colleagues across iMentor make sense of complex data, uncover insights, and measure progress toward the organization’s mission. By bringing strong skills in preparing, validating, and translating data into actionable insights and tools, this role will expand the organization’s capacity to learn from and act on data.
Working at the intersection of the Organizational Learning & Impact Team (OLI, iMentor’s applied research and evaluation team) and the Product, Design, and Engineering Team (PDE), this role will serve as a bridge between research and technology. It will ensure that the data environment is well-integrated, scalable, and designed to meet both research and operational needs.
As a senior individual contributor reporting directly to the Managing Director of OLI, this role will influence the direction of iMentor’s data strategy, shape best practices for data management and security, and serve as a trusted advisor to colleagues on data use. This is an exciting opportunity for a technical expert who wants to apply their skills in service of mission-driven work, helping iMentor unlock the full potential of its data to improve outcomes for the students we serve.
Responsibilities:
Clear, transform, and model data
- Write and update queries using SQL and MongoDB to 1) Extract and transform data from raw data into usable data structures (tables, super tables, data models, visualizations) for analyses 2) Integrate data across tables and multiple systems, and 3) Compute new variables
- Build, maintain, and update tables and back-ups to support reporting
- Troubleshoot errors with data models and tables
- Recommend best practices and provide technical advice about data management (storage, security, privacy, cleaning, transforming)
- Ensure data accuracy
Liaison between OLI and Product teams
- Communicate and interface with PDE (Product, Design, and Engineering) team
- Describe OLI problems and collaborate on solutions
- Help to design and improve the overall systems environment and integration ecosystem
- Serve as a subject matter expert on key integrations, such as survey integration
- Consult on the development of processes for automating data imports from external data sources into the data warehouse
Create processes and documentation to ensure data quality
- Create processes and documentation to ensure data quality
- Design data models that maximize efficiencies and accuracy
- Create technical documentation for data sources, computations, status, updates, etc.
- Develop processes to identify and resolve data inconsistencies and errors, including those that reduce merging and human error in data entry
Create reusable data products
- Create reusable data products
- Build OLI team capacity in the construction of efficient and effective PowerBI dashboards
- Build dashboards in PowerBI to support sense-making across various teams within the organization
General support
- Provide other analytic support for iMentor’s Organizational Learning and Impact Team as needed
Qualifications
- 5+ years of experience creating reusable data products, and building and managing data integrations
- with relational databases and data warehouses. Preferably within an education, non-profit or public
- sector context. Or a Master’s degree with 3-4 years of such experience.
- Bachelor’s degree in computer science, data science, or mathematics OR equivalent training and
- certification.
- Expert proficiency with SQL and PowerBI. Proficiency with MongoDB, Python, and R a bonus.
- Advanced knowledge of data modeling techniques, data transformation tools, and relational
- databases. Experience building and troubleshooting APIs a bonus.
- Experience integrating and normalizing multiple data sources, managing identity resolution, and
- tracking data lineage.
- Excellent communication skills (written and verbal) and collaborative mindset.
- Strong attention to detail.
- Curiosity, initiative, and creative reasoning – including strong motivation to engage in self-directed
- learning to solve problems.
- Preference for candidates who have had experience building integrations in the context of smaller
- teams with limited resources.
Compensation and Benefits
- Salary $95,000 - $105,000 annually commensurate with experience.
- Up to 100% employer-funded comprehensive medical and dental coverage
- 18 paid days annual vacation (increasing annually to 21, 23, 25), 13 paid holidays + your birthday + one floating holiday, iMentor closed between Christmas and New Year’s Day, plus 6-7 sick days annually 401K match up to 4%
- Flexible Home/Office/School working arrangement
- Pre-tax commuter benefits
- Dependent care and health care flexible spending plans
- 1 hour of wellness time off per week for wellness activities of your choosing
- Flexible personnel wellness budget for reimbursements or marketplace purchases
- Every staff member is eligible for organization-sponsored professional development annually
- 9 weeks of paid parental leave
About iMentor
At iMentor, we believe in the transformative power of mentorship as a force for good. We partner with schools in communities in which a majority of students will be first-generation college students. iMentor matches every 11th and 12th grade student in our high schools with a committed mentor – offering each mentee, regardless of background or GPA, a champion for their success.
Mentors can provide students with a level of personalized support that cannot be achieved through traditional school counseling alone. Of the most recent graduating high school class, 81% of students learned about a new post-secondary pathway through iMentor and 93% were accepted into college and intend to enroll. Since 1999, iMentor has served more than 42,000 students and is poised to scale our model to make mentoring accessible across the country.
Our Commitment to Community, Educational Access, and Opportunity
Central to our mission is a dedication to creating an environment where all stakeholders, including students, mentors, and staff, feel valued and supported. We are committed to the ongoing effort and investment required to ensure that all students have access to the resources and support needed to succeed. Recognizing that historical and systemic challenges continue to impact educational outcomes, we focus on addressing economic and structural barriers that affect the communities we serve.
How to Apply
Visit www.imentor.org/jobs to submit a resume and detailed cover letter describing your interest in and qualifications for this position. Applications will be considered on a rolling basis, so we encourage you to apply as soon as possible.
iMentor is an Equal Opportunity Employer
Top Skills
MongoDB
Power BI
Python
R
SQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
iMentor builds mentoring relationships that empower students to graduate high school, succeed in college, and achieve their ambitions. Since 1999, iMentor has connected more than 30,000 students with mentors. In the next 5 years, iMentor will scale to serve even more mentor-mentee pairs. In New York City, Chicago, and the San Francisco Bay area, iMentor partners with public schools to ensure every student in the schools receives a mentor. Across the country, iMentor provides nonprofit partners the tools to run their own high-impact programs in the iMentor model. This includes a technology platform, a research-based curriculum, and program analysis tools.
iMentor has been recognized through funding by the Bill & Melinda Gates Foundation, the Lumina Foundation, the Michael & Susan Dell Foundation, and the Robin Hood Foundation, and is a subgrantee of the federal Social Innovation Fund. iMentor is one of the most innovative and quickly growing organizations of its kind in the country. As a team, we are mission-focused, results-oriented, passionate, and fun. And we’re proud to have been named one of the Best Nonprofits to Work For by Opportunity Knocks and The Nonprofit Times.
