Job no: 522035
Position type: Staff Full Time
Campus: UMass President's Office
Campus Location: Westborough
Department: UITS-Enterprise Data &Analytic
Categories: Information Technology
Advertised: Jan 12 2024 Eastern Standard Time
Applications close: Jan 19 2024 Eastern Standard Time
Job Summary:
The University IT Services (UITS) Enterprise Data and Analytics (EDA) team is responsible for developing and managing shared services in the area of data and analytics for the entire UMass university system. These include:
• Data services such as the Enterprise Data Warehouse, Data Lake, and related data integrations
• Reporting, visualizations, and analytics tools for self-service use of university personnel
• Data analysis and development services for various business lines including development of interactive dashboards and analytics
The Principal Data Engineer is a proven data architect with expertise in all aspects of dimensional data modeling, extract, transformation, and load (ETL), mapping technologies, and management of data platforms such as data lakes and data warehouses. They lead the data engineering team and provide oversight and mentorship for all engaged in data engineering. They are experienced in multiple data management technologies and support data analytics and data scientists in answering complex data driven business questions.
Essential Functions:
Responsibilities and duties include, but are not limited to:
• Supporting data analysts’ needs for structured and transformed data
• Gathering and translating data requirements into technical specifications
• Design and development of data structures to meet reporting and analytics needs
• Design, development, and optimization of data transformations and flows and their upkeep
• Solving complex data related problems
• Developing cloud and on-premise data flows
• Contribution to management of data and analytics platforms and operations, including monitoring and performance analysis
• Lead and mentor other data engineers and oversee their work
• Contribute to EDA’s overall strategy and roadmap
• Helps with setting long term data and analytics objectives and goals for the enterprise
Other Functions:
Additional responsibilities could include:
• Management of vendors
• Management of data and analytics platforms and operations
Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience):
• Bachelor’s Degree in MIS, Computer Science, Statistics, or business-related field
• 12+ years in business analysis or technical roles with the last 5 concentrating in data engineering
• Strong understanding of SQL and/or PLSQL, and performance tuning
• Specific experience developing data extracts, transformations, and loads
• Strong communications skills both written and oral
• Experience with multiple Data Integration tool on the level of Dell Boomi, DataStage, or Informatica
• Solid leadership and interpersonal skills, with ability to work well with people of all levels in both technical and business settings
Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience):
• Graduate degree in a STEM field with emphasis on data science
Working Conditions:
Office environment with a hybrid remote schedule and potential for small amounts of travel to specific UMass campuses
Additional Details:
Salary commensurate with experience up to $137,500
