Data Warehouse Engineer

1 week ago

Amherst, United States UMass Amherst Full time

About UMass Amherst

UMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The University sits on nearly 1,450-acres in the scenic Pioneer Valley of Western Massachusetts and offers a rich cultural environment in a bucolic setting close to major urban centers. In addition, the University is part of the Five Colleges (including Amherst College, Hampshire College, Mount Holyoke College, and Smith College), which adds to the intellectual energy of the region.

Job Summary

The Data Engineer plays a critical role in developing, managing and optimizing the University's centralized data warehouse, which aggregates data from diverse systems and sources across the entire campus ecosystem. As part of a collaborative team, this individual will be responsible for ensuring the smooth operation and continual enhancement of the data warehouse infrastructure. This position ensures integration with the University's central analytics platform so that data can be used in real time for interactive dashboards that drive key initiatives for the university. This position requires a blend of technical expertise, problem-solving abilities, and a deep understanding of data systems to ensure seamless data availability for reporting, analysis, and live dashboards that support the university's strategic initiatives.

Essential Functions

  • Work with key stakeholders to define the data warehouse's core technical requirements, ensuring that it supports the long-term needs of the university while being flexible for future growth and additional data sources.
  • Ensure that the warehouse is scalable, capable of handling future data growth and the integration of new data sources.
  • Collaborate with senior engineers to design, build, and maintain data pipelines across a wide variety of programs and current and historical sources. Develop ETL processes. Develop data modeling and database design activities concurrent with the specific needs for stakeholders and projects Collaborate with business analysts, data scientists, and other teams across the university to understand their data needs and translate these into data models, ETL workflows, and reports.
  • Support day to day operations for the data warehouse. Monitor and optimize integration performance for data. Perform data quality checks and troubleshooting to ensure data accuracy.
  • Create comprehensive documentation detailing the data warehouse architecture, ETL processes, data flows, and technical decisions.
  • Stay current with emerging technologies and best practices in data engineering.
  • Follow best practices for data governance, ensuring compliance with university policies and data security standards.
  • Participate in data warehouse projects, work with the senior developers and business analyst(s) to develop project roadmaps.
  • Optimize warehouse performance and provide ongoing troubleshooting and support.

Other Functions

Performs other duties as assigned.

Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure)

  • Bachelor's degree in a related field with 5 years work experience supporting technical infrastructure, cloud orchestration or coding in a data driven business environment; a Master's degree may substitute for 2 year of required experience.
  • Strong working knowledge to utilize programming languages and relational databases.
  • Strong working knowledge of data warehousing concepts and tools, ETL tools, and documentation for large data sets.
  • Strong problem-solving skills and attention to detail.
  • Ability to work collaboratively in a team environment and communicate effectively.
  • Excellent analytical and organizational skills for discovery, consultation, and implementation of processes and projects.

Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure)

  • Experience working in a large and/or complex educational environment.
  • Experience with SQL and my SQL programming. Solid knowledge of programming languages such as Python, Java, or Scala.
  • Experience with cloud data warehouse solutions (e.g. Snowflake and Redshift)
  • Experience with data processing frameworks (e.g., Apache Spark, Hadoop).
  • Experience with cloud platforms (e.g., AWS, Google Cloud, Azure).
  • Knowledge of data visualization tools (e.g., Tableau, Power BI).
  • Familiarity with version control systems (e.g., Git).

Physical Demands/Working Conditions

Typical Office Environment Activity.

Work Schedule

Monday to Friday 9:00AM to 5:00PM

Salary Information

Level 27

PSU Hiring Ranges

Special Instructions to Applicants

Along with the application, please submit a resume and cover letter. References will be checked at the finalist stage, please be prepared to provide contact information for three (3) professional references.

UMass Amherst is committed to a policy of equal opportunity without regard to race, color, religion, caste, creed, sex, age, marital status, national origin, disability, political belief or affiliation, pregnancy and pregnancy-related condition(s), veteran status, sexual orientation, gender identity and expression, genetic information, natural and protective hairstyle and any other class of individuals protected from discrimination in employment, admission to and participation in academic programs, activities, and services, and the selection of vendors who provide services or products to the University. To fulfill that policy, UMass Amherst is further committed to a program of affirmative action to eliminate or mitigate artificial barriers and to increase opportunities for the recruitment and advancement of qualified minorities, women, persons with disabilities, and covered veterans. It is the policy of UMass Amherst to comply with the applicable federal and state statutes, rules, and regulations concerning equal opportunity and affirmative action.

  • Data Warehouse Engineer

    1 week ago

    Amherst, United States University of Massachusetts Full time

    Data Warehouse Engineer Job no: 525982 Work type: Staff Full Time Campus: UMass Amherst Department: IT Engineering Pay Grade: 27 Categories: Professional Staff Union (PSU), Computer & Information Technology About UMass Amherst UMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of...

  • Warehouse Worker

    3 months ago

    Amherst, United States United Parcel Service Full time

    SHIFT YOUR FUTURE Warehouse Worker UPS Quick Apply Applying for this role online is quick and easy – and you could even schedule your first day of work within 20 minutes! The steps are simple: 1) Provide some basic information to start the application process. 2) Watch a short video to see what the job is like. 3) Complete our online...

  • Refrigeration Engineer

    1 week ago

    Amherst, United States UMass Amherst Full time

    About UMass AmherstUMass Amherst, the Commonwealth‘s flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The University sits on nearly 1,450-acres in the scenic Pioneer Valley of Western Massachusetts and offers a rich cultural environment in a bucolic setting close...

  • Heating and Refrigeration Systems Engineer Manager

    3 weeks ago

    Amherst, Massachusetts, United States UMass Amherst Full time

    About UMass AmherstAs a leading public research university, UMass Amherst offers a wide range of undergraduate, graduate, and professional degrees in a beautiful setting close to major urban centers.Job Summary:The Heating and Refrigeration Systems Engineer Manager will play a pivotal role in ensuring the reliability and efficiency of our organization's...

  • HVAC & Refrigeration Engineer Manager

    5 months ago

    Amherst, United States UMass Amherst Full time

    About UMass Amherst UMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The University sits on nearly 1,450-acres in the scenic Pioneer Valley of Western Massachusetts and offers a rich cultural environment in a bucolic setting close to...

  • HVAC & Refrigeration Engineer Manager

    1 hour ago

    Amherst, United States InsideHigherEd Full time

    Job no: 523259Work type: Staff Full TimeLocation: UMass AmherstDepartment: Building MaintenanceUnion: PSUCategories: Facilities/Grounds, Skilled Labor, PSU AAbout UMass AmherstUMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The...

  • Senior Desktop Support Engineer for IT Operations

    3 weeks ago

    Amherst, Massachusetts, United States University of Massachusetts Amherst Full time

    About the RoleAs a Senior Desktop Support Engineer in our IT Operations team at the University of Massachusetts Amherst, you will play a critical role in delivering exceptional technical support to our faculty, staff, and students. Your expertise will be instrumental in resolving complex desktop and software issues, ensuring the security of university-owned...

  • Structured Cable Design Engineer

    13 hours ago

    Amherst, United States UMASS Amherst Full time

    About UMass Amherst UMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The University sits on nearly 1,450-acres in the scenic Pioneer Valley of Western Massachusetts and offers a rich cultural environment in a bucolic setting close to...

  • Structured Cable Design Engineer

    2 weeks ago

    Amherst, United States InsideHigherEd Full time

    Job no: 525894Work type: Staff Full TimeLocation: UMass AmherstDepartment: Design & Construction MgmnUnion: PSUCategories: Technical, PSU AAbout UMass AmherstUMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The University sits on...

  • Senior Quality Assurance Specialist

    3 weeks ago

    Amherst, Massachusetts, United States Jobot Full time

    About the RoleThis is an exciting opportunity to join our dynamic team as a Senior Quality Assurance Specialist. As a key member of our Engineering department, you will play a vital role in ensuring the highest quality standards are met and maintained.Job SummaryWe are seeking an experienced Permanent Quality Engineer to develop and implement quality control...

  • Quality Assurance Specialist

    6 days ago

    Amherst, Massachusetts, United States Jobot Full time

    Job OverviewThis is an on-site full-time direct hire position. Salary and BenefitsThe salary for this role is estimated to be between $80,000 - $95,000 per year. Excellent pay and benefits are offered, including a competitive compensation package and opportunities for professional growth and development. Job DescriptionWe are currently seeking an experienced...

  • Senior Environmental Consultant and Business Development Manager

    2 weeks ago

    Amherst, Massachusetts, United States Ramboll US Corporation Full time

    About the RoleRamboll US Corporation seeks an experienced Senior Environmental Consultant and Business Development Manager to join our New England team. This is a unique opportunity to leverage your technical expertise in environmental consulting and business development skills to drive growth and deliver innovative solutions to clients.Job DescriptionWe are...

  • Customer Service Coordinator

    3 months ago

    Amherst, United States Entegee Full time

    Job DescriptionJob DescriptionSummary: Seeking a Customer Service Coordinator responsible for processing shipping paperwork, maintaining company files, and handling customer inquiries.Job Requirements:Proficient in MS ExcelData entry experience preferredGreat Plains experience preferredJob Responsibilities:Process daily shipping paperwork and billing, sales...

  • Senior Managing Consultant or Principal, LSP in Massachusetts

    2 weeks ago

    Amherst, United States Ramboll US Corporation Full time

    Company DescriptionFounded in Denmark, Ramboll is a foundation-owned people company. We have more than 18,000 experts working across our global operations in 35 countries with thousands of experts working across 70 offices in the Americas. Our experts are leaders in their fields, developing and delivering innovative solutions in diverse markets including...

  • Location Dispatch Coordinator

    3 weeks ago

    Amherst Junction, United States GrowMark Inc. Full time

    Insight FS is headquartered in Jefferson, Wisconsin with 23 branches across the state and upper peninsula of Michigan. Insight FS has 430+ employees (including seasonal workers) and approximately 50,000 customers. The cooperative does business in agronomy, agri-finance, precision agriculture, nutrient management, energy, feed, grain, and turf. Insight FS is...

  • Life Safety Service Rep, Electronic

    1 month ago

    Amherst, United States Johnson Controls Full time

    Build your best future with the Johnson Controls teamAs a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet.  Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries across...

  • Vice President of Finance

    1 month ago

    Amherst, United States InsideHigherEd Full time

    Sweet Briar is a liberal arts college for women with a long history of forging female leaders.  Sweet Briar College is repeatedly named by the US News and World Report as one of the most innovative liberal arts colleges in the nation. Sweet Briar College is financially stable and actively growing, attracting students who are drawn to it for its excellent...

  • Safety Officer

    3 weeks ago

    Amherst, United States UMass Amherst Full time

    About UMass AmherstUMass Amherst, the Commonwealth‘s flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees. The University sits on nearly 1,450-acres in the scenic Pioneer Valley of Western Massachusetts, and offers a rich cultural environment in a bucolic setting close...

  • Fire And Safety Officer

    2 months ago

    Amherst, United States InsideHigherEd Full time

    Job no: 524937Work type: Staff Full TimeLocation: UMass AmherstDepartment: Environmental Health & SafetyUnion: AFSCMECategories: Occupational & Environmental SafetyAbout UMass AmherstUMass Amherst, the Commonwealth's flagship campus, is a nationally ranked public research university offering a full range of undergraduate, graduate and professional degrees....

  • Location Dispatch Coordinator

    2 months ago

    Amherst Junction, United States GROWMARK, Inc. Full time

     Insight FS is headquartered in Jefferson, Wisconsin with 23 branches across the state and upper peninsula of Michigan. Insight FS has 430+ employees (including seasonal workers) and approximately 50,000 customers. The cooperative does business in agronomy, agri-finance, precision agriculture, nutrient management, energy, feed, grain, and turf....