Rewrite salary intro, add Department column to table and CSV

2 files changed, 37 insertions, 55 deletions

diff --git a/content/salary/index.org b/content/salary/index.org
index 43d5044..046605b 100644
--- a/content/salary/index.org
+++ b/content/salary/index.org
@@ -1,64 +1,46 @@
 #+title: salary
 #+slug: index
+#+options: toc:nil
 
 ** Salary Transparency
 
-The data below details the base salary information for each job I've held. I
-have posted this information publicly to ensure others in my position have a
-solid reference point when determining if their current or proposed salary is
-appropriate.
+I've worked in the IT Audit field since 2018, across internal and external
+audit, small companies and Big 4, in person and remote. Across five companies
+and both sides of the compensation conversation, I've watched good people leave
+money on the table because they had no reliable reference point. That's what
+this page is.
 
-While sites like Glassdoor are locking salary data behind a pay wall, LinkedIn
-is discontinuing LinkedIn Salary, and helpful websites like [[https://www.big4transparency.com/][Big 4 Transparency]]
-are rare, I wanted to provide my personal data publicly and freely to those who
-need it.
-
-I have seen what can happen when great employees don't know the market values
-for their skills and I happily help those in my teams, so I'm happy to extend
-this information to the online community.
-
-As a final note, there are numerous reasons companies pay people in the same
-role differently (e.g., expertise, years of experience, certifications, or
-education). You should only use the data in this table as a single point of
-reference, not the whole story.
+The table goes back to 2017 because the starting point matters. I took what I
+could get to break into the field while finishing school, and I've worked hard
+every day since. I'm not ashamed of any number in that table.
 
 ** Salary Data
 
-#+BEGIN_QUOTE
-When in a role that gives periodic raises, I will create a new record with the
-new base salary in the table below. See the KPMG records for an example of a
-raise while in the same role.
-#+END_QUOTE
-
 This table is a compressed version of the data so that it can fit reliably on
 screens. For the full dataset with all fields, you can view the [[https://cleberg.net/salary.csv][source data]].
 
-| Title                       | Company   | Year | Salary   |
-|-----------------------------+-----------+------+----------|
-| Manager, TA - Audit         | [[https://kpmg.com/us/][KPMG]]      | 2025 | $147,600 |
-| Manager, TA - Audit         | [[https://kpmg.com/us/][KPMG]]      | 2024 | $141,200 |
-| Senior, TA - Audit          | [[https://kpmg.com/us/][KPMG]]      | 2023 | $116,700 |
-| Senior, TA - Audit          | [[https://kpmg.com/us/][KPMG]]      | 2022 | $110,000 |
-| Senior Tech Risk Consultant | [[https://www.ey.com/en_us][EY]]        | 2021 | $89,500  |
-| Senior IT Auditor           | [[https://www.ameritas.com/][Ameritas]]  | 2021 | $72,000  |
-| IT Auditor                  | [[https://www.ameritas.com/][Ameritas]]  | 2020 | $65,000  |
-| IS Auditor II               | [[https://nelnetinc.com/][Nelnet]]    | 2019 | $58,000  |
-| IS Auditor I                | [[https://nelnetinc.com/][Nelnet]]    | 2019 | $20/hour |
-| Internal Audit Intern       | [[https://www.ameritas.com/][Ameritas]]  | 2018 | $16/hour |
-| Teaching Assistant          | [[https://www.unl.edu/][UNL]]       | 2017 | $7/hour  |
-| Community Management Intern | [[https://www.walgreensbootsalliance.com/][Walgreens]] | 2017 | $14/hour |
+| Title                       | Department                   | Company   | Year | Salary   |
+|-----------------------------+------------------------------+-----------+------+----------|
+| Manager                     | Technology Assurance - Audit | [[https://kpmg.com/us/][KPMG]]      | 2025 | $147,600 |
+| Manager                     | Technology Assurance - Audit | [[https://kpmg.com/us/][KPMG]]      | 2024 | $141,200 |
+| Senior                      | Technology Assurance - Audit | [[https://kpmg.com/us/][KPMG]]      | 2023 | $116,700 |
+| Senior                      | Technology Assurance - Audit | [[https://kpmg.com/us/][KPMG]]      | 2022 | $110,000 |
+| Senior                      | Technology Risk - Consulting | [[https://www.ey.com/en_us][EY]]        | 2021 | $89,500  |
+| Senior IT Auditor           | Internal Audit               | [[https://www.ameritas.com/][Ameritas]]  | 2021 | $72,000  |
+| IT Auditor                  | Internal Audit               | [[https://www.ameritas.com/][Ameritas]]  | 2020 | $65,000  |
+| IS Auditor II               | Internal Audit               | [[https://nelnetinc.com/][Nelnet]]    | 2019 | $58,000  |
+| IS Auditor I                | Internal Audit               | [[https://nelnetinc.com/][Nelnet]]    | 2019 | $20/hour |
+| Internal Audit Intern       | Internal Audit               | [[https://www.ameritas.com/][Ameritas]]  | 2018 | $16/hour |
+| Teaching Assistant          | College of Business          | [[https://www.unl.edu/][UNL]]       | 2017 | $7/hour  |
+| Community Management Intern | Store/Retail                 | [[https://www.walgreensbootsalliance.com/][Walgreens]] | 2017 | $14/hour |
 
 ** Salary Visualization
 
-View the graph below for a visualization of each job's salary over time, as well
-as the percentage of change between jobs.
-
 #+caption: Salary Visualization
 #+attr_html: :alt A visualization of salary data over time from the table above.
 [[https://img.cleberg.net/blog/salary/salary.webp]]
 
-[[https://xeiaso.net/salary-transparency/][Xe]] inspired me to publish this page, so I will quote the following wording from
-them as I want to reiterate this piece:
+[[https://xeiaso.net/salary-transparency/][Xe Iaso]] put it better than I would:
 
 #+begin_quote
 Please consider publishing your salary data like this as well. By open,
diff --git a/theme/static/salary.csv b/theme/static/salary.csv
index 5ee8ab4..1f526f7 100644
--- a/theme/static/salary.csv
+++ b/theme/static/salary.csv
@@ -1,13 +1,13 @@
-Title,Company,Location,Start,End,Salary,PercentChange
-Manager - Technology Assurance - Audit,KPMG,Omaha(NE),2025-10,2026-10,147600,0.0453
-Manager - Technology Assurance - Audit,KPMG,Omaha(NE),2024-10,2025-10,141200,0.2099
-Senior Associate - Technology Assurance - Audit,KPMG,Omaha(NE),2023-10,2024-10,116700,0.0609
-Senior Associate - Technology Assurance - Audit,KPMG,Omaha(NE),2022-06,2023-10,110000,0.2290
-Senior Technology Risk Consultant,Ernst & Young,Des Moines(IA),2021-09,2022-06,89500,0.2430
-Senior IT Auditor,Ameritas,Lincoln(NE),2021-05,2021-09,72000,0.1076
-IT Auditor,Ameritas,Lincoln(NE),2020-04,2021-05,65000,0.1206
-IS Auditor II,Nelnet,Lincoln(NE),2019-12,2020-04,58000,0.3942
-IS Auditor I,Nelnet,Lincoln(NE),2019-06,2019-12,41600,0.2500
-Internal Audit Intern,Ameritas,Lincoln(NE),2018-02,2019-06,33280,1.2857
-Teaching Assistant,University of Nebraska,Lincoln(NE),2017-08,2018-05,14560,-0.5000
-Community Management Intern,Walgreens,Lincoln(NE),2017-06,2018-02,29120,0.0000
+Title,Department,Company,Location,Start,End,Salary,PercentChange
+Manager,Technology Assurance - Audit,KPMG,Omaha(NE),2025-10,2026-10,147600,0.0453
+Manager,Technology Assurance - Audit,KPMG,Omaha(NE),2024-10,2025-10,141200,0.2099
+Senior,Technology Assurance - Audit,KPMG,Omaha(NE),2023-10,2024-10,116700,0.0609
+Senior,Technology Assurance - Audit,KPMG,Omaha(NE),2022-06,2023-10,110000,0.2290
+Senior,Technology Risk - Consulting,Ernst & Young,Des Moines(IA),2021-09,2022-06,89500,0.2430
+Senior IT Auditor,Internal Audit,Ameritas,Lincoln(NE),2021-05,2021-09,72000,0.1076
+IT Auditor,Internal Audit,Ameritas,Lincoln(NE),2020-04,2021-05,65000,0.1206
+IS Auditor II,Internal Audit,Nelnet,Lincoln(NE),2019-12,2020-04,58000,0.3942
+IS Auditor I,Internal Audit,Nelnet,Lincoln(NE),2019-06,2019-12,41600,0.2500
+Internal Audit Intern,Internal Audit,Ameritas,Lincoln(NE),2018-02,2019-06,33280,1.2857
+Teaching Assistant,College of Business,University of Nebraska,Lincoln(NE),2017-08,2018-05,14560,-0.5000
+Community Management Intern,Store/Retail,Walgreens,Lincoln(NE),2017-06,2018-02,29120,0.0000