Data Modeling and Integration Lead

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 ha