DEPT OF REVENUE

Funding Arizona’s future through excellence in innovation, exceptional customer service and public servant-led continuous improvement.

All Arizona State employees operate within the Arizona Management System (AMS), an intentional, results-driven approach for doing the work of state government. Our goal is for every ADOR team member to reflect on individual and team performance, reduce waste, and commit to continuous improvement with sustainable progress. Through AMS, every ADOR team member seeks to understand customer needs, identify problems, improve processes, and measure results.

ETL Developer Senior

Job Location:

Address:1600 W Monroe Street Phoenix AZ 85007

Posting Details:

Salary: $84,000 annualized 

Grade: 27

Closing Date: Open Until Filled

Job Summary:

Under the supervision of the IT Manager, utilizes advanced skills to support and improve complex client/service applications based on a multi-tier, object-oriented architecture. The Senior Software Developer is responsible for designing, coding, and documenting ETL interfaces, as well as creating data warehouse reports using Business Intelligence Reporting tools such as COGNOS, SSRS, and PowerBI. Additionally, the ETL Developer engages in programming tasks, including the creation of database objects, unit and integration testing to ensure compliance with business requirements, and verification of programming logic. Proficiency in Microsoft .NET and Azure DevOps is required. Furthermore, the ETL Developer assists Quality Assurance and User Acceptance Test Teams in resolving application-related issues during testing, and develops comprehensive on-line help systems, user manuals, and training manuals as needed. This role may involve working extended hours or outside regular business hours, along with other assigned responsibilities.

This position is available for remote work on a full-time basis within Arizona (including virtual office arrangements).

The State of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, and commissions, many State employees participate in the State’s Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance.

Job Duties:

Development
Works as Senior Developer to include, where applicable:

• Designing overall system architecture
• Identifying technologies that support the system development goals
• Programming
• Testing by way of performing unit and integration testing to ensure business requirements are met and programming logic executes as expected.
• Designing, developing, and maintaining ETL processes and Business Intelligence reports in compliance with general standards and integrate with enterprise architecture
  

Project Support
Works with management and project management offices to develop and maintain project objectives and plans including:

• Reports out on development status
• Organizes and participates in team project meetings to include weekly status during all project phases, business requirements gathering and reviews, design reviews, and test conditions reviews
• Plans, manages and provides project status following the adopted Agency's Software Development Life-cycle (SDL) from inception to implementation to include gathering analysis, design, programming and testing effort estimates; identifying and assigning resources for those efforts; creating project work plans; tracking project timelines; identifying and resolving issues and risks; confidently communicating status Agency's key stakeholders
  

Requirements Gathering

• Works closely with business analysts and/or users to determine requirements and receive feedback
• Provides support and training to users during user testing
• Understands, develops and maintains an understanding of customer needs and priorities in order to support and deliver both business and technical solutions to meet those needs
  

Agency/Department Compliance & Continuous Improveme