Level 3: Data Development

Combine local CSU data with campus data and develop data structures by combining pertinent datasets within the data spoke environments.

Skills You Might Need:

  • Familiarity with UT Data Hub structure, processes, and standards
  • Working experience of relational databases and concepts
  • Working experience of data transformation techniques
  • Working experience of data validation techniques
  • Working experience of data modeling techniques

Related Technology:

  • SQL
  • PL/PGSQL
  • Python, R
  • AWS technologies such as Glue, Lambda, etc.
  • Erwin Data Modeler
  • ETL tools such as DataStage, Informatica, etc.
  • Alation

Possible Staff Roles:

Some CSUs might consider ensuring they have the appropriate staff to support their goals and needs with regards to data. Here are some potential roles and positions your unit might consider:

  • Data Analyst
  • Data Developer
  • Data Modeler
  • ETL Engineer
  • QA Engineer
  • Software Developer/Analyst
  • Software Engineer

General Essential Training:

  • Advanced SQL
  • PostgreSQL development
  • Data Modeling techniques
  • AWS Foundational training
  • AWS Developer training

UT Specific Training:

  • Orientation to the UT Data Hub (currently in development)
  • Basic training in Alation (currently in development)