Database Analyst PTE V
Apply NowCompany: Bates Technical College
Location: Tacoma, WA 98444
Description:
Salary: $82,616.00 Annually
Location : Tacoma, WA
Job Type: Full-time
Job Number: 24-0069
Department: Information Technology
Opening Date: 12/09/2024
Closing Date: 3/16/2025 11:59 PM Pacific
SUMMARY
Reporting to the Executive Director of IT, this position oversees the data collection, data analysis, data entry, and preparation of college data reports for assessment, planning, and other research functions. The Database Analyst provides data management for the college's regional and other accrediting agencies, manages Federal and State data reporting and participates collaboratively and professionally with other faculty and staff to accomplish the data and reporting needs for the college. This is a temporary position funded by a five-year Title III Strengthening Institutions grant which ends Oct 2026.
As per Bates Professional Technical Employees (PTE) agreement, Section 21.1, this position will be open to all permanent bargaining unit members for a minimum period of 5 days.
ESSENTIAL FUNCTIONS & OTHER DUTIES
Essential Functions
Supervisory Responsibilities
QUALIFICATIONS
Minimum Qualifications
If necessary, alternative combinations of education and experience may be evaluated by Human Resources for comparability.
Preferred Qualifications
EQUAL OPPORTUNITY STATEMENT
Bates Technical College reaffirms its policy of equal opportunity and does not discriminate on the basis of race, ethnicity, color, national origin, creed, religion, sex, sexual orientation, gender identity, age, marital status, disability, or status as a disabled veteran or Vietnam era veteran in its programs and activities in accordance with college policy, and applicable federal and state statutes and regulations. Bates publications are available in alternate formats upon request by contacting the Disability Support Services Office at 253.680.7010. Inquiries regarding Bates' non-discriminatory policies, including Title IX and ADA, should be directed to:
For student matters, the Vice President of Institutional Effectiveness and Student Success at 253.680.7105, Downtown Campus A211. For employee matters, the Director of Human Resources at 253.680.7180, Downtown Campus A326.
Available Benefits to Eligible Employees
As a higher education employee, you and your qualified family members are eligible for a wide range of benefits including medical, dental, life insurance, retirement, long-term disability, as well as other optional benefits.
Medical/Dental Plans
Employees pay a portion of their medical care cost through payroll deduction. The employee premium is based on the choice of plan and coverage for eligible dependents.
Bates provides dental coverage at no monthly premium cost to the employee. Benefit eligible employees have a choice of dental plans. Options include:
Bates provides vision coverage at no monthly premium cost to the employee. Benefit eligible employees have a choice of dental plans. Options include:
Retirement Plans
Faculty and Exempt Positions
Faculty have to choose between either the State Board Retirement Plan (SBRP), also known as TIAA or Plan 3 of the Teachers Retirement System (TRS). Click to compare the two plans.
Exempt have to choose between either the SBRP or Plan 3 of the Public Employee Retirement System (PERS). Click to compare the two plans.
SBRP (TIAA) is a defined contribution plan with the following contribution rates:
TRS Plan 3 is a defined benefit and a defined contribution plan with the following contribution rates:
PERS Plan 3 is a defined benefit and a defined contribution plan with the following contribution rates:
Classified Positions
Classified employees have to choose between either the Plan 2 or Plan 3 of the Public Employee Retirement System (PERS). Click to compare the two plans.
PERS Plan 2 is a defined benefits plan with the following contribution rates:
Employee and employer contributions to applicable retirement plans are mandatory. The amount of the deduction and contribution are dependent upon the retirement plan chosen and may vary by current contribution rates in effect.
Bates provides $35,000 basic life insurance for death from any cause and $5,000 basic accidental death and dismemberment at no cost to the employee. Employees can enroll in additional low cost life insurance for themselves and dependents.
Bates provides a basic LTD insurance plan at no cost to employees. The basic plan pays a maximum of
$240 per month after 90 days of total disability. The optional LTD plan pays 60% of the first $10,000 of monthly salary, reduced by any deductible income such as social security or retirement benefits.
Employee cost is dependent upon benefit waiting period chosen.
Other Optional Benefits
Leaves and Holidays
Vacation
Eligible exempt and classified employees accrue annual leave at rates determined by their employee status, ranging from 7 to 16 hours per month when eligible.
Sick Leave
Eligible classified, faculty, and exempt staff accrue sick leave monthly. Employees represented by a bargaining unit should refer to their negotiated agreement for sick leave rules and accrual rates.
Holidays
Bates observes the following holidays/non-work days:
Independence Day, Labor Day, Veterans' Day, Thanksgiving Day, Day after Thanksgiving, Christmas Eve Day, Christmas Day, New Year's Eve Day, New Year's Day, Martin Luther King, Jr. Day, Presidents' Day, Memorial Day, Juneteenth
Personal Leave/Family Leave
In addition to vacation and sick leave, eligible employees receive personal and family leave each fiscal year at rates determined by their employee status
Please Note: All information above is subject to change based on, but not limited to, employment status, legislative mandates, or College policy changes
01
Do you have at least a Bachelor's Degree from an accredited college or university with coursework that includes knowledge of research methods, statistics, and/or data systems design & management.
02
Have you demonstrated intercultural competence and do you have a strong commitment to equity, diversity, and inclusion.
03
If you have alternative combinations of education and experience, please describe them below, or type N/A
Required Question
Location : Tacoma, WA
Job Type: Full-time
Job Number: 24-0069
Department: Information Technology
Opening Date: 12/09/2024
Closing Date: 3/16/2025 11:59 PM Pacific
SUMMARY
Reporting to the Executive Director of IT, this position oversees the data collection, data analysis, data entry, and preparation of college data reports for assessment, planning, and other research functions. The Database Analyst provides data management for the college's regional and other accrediting agencies, manages Federal and State data reporting and participates collaboratively and professionally with other faculty and staff to accomplish the data and reporting needs for the college. This is a temporary position funded by a five-year Title III Strengthening Institutions grant which ends Oct 2026.
As per Bates Professional Technical Employees (PTE) agreement, Section 21.1, this position will be open to all permanent bargaining unit members for a minimum period of 5 days.
ESSENTIAL FUNCTIONS & OTHER DUTIES
Essential Functions
- Collect, analyze, and report data and information for Title III grant and other mandatory reporting and data-informed decision-making.
- Facilitate the development of new automations at the college, including things like on-boarding students/staff, assigning licenses, off-boarding, and more.
- Primary focus on process improvements via data and automation.
- Support implementation of assessment and strategic planning initiatives for continuous improvement.
- Respond to routine and complex data requests on campus; respond to information requests for information and analysis appropriately including through the use of large-scale complex databases.
- Support automated and sustainable web-based reporting systems, scorecards and dashboards using SQL and tools like Tableau or PowerBI.
- Work with IT services to develop, implement, and test database applications and ensure data accuracy, security, and integrity.
- Build database queries, using both legacy and new technologies; extract data from disparate internal and external sources for ad hoc and standard data requests in a timely manner.
- Develop and maintain documentation of projects.
- Download, append, and maintain data warehouses and other SBCTC tools.
- Develop and maintain systems in response to reporting requirements from governmental agencies, such as the U.S. Department of Education, the State Board for Community and Technical Colleges, and others external entities as required. Enter, upload, submit data as necessary.
- Support industry certification and accreditation work across the college.
- Ensure compliance with federal, regional, and state requirements for secure data storage and appropriate data publication.
- Accountable for keeping personal development up-to-date; adding to skills and knowledge through courses that may be available through the Bates Technical College courses, professional development committees, etc.
- Participate actively and collaboratively on committees for college as needed including but not limited to staff recruitment, college councils, etc.
- Additional activities, duties and responsibilities may change to meet college needs.
Supervisory Responsibilities
- This position has no supervisory responsibilities
QUALIFICATIONS
Minimum Qualifications
- Bachelor's Degree from an accredited college or university with coursework that includes knowledge of research methods, statistics, and/or data systems design & management.
- Demonstrated intercultural competence and a strong commitment to equity, diversity, and inclusion.
If necessary, alternative combinations of education and experience may be evaluated by Human Resources for comparability.
Preferred Qualifications
- Master of Science in Data Science or a Master of Science in Applied Statistics and Analytics
- Two (2) years of experience in higher education research, evaluation, and assessment.
- Demonstrated proficiency developing advanced queries in SQL.
- Experience with data modeling techniques and demonstrated ability to create, deploy and maintain large relational databases and data warehouses in a SQL environment.
- Experience designing and deploying interactive web-based dashboards using data visualization tools such as Tableau and PowerBI.
- Previous experience in a community or technical college research environment preferred.
- Experience using PeopleSoft and/or Customer Relationship Management (CRM) technologies.
EQUAL OPPORTUNITY STATEMENT
Bates Technical College reaffirms its policy of equal opportunity and does not discriminate on the basis of race, ethnicity, color, national origin, creed, religion, sex, sexual orientation, gender identity, age, marital status, disability, or status as a disabled veteran or Vietnam era veteran in its programs and activities in accordance with college policy, and applicable federal and state statutes and regulations. Bates publications are available in alternate formats upon request by contacting the Disability Support Services Office at 253.680.7010. Inquiries regarding Bates' non-discriminatory policies, including Title IX and ADA, should be directed to:
For student matters, the Vice President of Institutional Effectiveness and Student Success at 253.680.7105, Downtown Campus A211. For employee matters, the Director of Human Resources at 253.680.7180, Downtown Campus A326.
Available Benefits to Eligible Employees
As a higher education employee, you and your qualified family members are eligible for a wide range of benefits including medical, dental, life insurance, retirement, long-term disability, as well as other optional benefits.
Medical/Dental Plans
Employees pay a portion of their medical care cost through payroll deduction. The employee premium is based on the choice of plan and coverage for eligible dependents.
Bates provides dental coverage at no monthly premium cost to the employee. Benefit eligible employees have a choice of dental plans. Options include:
- Uniform Dental Plan - Preferred Provider Organization
- DeltaCare - Managed Care Plan
- Willamette Dental - Managed Care Plan
Bates provides vision coverage at no monthly premium cost to the employee. Benefit eligible employees have a choice of dental plans. Options include:
- Davis Vision by MetLife
- EyeMed
- MetLife Vision
Retirement Plans
Faculty and Exempt Positions
Faculty have to choose between either the State Board Retirement Plan (SBRP), also known as TIAA or Plan 3 of the Teachers Retirement System (TRS). Click to compare the two plans.
Exempt have to choose between either the SBRP or Plan 3 of the Public Employee Retirement System (PERS). Click to compare the two plans.
SBRP (TIAA) is a defined contribution plan with the following contribution rates:
- Employee Contribution: Under 35: 5% of gross salary; 35-49: 7.5% of gross salary; 50 & over: 10% of gross salary
- Employer Contribution: Under 35: 5% of gross salary; 35-49: 7.5% of gross salary; 50 & over: 10% of gross salary
TRS Plan 3 is a defined benefit and a defined contribution plan with the following contribution rates:
- Employee Contribution: Varies from 5% to 15%
- Employer Contribution: 9.53 of gross salary
PERS Plan 3 is a defined benefit and a defined contribution plan with the following contribution rates:
- Employee Contribution: Varies from 5% to 15%
- Employer Contribution: 9.03% of gross salary
Classified Positions
Classified employees have to choose between either the Plan 2 or Plan 3 of the Public Employee Retirement System (PERS). Click to compare the two plans.
PERS Plan 2 is a defined benefits plan with the following contribution rates:
- Employee Contribution: 6.36% of gross salary
- Employer Contribution: 9.53% of gross salary
- Employee Contribution: Varies from 5% to 15%
- Employer Contribution: 9.53% of gross salary
Employee and employer contributions to applicable retirement plans are mandatory. The amount of the deduction and contribution are dependent upon the retirement plan chosen and may vary by current contribution rates in effect.
Bates provides $35,000 basic life insurance for death from any cause and $5,000 basic accidental death and dismemberment at no cost to the employee. Employees can enroll in additional low cost life insurance for themselves and dependents.
Bates provides a basic LTD insurance plan at no cost to employees. The basic plan pays a maximum of
$240 per month after 90 days of total disability. The optional LTD plan pays 60% of the first $10,000 of monthly salary, reduced by any deductible income such as social security or retirement benefits.
Employee cost is dependent upon benefit waiting period chosen.
Other Optional Benefits
Leaves and Holidays
Vacation
Eligible exempt and classified employees accrue annual leave at rates determined by their employee status, ranging from 7 to 16 hours per month when eligible.
Sick Leave
Eligible classified, faculty, and exempt staff accrue sick leave monthly. Employees represented by a bargaining unit should refer to their negotiated agreement for sick leave rules and accrual rates.
Holidays
Bates observes the following holidays/non-work days:
Independence Day, Labor Day, Veterans' Day, Thanksgiving Day, Day after Thanksgiving, Christmas Eve Day, Christmas Day, New Year's Eve Day, New Year's Day, Martin Luther King, Jr. Day, Presidents' Day, Memorial Day, Juneteenth
Personal Leave/Family Leave
In addition to vacation and sick leave, eligible employees receive personal and family leave each fiscal year at rates determined by their employee status
Please Note: All information above is subject to change based on, but not limited to, employment status, legislative mandates, or College policy changes
01
Do you have at least a Bachelor's Degree from an accredited college or university with coursework that includes knowledge of research methods, statistics, and/or data systems design & management.
- Yes
- No
02
Have you demonstrated intercultural competence and do you have a strong commitment to equity, diversity, and inclusion.
- Yes
- No
03
If you have alternative combinations of education and experience, please describe them below, or type N/A
Required Question