AWS Technical Solutions Architect

AWS Technical Solutions Architect

Job : 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

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.

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)

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.

• 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.

Bachelor's Degree from a regionally accredited institution in information technology or related field and two (2) years of…