Data Warehouse Engineer

4 weeks 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 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.

Advertised: Dec 13 2024 Eastern Standard Time
Applications close: Jan 02 2025 Eastern Standard Time

  • Data Warehouse Engineer

    4 weeks 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...

  • Engineering Quality Manager

    2 weeks ago

    Amherst, Massachusetts, United States Jobot Full time

    About the RoleWe are seeking a highly skilled Permanent Quality Engineer to join our team in the Engineering industry. The successful candidate will be responsible for ensuring quality standards are met and maintained, developing quality control systems, and identifying areas for improvement.The ideal candidate will have a strong background in process...

  • Product Quality Engineer

    2 weeks ago

    Amherst, Massachusetts, United States Jobot Full time

    Company OverviewJobot is a dynamic company committed to excellence and continuous improvement. We are currently seeking an experienced Permanent Quality Engineer to join our team in the Engineering industry.The successful candidate will be responsible for ensuring quality standards are met and maintained, developing quality control systems, and identifying...

  • Engineering Quality Manager

    2 weeks ago

    Amherst, Massachusetts, United States Jobot Full time

    Job SummaryWe are currently seeking an experienced Permanent Quality Engineer to join our dynamic team in the Engineering industry. The successful candidate will be responsible for ensuring quality standards are met and maintained, developing quality control systems, and identifying areas for improvement.About the CompanyThis is an on-site full-time direct...

  • Systems Engineer

    3 days ago

    Amherst, United States Omron Automation Full time

    Work at OMRON!Omron Robotics and Safety Technologies, Inc. (ORT) is a global leading provider of intelligent vision-guided robotics systems and services. We develop social needs driven solutions for the global automation market. Our robotics systems provide unmatched performance and economic value throughout the production lifecycle, enabling customers to...

  • Systems Engineer

    3 days ago

    Amherst, United States Omron Automation Full time

    Work at OMRON!Omron Robotics and Safety Technologies, Inc. (ORT) is a global leading provider of intelligent vision-guided robotics systems and services. We develop social needs driven solutions for the global automation market. Our robotics systems provide unmatched performance and economic value throughout the production lifecycle, enabling customers to...

  • Refrigeration Engineer

    4 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...

  • Heating and Refrigeration Systems Engineer Manager

    1 month 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

    3 weeks 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...

  • Business Administration Assistant

    2 weeks ago

    Amherst, Massachusetts, United States The Reserves Network Inc Full time

    We are seeking a talented Business Administration Assistant to join our team. In this role, you will be responsible for performing various administrative tasks to support the smooth operation of an office, including answering phone calls, managing files, greeting visitors, maintaining office supplies, handling mail, and performing basic data entry.">As a...

  • Administrative Support Professional

    2 weeks ago

    Amherst, Massachusetts, United States The Reserves Network Inc Full time

    We are seeking a highly organized and detail-oriented Administrative Support Professional to join our team. This role will be responsible for performing various administrative tasks to support the smooth operation of an office, including answering phone calls, managing files, greeting visitors, maintaining office supplies, handling mail, and performing basic...

  • Office Operations Coordinator

    2 weeks ago

    Amherst, Massachusetts, United States The Reserves Network Inc Full time

    We are seeking a skilled Office Operations Coordinator to join our team. In this role, you will be responsible for performing various administrative tasks to support the smooth operation of an office, including answering phone calls, managing files, greeting visitors, maintaining office supplies, handling mail, and performing basic data entry.">As an Office...

  • Structured Cable Design Engineer

    3 weeks 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

    4 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...

  • Technical Project Lead

    2 weeks ago

    Amherst, New Hampshire, United States Omron Automation Full time

    Technical Project Lead Job SummaryWe are looking for a Technical Project Lead to oversee the development and implementation of our robotics systems. The successful candidate will be responsible for managing project technical risk, identifying and assessing potential risks, proposing effective mitigation actions, and utilizing DFMEA, DOE, test data, etc. to...

  • Reliable HVAC and Refrigeration Expert

    3 weeks ago

    Amherst, Massachusetts, United States UMass Amherst Full time

    Job SummaryThe HVAC and Refrigeration Engineer Manager will lead a team of HVAC and refrigeration technicians and engineers, fostering a culture of innovation, collaboration, and continuous improvement. Key responsibilities include developing and executing strategies to align our HVAC and refrigeration systems with decarbonization and electrification...

  • Administrative Support Specialist

    2 weeks ago

    Amherst, Massachusetts, United States The Reserves Network Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Support Specialist to join our team. In this role, you will be responsible for providing administrative support to ensure the smooth operation of our office.Key ResponsibilitiesReceptionist Duties: Answering phone calls, directing calls to the appropriate person, taking...

  • Quality Assurance Expert

    2 weeks ago

    Amherst, Massachusetts, United States Jobot Full time

    About the RoleWe are seeking an experienced Permanent Quality Engineer to join our dynamic team in the Engineering industry. The successful candidate will be responsible for ensuring quality standards are met and maintained, developing quality control systems, and identifying areas for improvement.ResponsibilitiesDevelop and implement quality control systems...

  • Product Consistency Specialist

    2 weeks ago

    Amherst, Massachusetts, United States Jobot Full time

    About the OpportunityThis is an on-site full-time direct hire position that requires an individual with a strong background in quality assurance and a passion for driving excellence in the Engineering industry.ResponsibilitiesDevelop and implement quality control systems to ensure product consistency and efficiency.Conduct PFMEA (Process Failure Mode Effects...