The IT Solutions Engineer Analyst Iis responsible for software and hardware product delivery and performance for all application spaces including next generation technology such as cloud engineering and mobile applications. Drives products from design completion to volume production release through lifecycle including troubleshooting software and system problems to ensure performance and reliability.

• Experience in SQL, programming (C#, Java, Python, Javascript), ETL tools (Azure Data Factory, Informatica)

• Knowledge in Data analytics and Business Intelligence tools

• Experience designing and delivering cloud-based data solutions (Azure/AWS)

• Experience facilitating data for big data analytics and business intelligence/reporting.

• Experience working in both agile and waterfall projects

• Bachelors' degree in Information Technology or related field and 1 year of prior relevant experience or equivalent combination of education and directly related experience.

• Requires basic technical subject matter knowledge within a job area or system

Preferred Special Skills, Knowledge or Qualification

• Excellent SQL design and development skills. Develop high-quality, complex SQL queries that interface with applications. Design tables, store procedures, views, functions, forms, and reports.
• Experience with one of the major RDBMS (Oracle, SQL Server preferred).
• Working experience with cloud technologies (like Microsoft Azure Synapse, Microsoft Azure ADF, Oracle Cloud Infrastructure, Oracle Autonomous Database etc.)
• Knowledge of all aspects of software development lifecycle SDLC.
• Familiarity with concept of Data modeling, Data structure, table design, data warehouse design( Dimensional Modeling), Data analytics, reporting.
• Familiarity with Azure DevOPs and agile methodology
• Responsible for creating and maintaining the analytical infrastructure that enables the majority of functions in the data world
• Assembling large, complex sets of data that meet non-functional and functional business requirements
• Deep understanding of the popular data analysis tools and databases, infrastructure as a code to create and maintain an optimal pipeline architecture

1) Develops/configures new applications to meet functional and technical designs

2) Fixes and develops changes to applications to meet functional and technical designs following best practices and development standards and guidelines

3) Engages with business analysts and stakeholders to understand functional requirements and contributes to completion of functional specifications

4) Prepares technical documentation on application specifications

5) Creates deliverables according to the SDLC, such as functional and technical specifications, use cases, test cases, and system documentation

6) Analyzes and resolves development issues in a timely manner

7) Conducts analysis of codes and develops/ deploys defect fixes in engineering processes

8) Proactively assists internal clients with technical issues related to solution implementation

This position may require access to and/or use of information subject to control under the Department of Energy's Part 810 Regulations (10 CFR Part 810), the Export Administration Regulations (EAR) (15 CFR Parts 730 through 774), or the International Traffic in Arms Regulations (ITAR) (22 CFR Chapter I, Subchapter M Part 120) (collectively, 'U.S. Export Control Laws'). Therefore, some positions may require applicants to be a U.S. person, which is defined as a U.S. Citizen, a U.S. Lawful Permanent Resident (i.e. 'Green Card Holder'), a Political Asylee, or a Refugee under the U.S. Export Control Laws. All applicants will be required to confirm their U.S. person or non-US person status. All information collected in this regard will only be used to ensure compliance with U.S. Export Control Laws, and will be used in full compliance with all applicable laws prohibiting discrimination on the basis of national origin and other factors. For positions at Palo Verde Nuclear Generating Stations (PVNGS) all openings will require applicants to be a U.S. person.

Pinnacle West Capital Corporation and its subsidiaries and affiliates ('Pinnacle West') maintain a continuing policy of nondiscrimination in employment. It is our policy to provide equal opportunity in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations. This policy of nondiscrimination shall include, but not be limited to, recruiting, hiring, promoting, compensating, reassigning, demoting, transferring, laying off, recalling, terminating employment, and training for all positions without regard to race, color, religion, disability, age, national origin, gender, gender identity, sexual orientation, marital status, protected veteran status, or any other classification or characteristic protected by law.

For more information on applicable equal employment regulations, please refer to EEO is the Law poster. Federal law requires all employers to verify the identity and employment eligibility of every person hired to work in the United States, refer to E-Verify poster. View the employee rights and responsibilities under the Family and Medical Leave Act (FMLA).

Arizona Public Service is a smoke free workplace.