Apply on Employer Site

Maricopa Community Colleges · 1 day ago

AWS Solutions Architect

Tempe, AZ

Full-time

Onsite

Entry, Mid Level

$74K/yr - $96K/yr

2+ years exp

Maricopa County Community College District (MCCCD) is one of the largest community college systems in the nation, serving students across Greater Phoenix. They are seeking an AWS Technical Solutions Architect to design and develop architecture solutions for ETL and data pipeline activities, collaborating with data professionals to enhance data management and analytics capabilities.

CommunitiesEducationHigher Education

No H1B

Hiring Manager

Gwen Bernal

Responsibilities

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

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

Creates, configures, and maintains cloud databases including backups, restores, tuning, patching, upgrading, and monitoring

Troubleshoots and remediates data issues in association with other ITS teams and customers; responds to inquiries through Maricopa’s helpdesk system following established SLAs

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

Attends meetings as relevant; performs related duties as assigned

Qualification

AWS Solutions Architect certificationSQL developmentRDS database managementAWS services experienceData lake architectureData warehouse architectureAirflow experienceTroubleshooting skillsCollaboration skillsDocumentation skills

Required

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

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

Preferred

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

Benefits

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

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)