Principal Data Engineer

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

#J-18808-Ljbffr