Data Modeling Analyst, Sr. jobs in Tucson, AZ

We are currently hiring a Programmer Analyst I, II, III, or Senior for our IT Customer Applications team. Play a key role in data warehouse development and reporting for our Customer Applications including Customer Care & Billing (CC&B), Advanced Metering Infrastructure (AMI), and Meter Data Management (MDM). Support business units in their data management and analytics needs use of the programs.

What you will do:

• Work with business units, users, and developers of IT customer applications on their data needs.
• Create reports and data extracts using a variety of DW tools including in OBIEE and BI Publisher.
• Performance tuning of Oracle SQL queries and OBIEE reports.
• Development of mappings in Oracle Data Integrator (ODI).

What you bring:

• Demonstrated SQL proficiency in Oracle and/or SQL Server.
• ETL experience.
• Working knowledge of (or desire to learn) Oracle BI; experience with OBIEE preferred.
• A curiosity to learn and understand underlying issues and business needs.
• Ability to work with business units and application users.

*Full job description

Position Description

Creates new custom solutions to integrate enterprise applications both internally and with vendors and partners that ensure on-time, cost-effective delivery with minimal system and business impact while maintaining compliance with IT and product architecture.  Supports complex enterprise-wide IT applications used by multiple business units and external partners.  Assists IS personnel and consults with business clients in the use of information technology and application systems.  Works directly with application vendors, application service providers, SaaS, and cloud computing providers to meet UNS business needs.  Works closely with the IT Enterprise Architecture team to ensure application architecture is consistent with overall IT architecture direction. This position may provide services to affiliates of the Company subject to the UNS Energy Code of Conduct and the related Policies and Procedures.

Position-Related Responsibilities

Programmer Analyst I – Senior:

• Designs, develops, troubleshoots, supports, and configures information systems to support business processes across multiple departments and business units.
• Develops designs, program specifications, data access, output reports, and input specifications.  Assures that the design, programming, testing and documentation for assigned systems are correct, complete and up-to-date.
• Designs, develops, troubleshoots, and maintains software interfaces to enterprise systems using approved SOA middle-tier tools as defined in the IT corporate standards.
• Reviews work requests from clients and develops estimates for work to be performed based on industry standard estimation methodology. 
• Gathers business requirements and recommends solutions to clients for the improvement of existing or proposed systems to enhance the functionality being delivered.
• Works with off shore partners under a global delivery model as required.
• Collaborates with IS infrastructure, network and security teams to develop technical requirements necessary to implement a successful project with minimal risk.
• Educates clients in understanding the operations and capabilities of their information systems.
• Participates in a team environment and performs assignments as requested by the group or team lead. Executes multiple project assignments and coordinates priorities with team leads and clients.
• Continually increases the understanding of utility business functions and processes and functionality in chosen technology track.
• Efficiently utilizes Information Services standards, tools, equipment, and training.
• Conforms to corporate procedures and Information Services guidelines.
• Works with internal and external auditors to validate application controls and compliance.
• Develops software testing, validation requirements, and use cases during the design process.
• Performs other job-related duties as assigned by management.
• This position may provide services to affiliates of the Company subject to the UNS Energy Code of Conduct and the related Policies and Procedures.

Programmer Analyst II – Senior:

• Performs feasibility evaluations, estimates system analysis and programming time, computer resources, and related costs. 
• Performs the project leader role for small projects, directing and reviewing the work of team members.
• Serves as a mentor to other IS personnel to enhance their capabilities.

Programmer Analyst III – Senior:

• Designs and writes complex functional specifications and programs.
• Creates new custom solutions when supported applications don’t include required functionality.
• Improves application proficiency.
• Utilizes project management techniques to develop project plans and track progress to optimize project resources.  Coordinates project priorities with team members, team leaders and other IS Department groups.
• Performs the project leader and/or technical lead role for small to medium projects by assigning, directing, and reviewing the work of team members.
• Works closely with chosen technology track vendors to understand the vendor application roadmap and potential impact on UNS business.

Programmer Analyst Senior:

• Identifies and recommends improvements to the software life cycle process itself.
• Demonstrates expert knowledge of program design methodologies and techniques.
• Evaluates and identifies new and emerging technologies for implementation.
• Recognized as a technology expert and serves as a resource for solving complex problems.
• Recognized as a functional expert that recommends solutions to evolving business processes.
• Acts as a thought leader to influence the delivery of software solutions across the organization.
• Works with IT leadership to define and create application technology roadmap.
• Works with technology vendors to incorporate enterprise requirements into vendor-supplied product roadmaps.
• Performs the project leader and/or technical lead role for medium to large projects by assigning, directing and reviewing the work of team members.
• May serve in a temporary Team Lead capacity when the Team Lead is absent.
• Performs software analysis, code analysis, requirements analysis, software review, identification of   metrics, and system risk analysis.

Knowledge, Skills & Abilities

(Equivalent combination of education and experience will be considered.)

Level I

Minimum Qualifications:              

• High school diploma or GED.
• Minimum 2 years programming experience or a Bachelor’s degree in Information Technology, Computer Science or related disciplines.
• Demonstrated ability to work both independently and as part of a team.

Preferred Qualifications:

• Bachelor’s degree in Information Technology, or equivalent education and/or experience.
• Experience with products and functionality in chosen technology track.
• Excellent communication skills, both verbal and written.
• Demonstrated aptitude for programming skills.

Level II

Minimum Qualifications :

• Minimum 5 years programming experience, with some demonstrated abilities in project management and business requirements definition. 
• Ability to exercise flexibility, initiative, good judgment and discretion.
• Good organizational, time management, customer service and problem-solving skills and the ability to work accurately and meet deadlines with frequent interruptions.
• General understanding of the System Development Life Cycle (SDLC).      

Preferred Qualifications:

• Preferred qualifications of Level I.
• 2 years’ experience with products and functionality in chosen technology track.
• Good understanding of systems integration principles.

Level III

Minimum Qualifications:

• Typically has a minimum 8 years of experience in Information Technology with demonstrated experience in programming, project management, requirements definition, program development and systems design.
• Demonstrated ability to envision new software solutions.
• Demonstrated ability to make presentations to customers or professional peers.
• Demonstrated ability to lead small project teams consisting of 2-4 technical resources or serve as a project Technical Lead.
• Good understanding of the business processes supported.
• Detailed understanding of the System Development Life Cycle (SDLC).     

Preferred Qualifications:

• Preferred qualifications of Level II.
• 5 years’ experience with products and functionality in chosen technology track.
• 2 or more years of successful project management experience.
• Good understanding of systems integration and Services Oriented Architecture (SOA) principles.
• Demonstrated aptitude for team leadership.

Senior

Minimum Qualifications:

• Typically has a minimum 12 years of experience in Information Technology with demonstrated experience and expertise in programming, project management, program development and systems design.
• Demonstrated ability to lead project teams consisting of 4-8 technical resources or serve as a project Technical Lead.
• Detailed understanding of the business processes supported.
• Demonstrated ability to prepare reports that identify trends and make the appropriate recommendations or conclusions for improvement.
• Expert understanding of the System Development Life Cycle (SDLC).         

Preferred Qualifications:

• 8 years’ experience with products and functionality in chosen technology track.
• 4 or more years of successful project management experience.
• Knowledge of and experience using process improvement disciplines (for example, Six Sigma).
• Excellent knowledge/understanding of systems integration and Services Oriented Architecture (SOA) principles, including experience with SOA technologies used at TEP.