Data Engineer

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) match, parental leave, remote work flexibility, home office perks, and a collaborative work environment. Equal Opportunity Employment 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 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). #J-18808-Ljbffr