Programmer Analyst II or III

UNS Energy Corporation, headquartered in Tucson, Arizona, is a subsidiary of Fortis Inc., the largest investor-owned electric and gas distribution utility in Canada. Our public utility subsidiaries, Tucson Electric Power Company, UNS Electric, Inc. and UNS Gas, Inc., power our economy by providing electric and gas service to nearly 700,000 customers in Arizona.

We embrace a spirit of giving, dedicated to improving quality of life in the communities we have served for generations, and in TEP's case, since the 1890s. We're building a cleaner, greener grid, with more wind and solar power than ever before, while maintaining safe, reliable, and affordable service.

Our culture is rooted in shared core values that define how we work and who we are. Our team of innovative professionals bring their authentic selves to work each day to power our vision and make a difference. Be Part of Our Story.

We create opportunities for employees to thrive through:

• Continual growth: In an industry changing faster than ever before, our commitment to professional growth and leadership development means we never stop challenging ourselves to explore new possibilities.
• Active Engagement: We support a collaborative environment, with peer-to-peer learning and employee-driven groups that foster an inclusive culture.
• Total compensation: UNS Energy Corporation also offers a competitive compensation and benefits package that includes a 401k plan with a generous company match, a company-sponsored pension plan, affordable individual and family health insurance plans, tuition assistance, life insurance, long-term disability insurance and much more.

Hear from some of our employees, here and here.

Job Description -BI Programmer Analyst II to III

The utility industry is a dynamic environment undergoing incredible and exciting changes. Be a part of developing and implementing the strategy behind those changes.

Position-Related Responsibilities:

• Design and development of OBIEE RPD
• Work with different business stakeholders to gather requirements and design analytics solutions
• Maintain and creation of reports in OBIEE, BI Publisher and Power BI
• Maintain and development of mappings in Oracle Data Integrator (ODI)
• Maintain and creation of data marts/data warehouse from different data sources
• Monitoring and support of ODI daily loads
• Performance tuning of Oracle SQL queries, OBIEE and Power BI Reports
• Learn and support applications that are supported by team
• Conduct training sessions for business users of the supported technologies periodically
• Performs the project leader and/or technical lead role for small to medium projects by assigning, directing and reviewing the work of team members.
• Working as a part of On-Call team member on rotational basis

Knowledge, Skills & Abilities(Equivalent combination of education and experience will be considered)

Level II

Minimum Qualifications

• Minimum 5 years programming experience, with some demonstrated abilities in project management and business requirements definition.
• 3 years of experience in Oracle Business Intelligence (OBIEE)
• 3 years of experience in Oracle Data Integrator (ODI) or Informatica
• 3 years of experience in Oracle PL/SQL
• Good understanding of the business processes supported
• Excellent communication skills, both verbal and written

Preferred Qualifications

• Bachelor's degree in Information Technology, or equivalent education and/or experience
• Experience in Oracle BI Apps (OBIA)
• Experience in Java or Python
• Project management experience

Level III

Minimum Qualifications

• Minimum 8 years of experience in Information Technology with demonstrated experience in programming, project management, requirements definition, program development and systems design.
• 4 years of experience in Oracle Business Intelligence (OBIEE)
• 4 years of experience in Oracle Data Integrator (ODI) or Informatica
• 4 years of experience in Oracle PL/SQL
• Good understanding of the business processes supported
• Excellent communication skills, both verbal and written

Preferred Qualifications

• Bachelor's degree in Information Technology, or equivalent education and/or experience
• Experience in Oracle BI Apps (OBIA)
• Experience in Java or Python
• Project management experience

Pay Rate: Competitive pay based on qualifications and experience

All job offers are contingent on successful completion of a pre-employment drug screen and background check.

California Job Applicants - click here to see our Job Applicant Privacy Notice.