Welcome to the Cook County Assessor's Office (CCAO) Data Department! We're excited to have you! This webpage is a GitHub issue. An issue is a way to track work that needs to be done. This particular issue outlines the tasks you need to complete to onboard with the Data Department. Once you complete each task, please mark the checkbox as shown below:
[x] This task is complete.
If a task does not apply to you, please mark it anyways so we can track the progress of this issue. If you have a question at any point, please feel free to comment on this issue ticket and tag the core team using @ccao-data/core-team.
GitHub
Nearly all of the Data Department's work is tracked using GitHub. In order to participate in this issue and contribute to the Department, you will need a GitHub account.
[x] Create a GitHub account. If you do not already have one, create a free GitHub account using your personal email address.
[x] Log in to GitHub and comment on this issue ticket to let us know your username.
[x] Ask a core team member to add you to the relevant team.
Please note that your GitHub account can persist after your employment/internship has ended and can be a valuable resource in your career. Your work will mostly be public, so please take a moment to review GitHub's community guidelines.
You may also want to explore GitHub to familiarize yourself with the platform. The main CCAO GitHub group can be found here.
Before Your First Day
There are a number of administrative tasks you need to complete before you start working with the Data Department. These will typically occur before your first day.
HR Paperwork
Official onboarding paperwork is handled by the CCAO's Human Resources Department. They will reach out to you directly before you start to provide paperwork and guidance. If you have questions or have not received any paperwork, email HR.
[x] Complete any HR onboarding paperwork (I-9, employee info, etc.) and return it to HR.
Email
When you work in the public sector in Illinois your work correspondence is considered an official record. It is important that you do not use your personal email account, Dropbox, Google Drive, or any other personal digital accounts or systems to do your work. All CCAO work should be done using CCAO provided emails and file storage locations.
HR/IT will provide login credentials for your CCAO email account. This is your main account at the CCAO. It is used to access email, Teams, and all Microsoft products.
[x] Login to your CCAO email.
VPN
If you plan to work remotely, you will need to use the county VPN to access internal files and servers. You should receive an email from Admins or NCC (at your County email address) with instructions on how to setup and use the VPN. You will receive a second, separate email to enroll in Duo, which provides multi-factor authentication. For VPN troubleshooting, email the CCAO Admins. For more information on the VPN, see the Data Department wiki.
[x] Complete the Cook County VPN Access Form (which you will receive via email) and email it to the CCAO's Admins. You must use your CCAO email address when completing this form.
[x] Install the Cook County VPN client on your computer and successfully connect (test by visiting the CCAO intranet).
ID Card
Interns and staff need to obtain a County employee ID badge and activate it. The badge grants access to the 9th floor via elevator. To obtain an ID badge, perform the following steps after the you've been added to the payroll system:
[x] Go to the Cook County Bureau of Human Resources, on the 8th floor in room 834 of the County building. The HR office is open Monday-Thursday, 9am-2pm. Your photo will be taken and your card promptly printed.
[x] Email the CCAO's Manager of Payroll to inform them that you have your County employee ID.
[x] Fill out and return any paperwork provided by the Manager of Payroll.
Teams
Ask a member of @ccao-data/core-team for an invite to the Data Department "Team" within the CCAO group and the "General" chat within that Team.
[x] Send a Teams message to the Data Department "General" chat introducing yourself.
Federal W4
You'll need to complete/update a Federal W4 as part of the onboarding process with HR. This form must be filled out using Cook County's Employee Self Service (ESS) system. It usually takes about a week to receive access to this system once you are onboarded. If you've already completed this step, simply check the box and continue on.
Once you are given access to the ESS system, go to the intranet and select “New EBS Employee Self Service” on the right side of the page. You will be directed to an Oracle webportal, where you’ll open the CCG Employee Self Service folder and select 'Tax Form'. There, you can make any necessary updates to your Federal W4.
[x] Complete/update your Federal W4 in the Employee Self Service system.
Once your W4 is filled out, you can (optionally) enroll in direct deposit using the same system. If you don't enroll in direct deposit, then your paychecks will be mailed to the address you provided on your I-9.
Your First Week
Working Remotely
The CCAO Data Department is currently working on a hybrid schedule. We are in-office on Wednesday and Thursday and remote the rest of the week. Interns are encourage to spend at least one day per week in-office with the team.
Hardware and Software
You will be issued a CCAO laptop as part of your onboarding. This laptop has all the software you need pre-installed. When working remotely, you can take your CCAO laptop home OR use a personal machine. You will need to use the VPN to connect to CCAO resources while not in the office.
If using a personal machine, you will need to install the following tools for communication and accessing internal resources:
If you're not using a personal machine, or already have the necessary tools installed, please check the boxes above.
Server Setup
For actual coding and computation, the Data Department uses an on-premise server. The server can be accessed via SSH, RStudio, or JupyterLab as long as you are connected to the county VPN. To gain access to the server, you will need an account.
[x] Send a Teams message to Dan (@dfsnow) requesting an RStudio/server account.
Once your account is created, you can connect to the server via RStudio or JupyterLab.
You can use either RStudio's git integration or the command line (via SSH) to manage CCAO git repositories. If you are unfamiliar with git or RStudio's git integration, watch this webinar.
Additionally, the Data Department uses RStudio's projects feature to manage environments and switch between contexts.
[x] Clone a CCAO repository using RStudio's projects feature.
Issue Resolution
The CCAO Data Department roughly uses GitHub flow to manage its work. GitHub flow uses a basic branch-per-issue system. Each issue or new feature is tied to a branch and merge request. Work is done on the branch, then merged to master (or main) after testing and review. Here's an example of a typical workflow:
You are assigned Issue #118, Update Internal Contribution Guidelines within GitLab.
Check to see if there is a branch associated with your issue within GitLab. Branches created via issues usually have a similar name, in this case the branch name would be 118-update-internal-contribution-guidelines.
If a branch doesn't exist, then create one yourself. Each issue has an associated "Create Merge Request" button which will create a branch and merge request for that issue.
Checkout the issue branch.
Within RStudio, navigate to the git pane, then click the branch name in the upper right-hand corner (usually master). Select the branch associated with the issue you have been assigned. In this case, 118-update-internal-contribution-guidelines. You can also click different branch names to check them out.
The branch you selected should now appear in the upper right-hand corner of the git pane. You are now working within that branch.
Work the issue. Use the issue page comments to communicate with your supervisor about the issue.
Interns may work up to 20 hours per week and are encouraged to do so. Working 15 hours or less may limit the assignments you receive, as most of our departmental projects require a significant time investment. Intern schedules and certain events are tracked on a shared calendar (the Data Department calendar).
[x] Email your preferred schedule to Nicole and Dan. Include the days and times you will be working and the date of your last day. Subject: 'YOUR NAME - Internship Hours'
During the first week of employment, interns may need to manually record their hours by emailing HR. After the first week, interns will use the Cook County Time system to track their hours. Visit this page and click Dashboard Login to access CCT. We recommend that you create a recurring calendar event to remind you to clock in and out.
Data Department fellows do not need to submit time sheets to the CCAO. They are still accountable for their time, but are paid by their academic institutions.
Required Reading and Bookmarks
All new hires, interns, and fellows are required to read the following:
[x] Data Department Handbook - Outlines the purpose, procedures, and practices of the department
[x] Data Department Resources Page - Read everything marked with a :exclamation:. You can skip R for Data Science and Select Star SQL if you're already proficient in R/SQL.
[x] Data Department Glossary - The CCAO uses a lot of assessment- and office-specific jargon. Read through this glossary to get acquainted with some of the terms.
[x] Data Department Data Catalog - Architecture overview and database documentation for all Data Department assets. Read through the landing page and explore the data catalog a bit.
Additionally, take a moment to visit the internal org-level README and investigate the listed services. We highly recommend you use this page as your entrypoint to all work at the CCAO.
If you have downtime while working, we highly recommend reading anything marked with a :star: on the Resources page.
NOTE: Please report any broken links, spelling/grammar mistakes, or inaccurate instructions in this issue to @ccao-data/core-team.
Welcome to the Cook County Assessor's Office (CCAO) Data Department! We're excited to have you! This webpage is a GitHub issue. An issue is a way to track work that needs to be done. This particular issue outlines the tasks you need to complete to onboard with the Data Department. Once you complete each task, please mark the checkbox as shown below:
If a task does not apply to you, please mark it anyways so we can track the progress of this issue. If you have a question at any point, please feel free to comment on this issue ticket and tag the core team using @ccao-data/core-team.
GitHub
Nearly all of the Data Department's work is tracked using GitHub. In order to participate in this issue and contribute to the Department, you will need a GitHub account.
Please note that your GitHub account can persist after your employment/internship has ended and can be a valuable resource in your career. Your work will mostly be public, so please take a moment to review GitHub's community guidelines.
You may also want to explore GitHub to familiarize yourself with the platform. The main CCAO GitHub group can be found here.
Before Your First Day
There are a number of administrative tasks you need to complete before you start working with the Data Department. These will typically occur before your first day.
HR Paperwork
Official onboarding paperwork is handled by the CCAO's Human Resources Department. They will reach out to you directly before you start to provide paperwork and guidance. If you have questions or have not received any paperwork, email HR.
Email
When you work in the public sector in Illinois your work correspondence is considered an official record. It is important that you do not use your personal email account, Dropbox, Google Drive, or any other personal digital accounts or systems to do your work. All CCAO work should be done using CCAO provided emails and file storage locations.
HR/IT will provide login credentials for your CCAO email account. This is your main account at the CCAO. It is used to access email, Teams, and all Microsoft products.
VPN
If you plan to work remotely, you will need to use the county VPN to access internal files and servers. You should receive an email from Admins or NCC (at your County email address) with instructions on how to setup and use the VPN. You will receive a second, separate email to enroll in Duo, which provides multi-factor authentication. For VPN troubleshooting, email the CCAO Admins. For more information on the VPN, see the Data Department wiki.
ID Card
Interns and staff need to obtain a County employee ID badge and activate it. The badge grants access to the 9th floor via elevator. To obtain an ID badge, perform the following steps after the you've been added to the payroll system:
Teams
Ask a member of @ccao-data/core-team for an invite to the Data Department "Team" within the CCAO group and the "General" chat within that Team.
Federal W4
You'll need to complete/update a Federal W4 as part of the onboarding process with HR. This form must be filled out using Cook County's Employee Self Service (ESS) system. It usually takes about a week to receive access to this system once you are onboarded. If you've already completed this step, simply check the box and continue on.
Once you are given access to the ESS system, go to the intranet and select “New EBS Employee Self Service” on the right side of the page. You will be directed to an Oracle webportal, where you’ll open the CCG Employee Self Service folder and select 'Tax Form'. There, you can make any necessary updates to your Federal W4.
Once your W4 is filled out, you can (optionally) enroll in direct deposit using the same system. If you don't enroll in direct deposit, then your paychecks will be mailed to the address you provided on your I-9.
Your First Week
Working Remotely
The CCAO Data Department is currently working on a hybrid schedule. We are in-office on Wednesday and Thursday and remote the rest of the week. Interns are encourage to spend at least one day per week in-office with the team.
Hardware and Software
You will be issued a CCAO laptop as part of your onboarding. This laptop has all the software you need pre-installed. When working remotely, you can take your CCAO laptop home OR use a personal machine. You will need to use the VPN to connect to CCAO resources while not in the office.
If using a personal machine, you will need to install the following tools for communication and accessing internal resources:
If you're not using a personal machine, or already have the necessary tools installed, please check the boxes above.
Server Setup
For actual coding and computation, the Data Department uses an on-premise server. The server can be accessed via SSH, RStudio, or JupyterLab as long as you are connected to the county VPN. To gain access to the server, you will need an account.
Once your account is created, you can connect to the server via RStudio or JupyterLab.
Projects and Git
You can use either RStudio's git integration or the command line (via SSH) to manage CCAO git repositories. If you are unfamiliar with git or RStudio's git integration, watch this webinar.
Additionally, the Data Department uses RStudio's projects feature to manage environments and switch between contexts.
Issue Resolution
The CCAO Data Department roughly uses GitHub flow to manage its work. GitHub flow uses a basic branch-per-issue system. Each issue or new feature is tied to a branch and merge request. Work is done on the branch, then merged to
master
(ormain
) after testing and review. Here's an example of a typical workflow:118-update-internal-contribution-guidelines
.118-update-internal-contribution-guidelines
. You can also click different branch names to check them out.master
.See the Version Control and Workflow section of the handbook for more information.
Intern Hours, Projects, and Time Tracking
Interns may work up to 20 hours per week and are encouraged to do so. Working 15 hours or less may limit the assignments you receive, as most of our departmental projects require a significant time investment. Intern schedules and certain events are tracked on a shared calendar (the Data Department calendar).
During the first week of employment, interns may need to manually record their hours by emailing HR. After the first week, interns will use the Cook County Time system to track their hours. Visit this page and click Dashboard Login to access CCT. We recommend that you create a recurring calendar event to remind you to clock in and out.
Data Department fellows do not need to submit time sheets to the CCAO. They are still accountable for their time, but are paid by their academic institutions.
Required Reading and Bookmarks
All new hires, interns, and fellows are required to read the following:
Additionally, take a moment to visit the internal org-level README and investigate the listed services. We highly recommend you use this page as your entrypoint to all work at the CCAO.
If you have downtime while working, we highly recommend reading anything marked with a :star: on the Resources page.
NOTE: Please report any broken links, spelling/grammar mistakes, or inaccurate instructions in this issue to @ccao-data/core-team.