Job Description:
Reporting to the Senior Director for Enterprise Technology Services, the Data Engineer will play a critical role in the development and operational support of the new data lakehouse (Snowflake). This position focuses on creating detailed data mappings, documenting data transformations, and developing robust data pipelines, ensuring both new development and production support are managed effectively.
Responsibilities:
-
Develop and maintain source to target mappings and document data transformations.
-
Build and support data pipelines for the institutional data lakehouse.
-
Address and resolve production support issues alongside new development tasks.
-
Collaborate with team members to improve and streamline data processes.
-
Contribute to the overall success of the data lakehouse through proactive development and maintenance efforts.
-
Adhere to shift-left principles for automated data pipeline testing and data quality engineering.
-
Ensure that data is accurate, timely and accessible to applications and people using the datamarts.
-
Translate agile user stories into technical specifications and actionable code.
-
Monitor data lakehouse performance and advise on any necessary infrastructure changes.
-
Assist and partner with technical and enrollment analytics teams to help and support datamart adoption and transition.
-
Liaise with ITS Systems and Network Services team to ensure cloud architecture and infrastructure needs are met for the data lakehouse.
Qualifications:
-
Proficiency in Python, SQL, SnapLogic, dbt, and Snowflake.
-
Experience in developing and maintaining data pipelines in a CI/CD framework with modern data tooling.
-
Strong analytical skills and attention to detail.
-
Bachelor’s degree in Computer Science, Engineering, or related technical field.
-
Experience with Tableau development preferred.
This document does not create an employment contract, implied or otherwise, other than an “at will” employment relationship.
Diversity, Equity, Inclusion & Equal Employment Opportunity at Berklee:
We support an inclusive workplace where everyone excels based on personal merit, qualifications, experience, ability, and job performance. Berklee affirms that inequality is detrimental to our faculty, staff, students, and the communities we serve. Our goal is to make lasting change through our actions. Berklee is committed to providing fair and equitable consideration of all employees and applicants without regard to race, color, religion, ancestry, age, national origin, place of birth, gender, sexual orientation, gender identity or expression, disability, genetic information, or status as a member of the armed forces or veteran of the armed forces, or any other category protected by federal, state, or local law.
As part of this commitment, Berklee will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact the Human Resources Team at [email protected] or call 617-747-2375.
Berklee is committed to increasing the diversity of our institution, community, and the curriculum. Candidates who can contribute to that goal are encouraged to apply and to identify their strengths in this area.
*Currently enrolled Berklee students are not permitted to apply for staff or faculty positions.*
Employee Type:Staff
Top Skills
What We Do
The world’s preeminent college for the study of music
