AWS Technical Solutions Architect

Arizona Department of Education • Scottsdale, AZ

36d • Hybrid

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.

Requirements

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

Nice To Haves

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

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.

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
• https://www.azasrs.gov/, 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 forhttps://studentaid.gov/manage-loans/forgiveness-cancellation/public-service (potential loan forgiveness for federal Direct Loans after meeting repayment requirements and working full-time for an eligible employer)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Machinery Manufacturing
• Number of Employees: 251-500 employees