Job description
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
- 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. 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 the OLI team (research and analytics) and the PDE team (Product Design and Engineering) on issues of data modeling and integration
- Communicate and interface with PDE 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
- 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
- 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
- Provide other analytic support for iMentor’s Organizational Learning and Impact Team as needed
Requirements
- 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.
$95,000 - $105,000 a year
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
