Create offboarding.md

[tiffanychu90]

Description

Describe your changes and why you're making them. Please include the context, motivation, and relevant dependencies.

We've cycled through several offboarding of contractors and consultants and we should keep track of several updates we need to make to our repos.

Resolves #[issue]

Type of change

• [ ] Bug fix (non-breaking change which fixes an issue)
• [x] New feature
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] Documentation

How has this been tested?

Include commands/logs/screenshots as relevant.

Post-merge follow-ups

Document any actions that must be taken post-merge to deploy or otherwise implement the changes in this PR (for example, running a full refresh of some incremental model in dbt). If these actions will take more than a few hours after the merge or if they will be completed by someone other than the PR author, please create a dedicated follow-up issue and link it here to track resolution.

• [ ] No action required
• [x] Actions required (specified below) Do a pass and remove previous contractors and consultants from admin privileges and update references in data-infra that send notifications to closed email accounts.

[tiffanychu90]

Google IAM

Jarvus / Slalom / Contractors

• [ ] James Lott james.l@jarv.us - all permissions not used in last 90 days
• [x] Soren Spicknall soren.s@jarv.us - remove Owner
• [x] Ryon Coleman ryon@jarv.us - remove: Service Usage Consumer, Storage Admin, Storage Object Viewer
• [x] Kim Engie kim.engie@slalom.com
• [x] James Meadow james.meadow@slalom.com
• [x] alex.malana@slalom.com
• [x] alexandria.w@slalom.com
• [ ] easall@gmail.com -- downgrade?

Caltrans

• [x] Julian Hernandez julian@calitp.org
• [x] Samantha Lewis samantha@calitp.org

GitHub

cal-itp organization / warehouse-users / warehouse-contributors

• [ ] james-meadow (Slalom)
• [ ] ryon (Jarvus)
• [ ] lottspot (Jarvus)
• [ ] SorenSpicknall (Jarvus)
• [ ] SLewis1120 (Caltrans)
• [ ] julianofhernandez (Caltrans)

GitHub code references

• [ ] https://github.com/cal-itp/data-infra/blob/main/ci/pyproject.toml
• [ ] https://github.com/cal-itp/data-infra/blob/main/packages/calitp-data-infra/pyproject.toml
• [ ] https://github.com/cal-itp/data-infra/blob/main/packages/calitp-data-analysis/pyproject.toml
• [ ] https://github.com/cal-itp/data-infra/blob/main/apps/maps/pyproject.toml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/download_gtfs_schedule_v2/email_download_failures.py
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/parse_littlepay/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/sync_littlepay/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/deploy_dbt_docs/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/create_external_tables/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/transform_warehouse_full_refresh/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/publish_open_data/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/parse_and_validate_rt_v2/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/download_gtfs_schedule_v2/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/unzip_and_validate_gtfs_schedule_hourly/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/transform_warehouse/METADATA.yml
• [ ] https://github.com/cal-itp/data-infra/blob/main/airflow/dags/scrape_feed_aggregators/METADATA.yml

[tiffanychu90]

See comments

Added Airtable, @evansiroky. I'll open up another issue to follow-up with actual offboarding with Google and (hopefully) Github permissions with the template.