TrueRoll (a GovTech Top 100 company) Onboarding Technician Chicago, IL · Full time

The Onboarding Technician supports TrueRoll’s software and data products by cleansing, normalizing, and standardizing data from clients

Description

Onboarding Technician


Direct Reports: None

Reports to: Solutions Architect

Travel: 0%; Full-time


The Onboarding Technician supports TrueRoll’s software and data products by cleansing, normalizing, and standardizing data from clients and loading it into the production database in accordance with the standards of the Parcel-Based Data Model. They are responsible for executing technically challenging programming and ETL tasks with the object of deriving the maximum amount of information out of sparse, disorganized, and otherwise messy data.


Responsibilities


  • Execute own work within an Agile Projectment Management framework
  • Write performative code in Python deploying TrueRoll’s custom ETL classes
  • Reconcile data sets with a standardized schema
  • Document and communicate data integrity issues with project team members
  • Use internal documentation,identify documentation gaps, and contribute to documentation at the direction of supervisors
  • Execute ETL processes and ensure data is transferred properly


Requirements 


  • 1 year experience programming in Python either as a primary job responsibility or as part of coursework
  • Ability to understand and manipulate relational data models
  • Ability to effectively communicate about data 
  • Ability to work remotely and asynchronously
  • Ability to adhere to TrueRoll’s company and engineering codes of conduct.


Preferred qualifications


  • Experience programming in structured query language
  • Experience working with large, non-standardized datasets
  • Experience with Python’s Pandas library
  • Experience working with data containing names and addresses



Salary

$55,000 - $70,000 per year