AWS Technical Solutions Architect

Maricopa Community Colleges District • Tempe, AZ

35d

About The Position

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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Executive, Legislative, and Other General Government Support
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees