General Information
| Job Description | DATA SYS ANL 1 | Working Title | Junior Data Engineer |
|---|---|---|---|
| Job Code | 007197 | Grade | 20 |
| Department Name | Data Engineering Dept - D02044 | Department Head | Michael Kennedy |
| Supervisor | Sattanathan Ponnuswamy | Effective Date | 03/11/2024 |
Position(s) Directly Supervised
| Job Code | Title | FTE |
|---|
Generic Scope
| Entry-level professional with limited prior experience; learns to use professional concepts to resolve problems of limited scope and complexity; works on assignments that are initially routine in nature, requiring limited judgment and decision making. Employees at this level are expected to acquire the skills and knowledge to perform more advanced work following an agreed upon time in position, through defined training and development planning. |
Custom Scope
| Under supervision applies professional concepts, department/unit and campus/medical center/OP methodologies and procedures to resolve routine data/information management problems. Works on problems of limited scope to provide data/information management support. Follows standard practices and procedures in analyzing situations or data/information from which answers can be readily obtained. |
Department Custom Scope
| The Junior Data Engineer position is part of the the Information Technology Solutions' (ITS) Data and Analytics Team. Tasked with imperative responsibilities, this role encompasses meticulous data management processes, which include the establishment and sustainment of intricate data systems. Collaborating closely with senior data engineers and other integral members of the ITS team, the incumbent is responsible for designing and orchestrating data pipelines. These critical pipelines systematically extract information from comprehensive systems, such as the Student Information System, Financial System, and Human Resource System, and subsequently transform this data into structured, business-focused data models. These refined data structures are instrumental, serving as the underpinning for sophisticated reports and analytic frameworks that are essential for the university's strategic decision-making processes. In the course of executing their duties, the Junior Data Engineer must exhibit an unwavering commitment to continuous learning and adaptation. This involves a proactive approach in staying abreast of current information requirements, standards, and best practices, ensuring that the data systems they oversee remain cutting-edge and efficacious. |
Education & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
Experience Requirements
| Experience | Requirement |
|---|---|
| 0 - 1 years of related experience. | Required |
License Requirements
Certification Requirements
| Certification | Requirement |
|---|
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
| Performs basic data management responsibilities. | 25 |
| Researches information requirements and standards. | 25 |
| Prepares simple data models and schemas. Researches simple data alignment and conversion requirements and with assistance develops candidate data mappings for use in converting data from one schema to another. | 10 |
| Perform ETL (Extract, Transform, Load) processes to manage the data lifecycle effectively from raw data to actionable insights including being familiar with ETL tools such as DBT/GCP Dataform. | 10 |
| Responsible for designing and orchestrating data pipelines. | 10 |
| Query and work with API interfaces | 5 |
| Utilize data visualization tools and techniques to represent complex data in an understandable and meaningful format. | 5 |
| Monitoring and customer support: address day-to-day support issues and help customers to resolve their problems. | 5 |
| Stay abreast of current information requirements, standards, and best practices, ensure that the data systems remain cutting-edge and efficacious. | 5 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Demonstrated effective communication and interpersonal skills. | Required |
| Strong organizational skills. | Required |
| Demonstrated ability to work with others from diverse backgrounds. | Required |
| Self-motivated and works independently and as part of a team. | Required |
| Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. | Required |
| Understanding of data management operations and database administration, including data modeling, data definition, data conversion and management of content or unstructured information. | Required |
| Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems. | Required |
| Demonstrated problem-solving skills. Able to learn effectively and meet deadlines. | Required |
| Demonstrated service orientation skills. | Required |
| Knowledge of relevant rules and regulations. | Required |
| Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail. | Required |
| Familiarity with programming languages such as Python and SQL, essential for developing and managing data processes. | Required |
| Understanding of automation techniques and an ability to work in a command line environment. | Required |
| Familiarity with cloud computing platforms like Amazon AWS, Google Cloud, or Microsoft Azure to leverage scalable resources for data processing and storage. | Preferred |
| Exposure to big data frameworks like Hadoop or Spark, enabling the handling and analysis of large datasets. | Preferred |
| A commitment to keeping up with emerging data engineering trends, tools, and best practices. | Preferred |
| An understanding of data governance principles, including ensuring the accuracy, consistency, and security of stored data. | Preferred |
| Ability to effectively collaborate with other departments and stakeholders to gather requirements, understand data sources, and deliver on data-driven projects. | Preferred |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Must pass a background check. | Required |
| Occasional travel for university related business meetings, conferences and/or professional development. | Required |
| Travel Outside of Normal Business Hours | Required |
Other Special Requirements & Conditions
|
|
Level of Supervision Received
| Close Supervision |
Environment
Working Environment
| Remote (working from home) with occasional visits to campus as necessary. |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: Yes |