Maricopa Community College district
AWS Technical Solutions Architect
Maricopa Community College district, Tempe, Arizona, us, 85285
AWS Technical Solutions Architect
Job ID:
322077
Location:
District Support Services Cntr
Employment Type:
Full Time
Classification:
Regular
Salary Range:
$73,670.00 - $95,771.00 annually, DOE
Grade:
119
Work Schedule:
Monday - Friday, 8am - 5pm; Summer Hours: Monday - Thursday, 7am-6pm
Work Calendar:
12 Months
Maricopa Summary The Maricopa County Community College District is one of the largest community college systems in the nation. Home to 10 individually accredited community colleges and 31 satellite locations, we proudly serve students in every corner of the Valley. Each day, our dedicated faculty, staff, and administrators, live out our vision-creating excellence in education for a better world.
We focus on people-not profits. With 100% acceptance, zero rejections, and affordable tuition, we provide the flexibility and support our students need to succeed in and beyond the classroom. Discover how we're changing college.
We don't just support our community-we help build it. We are the largest provider of workforce development training in the state. The activities of our colleges and their students support one out of every 28 jobs in Maricopa County. Learn about our economic impact.
We believe our employees are our most valuable asset. Our 10 colleges and District Office support nearly 10,000 jobs and careers throughout Greater Phoenix.
Join us in making a real difference in the lives of over 140,000 college students each year.
Benefits Maricopa County Community College District (MCCCD) is committed to providing a competitive and comprehensive benefits program that supports our employees' and their families' health and well-being. Therefore, the MCCCD benefits support every stage of life and are designed to meet the diverse needs of our community. Explore the wide range of benefits and perks available to eligible employees at MCCCD:
Nationwide Medical, Dental, and Vision Coverage
Paid Time Off: Vacation, Sick Leave, and Personal Time
20 Paid Observed Holidays
Company-paid Life Insurance, AD&D, and Short-Term Disability plans, with the option to purchase supplemental coverage
Arizona State Retirement System (ASRS) Pension, including Long Term Disability and Retiree Health Insurance with 100% employer-matching contributions
Optional Retirement Plans: 403(b), 457(b), Roth 403(b), Roth 457(b)
Tuition Reimbursement for employees and dependents
Annual Professional Development Funding
Flexible Work Schedules
Employee Health & Wellness Programs:
District-Wide Wellness Program with Workshops and Webinars
Monthly Health & Wellness Calendar and Newsletter
Virta Diabetes Reversal Program, Support Groups, and Diabetes Empowerment Education Programs
Employee Assistance Program (EAP)
Sight-On-Site Eye Care Services
Mobile On-Site Mammography Screenings
Pre-Retirement Planning Events
Qualifying Employer for Public Service Loan Forgiveness (potential loan forgiveness for federal Direct Loans after meeting repayment requirements and working full-time for an eligible employer)
Job Summary Information Technology Services (ITS) at the MCCCD is looking for a creative AWS Technical Solutions Architect to deliver solutions for ETL and data pipeline activities. Under the direction of the Director of Data Engineering & AI Enablement, this role partners with seasoned data professionals to design and develop architecture solutions. These solutions will be key for extracting, transforming, and loading data from various sources to repositories in AWS (data lakes and data warehouses) for use in reporting, analytics, AI, and other business needs. The position will also aid in the creation and tuning of SQL scripts as well as assisting in managing AWS RDS databases.
Essential Functions
35% - Writes and optimizes queries to manipulate, cleanse, and extract data for use in data pipelines; collaborates with customers to troubleshoot routine query issues; participates on projects in various capacities lending subject matter expertise; completes deliverables on time and with accuracy.
20% - Creates, configures, and maintains data pipelines in on-prem and cloud environments; uses data repositories, data dictionaries, data warehousing, ETL tools, and other elements of data pipelines; drafts new and updates existing documentation.
15% - Creates, configures, and maintains cloud databases including backups, restores, tuning, patching, upgrading, and monitoring.
10% - Troubleshoots and remediates data issues in association with other ITS teams and customers; responds to inquiries through Maricopa's helpdesk system following established SLAs.
10% - Researches industry standards, trends, best practices and emerging technologies and makes recommendations for implementation; provides guidance and recommendations for security, architecture, and other data related issues.
10% - Attends meetings as relevant; performs related duties as assigned.
Minimum Qualifications Bachelor's Degree from a regionally accredited institution in information technology or related field and two (2) years of information technology experience in the design, architecture and implementation of IT Systems.
OR
An equivalent combination of the conferred degree, education, certification and directly related full-time work experience as described above sufficient to successfully perform the essential duties of the job such as those listed above, unless otherwise subject to any other requirements set forth in law or regulation, may be considered.
Desired Qualifications
Experience developing in SQL.
Possession of AWS Data Analytics or AWS Solutions Architect certification.
Experience with RDS database management.
Experience with PeopleSoft tables and table structure.
Experience with AWS services such as S3, Glue, Lambda, RDS, Redshift, CloudWatch, CloudFormation, and IAM.
Experience with data lake and data warehouse architectures.
Experience with Airflow or other workflow orchestration tools.
Special Working Conditions There is a mandatory minimum in-office expectation, currently two days onsite, in which the District reserves the right to update at any time.
The selected candidate will need to reside in the Phoenix area or relocate within six months of hire.
This role may involve after hours work and non-regular business hours.
May be required to sit for a prolonged period of time; viewing a computer monitor.
May be required to present in large meetings and sponsored events.
ITS does not sponsor individuals for any type of work visas.
How to Apply Applicants are strongly encouraged to submit a cover letter that details how the applicant meets the minimum and desired qualifications. A cover letter may further highlight an applicant's knowledge, skill and abilities. All minimum requirements must be met at the time of the application.
Additional materials will not be accepted after the job posting has closed.
Missing materials or incomplete employment history will not be considered.
Please ensure your materials clearly provide the following information.
Clearly illustrate how prior experience, knowledge and education meet the minimum and desired qualifications for this position.
Indicate whether former or current employment is Full-Time or;
Part-Time employment (must include number of hours worked)
Provide employment history in a month/year format (e.g., 09/07 to 10/11) including job title, job duties, for each position held and name of employer for each position.
Three professional references, preferably current and/or former supervisors. If references are not provided in resume upon application, they will be requested at time of interview.
Posting Close Date Open until filled
First Review Monday, December 1, 2025
Applications received after the review date may not be screened.
EEO, Title IX, & Clery Act Maricopa County Community College District (MCCCD) will not discriminate, nor tolerate discrimination in employment or education, against any applicant, employee, or student because of race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship status (including document abuse), age, disability, veteran status or genetic information.
Title IX of the Education Amendments of 1972, states: "No person in the United States shall, on the basis of sex, be excluded from participation in, be denied the benefits of, or be subjected to discrimination under any education program or activity receiving Federal financial assistance."
The policy of the MCCCD is to provide an educational, employment, and business environment free of gender discrimination. Incidents of misconduct should be reported to the college Title IX Coordinator, as outlined in policy, contact information is available at this link Title IX Coordinators.
The Clery Act is a Federal law requiring United States Colleges and Universities to disclose information about crime on and around their campuses. Crime reporting data for each of the Maricopa Community Colleges, as required under the Clery Act, is available at this link Clery Act.
To apply To apply, visit https://jobs.maricopa.edu/psp/MCPAHPRD/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&FOCUS=Applicant&SiteId=1000&JobOpeningId=322077&PostingSeq=1
#J-18808-Ljbffr
322077
Location:
District Support Services Cntr
Employment Type:
Full Time
Classification:
Regular
Salary Range:
$73,670.00 - $95,771.00 annually, DOE
Grade:
119
Work Schedule:
Monday - Friday, 8am - 5pm; Summer Hours: Monday - Thursday, 7am-6pm
Work Calendar:
12 Months
Maricopa Summary The Maricopa County Community College District is one of the largest community college systems in the nation. Home to 10 individually accredited community colleges and 31 satellite locations, we proudly serve students in every corner of the Valley. Each day, our dedicated faculty, staff, and administrators, live out our vision-creating excellence in education for a better world.
We focus on people-not profits. With 100% acceptance, zero rejections, and affordable tuition, we provide the flexibility and support our students need to succeed in and beyond the classroom. Discover how we're changing college.
We don't just support our community-we help build it. We are the largest provider of workforce development training in the state. The activities of our colleges and their students support one out of every 28 jobs in Maricopa County. Learn about our economic impact.
We believe our employees are our most valuable asset. Our 10 colleges and District Office support nearly 10,000 jobs and careers throughout Greater Phoenix.
Join us in making a real difference in the lives of over 140,000 college students each year.
Benefits Maricopa County Community College District (MCCCD) is committed to providing a competitive and comprehensive benefits program that supports our employees' and their families' health and well-being. Therefore, the MCCCD benefits support every stage of life and are designed to meet the diverse needs of our community. Explore the wide range of benefits and perks available to eligible employees at MCCCD:
Nationwide Medical, Dental, and Vision Coverage
Paid Time Off: Vacation, Sick Leave, and Personal Time
20 Paid Observed Holidays
Company-paid Life Insurance, AD&D, and Short-Term Disability plans, with the option to purchase supplemental coverage
Arizona State Retirement System (ASRS) Pension, including Long Term Disability and Retiree Health Insurance with 100% employer-matching contributions
Optional Retirement Plans: 403(b), 457(b), Roth 403(b), Roth 457(b)
Tuition Reimbursement for employees and dependents
Annual Professional Development Funding
Flexible Work Schedules
Employee Health & Wellness Programs:
District-Wide Wellness Program with Workshops and Webinars
Monthly Health & Wellness Calendar and Newsletter
Virta Diabetes Reversal Program, Support Groups, and Diabetes Empowerment Education Programs
Employee Assistance Program (EAP)
Sight-On-Site Eye Care Services
Mobile On-Site Mammography Screenings
Pre-Retirement Planning Events
Qualifying Employer for Public Service Loan Forgiveness (potential loan forgiveness for federal Direct Loans after meeting repayment requirements and working full-time for an eligible employer)
Job Summary Information Technology Services (ITS) at the MCCCD is looking for a creative AWS Technical Solutions Architect to deliver solutions for ETL and data pipeline activities. Under the direction of the Director of Data Engineering & AI Enablement, this role partners with seasoned data professionals to design and develop architecture solutions. These solutions will be key for extracting, transforming, and loading data from various sources to repositories in AWS (data lakes and data warehouses) for use in reporting, analytics, AI, and other business needs. The position will also aid in the creation and tuning of SQL scripts as well as assisting in managing AWS RDS databases.
Essential Functions
35% - Writes and optimizes queries to manipulate, cleanse, and extract data for use in data pipelines; collaborates with customers to troubleshoot routine query issues; participates on projects in various capacities lending subject matter expertise; completes deliverables on time and with accuracy.
20% - Creates, configures, and maintains data pipelines in on-prem and cloud environments; uses data repositories, data dictionaries, data warehousing, ETL tools, and other elements of data pipelines; drafts new and updates existing documentation.
15% - Creates, configures, and maintains cloud databases including backups, restores, tuning, patching, upgrading, and monitoring.
10% - Troubleshoots and remediates data issues in association with other ITS teams and customers; responds to inquiries through Maricopa's helpdesk system following established SLAs.
10% - Researches industry standards, trends, best practices and emerging technologies and makes recommendations for implementation; provides guidance and recommendations for security, architecture, and other data related issues.
10% - Attends meetings as relevant; performs related duties as assigned.
Minimum Qualifications Bachelor's Degree from a regionally accredited institution in information technology or related field and two (2) years of information technology experience in the design, architecture and implementation of IT Systems.
OR
An equivalent combination of the conferred degree, education, certification and directly related full-time work experience as described above sufficient to successfully perform the essential duties of the job such as those listed above, unless otherwise subject to any other requirements set forth in law or regulation, may be considered.
Desired Qualifications
Experience developing in SQL.
Possession of AWS Data Analytics or AWS Solutions Architect certification.
Experience with RDS database management.
Experience with PeopleSoft tables and table structure.
Experience with AWS services such as S3, Glue, Lambda, RDS, Redshift, CloudWatch, CloudFormation, and IAM.
Experience with data lake and data warehouse architectures.
Experience with Airflow or other workflow orchestration tools.
Special Working Conditions There is a mandatory minimum in-office expectation, currently two days onsite, in which the District reserves the right to update at any time.
The selected candidate will need to reside in the Phoenix area or relocate within six months of hire.
This role may involve after hours work and non-regular business hours.
May be required to sit for a prolonged period of time; viewing a computer monitor.
May be required to present in large meetings and sponsored events.
ITS does not sponsor individuals for any type of work visas.
How to Apply Applicants are strongly encouraged to submit a cover letter that details how the applicant meets the minimum and desired qualifications. A cover letter may further highlight an applicant's knowledge, skill and abilities. All minimum requirements must be met at the time of the application.
Additional materials will not be accepted after the job posting has closed.
Missing materials or incomplete employment history will not be considered.
Please ensure your materials clearly provide the following information.
Clearly illustrate how prior experience, knowledge and education meet the minimum and desired qualifications for this position.
Indicate whether former or current employment is Full-Time or;
Part-Time employment (must include number of hours worked)
Provide employment history in a month/year format (e.g., 09/07 to 10/11) including job title, job duties, for each position held and name of employer for each position.
Three professional references, preferably current and/or former supervisors. If references are not provided in resume upon application, they will be requested at time of interview.
Posting Close Date Open until filled
First Review Monday, December 1, 2025
Applications received after the review date may not be screened.
EEO, Title IX, & Clery Act Maricopa County Community College District (MCCCD) will not discriminate, nor tolerate discrimination in employment or education, against any applicant, employee, or student because of race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship status (including document abuse), age, disability, veteran status or genetic information.
Title IX of the Education Amendments of 1972, states: "No person in the United States shall, on the basis of sex, be excluded from participation in, be denied the benefits of, or be subjected to discrimination under any education program or activity receiving Federal financial assistance."
The policy of the MCCCD is to provide an educational, employment, and business environment free of gender discrimination. Incidents of misconduct should be reported to the college Title IX Coordinator, as outlined in policy, contact information is available at this link Title IX Coordinators.
The Clery Act is a Federal law requiring United States Colleges and Universities to disclose information about crime on and around their campuses. Crime reporting data for each of the Maricopa Community Colleges, as required under the Clery Act, is available at this link Clery Act.
To apply To apply, visit https://jobs.maricopa.edu/psp/MCPAHPRD/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&FOCUS=Applicant&SiteId=1000&JobOpeningId=322077&PostingSeq=1
#J-18808-Ljbffr