Principal Data Engineer

Who We Are:
Born out of higher education HelioCampus works with institutions throughout North America to optimize financial decisionmaking and assessment/accreditation processes and provide a more integrated approach to strategic planning and institutional effectiveness. HelioCampus is backed by professionals passionate about the impact of innovation on the mission of higher education.

What We Do:
HelioCampus helps colleges and universities measure and evaluate their effectiveness in fulfilling their mission by connecting investments with financial operational and student learning outcomes. We help our partners see the pathway to institutional sustainability.

How We Do It:
HelioCampus turns institutional data into a highly effective asset by combining powerful technology platforms with best practices from the field. Our solutions present data in ways that allow higher ed stakeholders to take informed actions and mitigate risk. We couple unmatched institutional expertise with proven data models insightful workflows and innovative software.

How Youll Help:

You will work on a combination of exciting new projects and initiatives while also working to improve and maintain HelioCampus existing solutions (using cloud technologies). You will become an integral part of a fastgrowing team of ETL BI developers and analysts dedicated to the success of higher education.

What You Will Do:

• Support the data engineering team business intelligence and analytics team with ETL and data warehouse development deployment and testing
• Responsible for supporting planning activities and supporting the onschedule delivery of various project deliverables
• Recommending and performing changes to enhance the data warehouse data cleansing and conversion processes
• Supports testing and validation of the new data conversion processes
• Provide development support and mentor junior developers
• Participate in production support cycles on a rotational basis with other peers
• Troubleshoot data discrepancy and missing data issues resulting from daily ETL loads

You Will Be a Good Fit For This Role If You Have:

• 7 years in ETL and related experience
• 4 years leading the design and development of complex solutions
• Experience with data mapping and the ability to design and develop ETL solutions

Nice To Haves Include:

• Strong understanding and handson experience with data warehouse concepts and structures
• Experience in developing complex SQL queries and analyzing data systems integration
• Experience with translation of requirements into data model specifications
• Experience in AWS cloud technologies or another similar platform
• Experience with Python or other scripting languages.

Location:
HelioCampus has three locations Bethesda MD Chapel Hill NC and Philadelphia PA. 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 remote work flexibility and a fun collaborative work environment.

What We Believe:
HelioCampus is an equal opportunity employer 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.