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 Senior Data Engineer is a key contributor in the EDA team, providing expertise in modeling data structures and designing, building, and optimizing data mappings. They are experienced in multiple data management technologies and support data analytics and data scientists in answering complex data driven business questions.
Responsibilities
- 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
- Development of reports, visualizations, analytics and their delivery to end users
- Helps with setting long term data and analytics objectives and goals for the enterprise
- Data analysis in a specific data subject area(s) – i.e. student, finance, HR, etc.
- Development of metadata layer for reporting tools
- Development of advanced analytics content
Qualifications
- Bachelor’s Degree in MIS, Computer Science, Statistics, or business-related field
- 9+ 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 at least one Data Integration tool on the level of Dell Boomi, DataStage, or Informatica
- Solid interpersonal skills, with ability to work well with people of all levels in both technical and business settings
Benefits
- Salary commensurate with experience up to $125,000
Job no: 522169
Position type: Staff Full Time
Campus: UMass President's Office
Campus Location: Westborough
Department: UITS-Enterprise Data & Analytic
Categories: Information Technology
Advertised: Jan 23 2024 Eastern Standard Time
Applications close:
#J-18808-Ljbffr