• Assist in building and maintaining data pipelines for ingestion, transformation, and storage • Support data cleaning, validation, and quality assurance processes • Contribute to data modeling and preparation for analytics and AI use cases • Partner with project teams on key client engagements, supporting data engineering workstreams and helping coordinate deliverables, timelines, and stakeholder communication • Work with modern cloud platforms and data tools

Who We Are: HelioCampus was founded with the purpose of helping college & university leaders navigate today’s growing pressures. As one of EdTech’s most steadily growing companies, our roots in higher ed ground us in the critical nature of this work. What We Do: We help our clients navigate today’s high stakes with data and Institutional Performance Management practices. Together with our clients, we chart a path to sustainability by borrowing practices from the most successful businesses. How We Do It: We approach our work with a “we’re on it” attitude that the higher ed community has come to know and expect from our team. We’re data geeks to our core, committed to simplifying the toughest challenges and operating with transparency. Our most successful team members are change agents who love a challenge. How You'll Help: As a Data Engineer II, you will be a key architect in building and maintaining our specialized higher education data warehouse. You will ensure that institutional data is reliable, high-performing, and delivered in a timely manner, directly enabling university leaders to make informed, strategic decisions. What You Will Do: - Develop: Design, build, and deploy robust ETL/ELT solutions using SQL and Python. - Test & Deploy: Perform comprehensive unit testing and participate in code reviews to ensure data integrity and system reliability. - Analyze: Monitor and evaluate pipeline performance trends to proactively prevent bottlenecks and system failures. - Troubleshoot: Diagnose and resolve complex ETL issues in real-time, identifying root causes to prevent recurrence. - Collaborate: Work closely with analysts and senior engineers to expand reporting models that meet evolving university goals. You Will Be a Good Fit For This Role If You Have: - Previous experience in the Higher Education or EdTech sector. - 3+ years of professional experience specifically in ETL/SQL development and data engineering. - Expertise in SQL: Strong proficiency in developing complex queries, analyzing data, and managing system integrations. - Data Architecture Knowledge: A solid understanding of data warehouse concepts, structures, and dimensional modeling. - Coding Proficiency: Experience with at least one object-oriented programming language (Python, Java, etc.). - An Analytical Mindset: The ability to think on your fly and approach technical challenges with a solution-oriented focus. - Autonomy: A drive to explore technical hurdles and find solutions with minimal supervision in a fast-paced environment. Nice To Have’s Include: - Experience with AWS tools (Redshift, S3, Glue) or other major Cloud Service Platforms. - Exposure to NoSQL data transformation approaches. - Proficiency in translating complex business requirements into technical SQL specifications. Projects You Will Work On: - Higher Ed Data Warehouse Expansion: Scaling our core warehouse to accommodate new data sources and institutional partners. - KPI Modeling: Refining and expanding reporting models to track student learning outcomes and financial sustainability. - Pipeline Modernization: Optimizing existing ETL processes to leverage modern cloud-native features for faster processing. Location: HelioCampus has two locations, Bethesda, MD and Chapel Hill, NC. This specific role is primarily remote, with occasional travel to an office or client site. Compensation and Benefits: HelioCampus offers employees a competitive salary along with paid time off, healthcare, vision, dental, 401(k) w/ company match, parental leave, remote work flexibility, home office perks, and a fun, collaborative work environment. What Sets Us Apart: 1. Commitment to Higher Education: We believe that serving higher ed makes the world a better place. This drives our desire to deliver high-quality products and services to help higher education institutions serve their students and communities. 2. Flexibility to Fit Your Life: HelioCampus employees enjoy the autonomy, freedom, and trust of a remote-first working environment. We embrace an “on it” mentality both in and out of the workplace, and employees are supported in pursuing personal and professional passions. 3. A Community of Bright Minds with Big Hearts: HelioCampus hires curious and talented practitioners who bring a diversity of thought and genuine care for one another and our clients to work every day. Our team members are more than a job description and are encouraged to show up as their full and authentic selves. What We Believe: HelioCampus is an equal opportunity employer, and all qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Disclaimer: The list of responsibilities described above is not comprehensive. Other tasks not mentioned here may be required. Changing business conditions may trigger changes to job responsibilities. This job description is not an employment contract. Physical Qualifications: This position requires the following physical qualifications to support a productive remote work environment. We are dedicated to providing reasonable accommodations for individuals with disabilities to perform the essential functions of this role. If you require accommodations, please discuss this during the application process. Vision: Sufficient visual acuity to read documents, view computer screens, and engage in tasks that require attention to detail. Hearing: Ability to communicate effectively in person (as applicable) and via phone or video conferencing, ensuring clear understanding of verbal instructions. Fine Motor Skills: Proficient use of hands for typing, using a mouse, and managing office equipment such as printers and scanners. Lifting: Occasional lifting of up to 10 pounds (e.g., office supplies or equipment).

About Us Lyrasis (www.lyrasis.org) is a 501 c 3 non-profit membership organization whose mission is to support enduring access to the world's shared academic, scientific and cultural heritage through leadership in open technologies, content services, digital solutions and collaboration with archives, libraries, museums and knowledge communities worldwide. Our Mission Statement is: Lyrasis empowers libraries, archives and museums through content services, open technologies and community-based solutions that expand access to information, preserve cultural heritage, and advance the shared goals of our members and the communities we serve. Collaboratively, we build a future that is inclusive, equitable, accessible and sustainable. Lyrasis organizational and staff values are: communication, respect, collaboration, impact, and service. Lyrasis was created by its members to help them tackle wide-reaching challenges with collective strengths. Lyrasis helps its members amplify their impact and influence. Summary Description: Do you have experience with open-source technologies and like helping users resolve their technical problems? Do you have experience with library technology and are excited to help libraries further their mission? Are you looking for a remote position? The Data Migration Specialist will extract, transform, and load client data from their legacy cultural heritage system(s) into Lyrasis-operated, open-source software platforms. Lyrasis- hosted platforms today include ArchivesSpace, CollectionSpace, and DSpace. The Data Migration Specialist will also create and maintain the tools used for such migrations. The ideal candidate will provide excellent technical support and customer service, effectively deal with stressful situations and meet firm deadlines. This individual must be able to work with other project managers and client stakeholders to define functional requirements, communicate complex issues effectively to all parties, work in a fast-paced environment on time sensitive projects, and possess a great attitude. Duties/Job Responsibilities: - Analyze prospective client data in order to determine the feasibility of and time estimate for a prospective migration project. - Manage migration projects for Lyrasis clients by producing project plans and timelines for clients, adhering to these deadlines, generating realistic expectations, and communicating clearly with clients and other stakeholders. - Analyze clients' legacy data/data models, and advise them on the best way to clean-up, manipulate and prepare their data for migration into Lyrasis ‐hosted platforms. - Collaborate with clients with creating data maps, including consulting on solutions for data fields that do not map directly and identifying data functionality tradeoffs in the target system for different mapping options. - Develop, maintain, and document migration tooling to facilitate the extraction, transformation and loading of legacy data that may also be re-purposed for other migration projects. - Perform special data manipulation and data cleanup projects on an as-needed basis. - Provide excellent technical support to Lyrasis hosting clients. Required Knowledge, Skills, and Abilities: - Knowledge of and experience with cultural heritage organizations' operations, workflows, data/metadata, and repository infrastructure. - Knowledge of current and emerging content and encoding standards for metadata, such as EAD, IIIF, MARCXML, MODS, METS, RDA, and SPECTRUM. - High comfort level with Unix/Linux, a shell prompt, scripting, PostgresSQL/SQL, or other relational databases, and wrangling data in XML, JSON, and CSV formats, and using APIs to retrieve and update data. - Familiarity with data ETL tools and techniques. - The ability to communicate effectively both orally and in writing. - Strong analytical skills. - Strong customer service focus. - Excellent time and project management skills; ability to estimate time effectively. - Ability to succeed in a team environment and in a remote organization with minimum direction. - A commitment to fostering a diverse and inclusive environment where differences and complexities in background, cultures, values, and viewpoints are valued. Strongly Preferred: - Experience operating or managing open-source collections management/repository systems, such as ArchivesSpace, CollectionSpace, DSpace, Fedora Commons, Islandora, or Samvera. - Experience in helping others use collections management/repository systems. - Experience creating, updating and maintaining documentation. - Experience creating and/or delivering training. - Experience writing or maintaining Ruby scripts or applications. NOTE: The Rails web development framework is only tangentially relevant to the work of the Data Migrations Team. - Experience using GitHub for version control and collaboration. Physical Demands: - This position is fully remote and requires sedentary work that primarily involves sitting/standing. Incumbent must be able to meet and communicate regularly via Zoom, Microsoft Teams, and/or other teleconferencing means. - While this position is 100% remote, it requires occasional travel to Lyrasis company events and in-person professional development, meetings and/or conferences. Applications Details: - Applications will be accepted through Monday, May 4, 2026. - Applications MUST include: Cover Letter and Resume - Applications without a Cover Letter will not be considered - Salary Range: $79,305 to $84,000 per year Lyrasis Background Check Requirement As part of our commitment to a safe and trusted environment, Lyrasis conducts criminal background checks on candidates who receive a conditional offer of employment. Offers are contingent upon satisfactory results. Lyrasis complies with all applicable federal, state, and local laws, including "ban the box" and fair chance hiring requirements, which may govern when and how criminal history information is considered in the hiring process. Background check results are evaluated in a manner consistent with these laws and our equal employment opportunity policy. At Lyrasis, one of our core values is to provide an inclusive environment to all who are employed here. Accordingly, the company is committed to providing fair and equitable employment opportunities to all applicants, without regard to race, color, religion, sex, national origin, age, disability or genetics. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

• Guide clients on optimizing their data environment for maximum efficiency. • Develop system engineering, integrations, and architectures based on client needs. • Implement and advise on data warehouse solutions, ETL pipelines, and BI reporting tools. • Develop data models to capture client's KPIs and data transformations; validate and test data models. • Teach technical data modeling concepts to various audiences, including developers and IT professionals. • Manage technical teams of up to 4-6 people, delegating work across engagements. • Assign staff with appropriate skill sets to projects in conjunction with the project manager. • Work within a project management framework to meet objectives and understand the impact of your work. • Collaborate with Sales and Marketing teams to develop Thought Leadership and support sales efforts.