Data Warehouse Analyst, Interm
Full-Time at Northern Arizona University, Information Tech Services
posted on September 22, 2012
The Data Warehousing Analyst, Intermediate in the NAU Enterprise Reporting Solutions (data warehouse) environment, is a mid-level technical expert with training and experience in data warehousing systems analysis and programming. The incumbent acts independently and requires minimal supervision. They will provide technical support in all phases of projects, be proficient in technical skills, concepts and relational data appropriate for the application(s) supported, and be in constant communication with technical management and business analysts. The incumbent will participate in multiple, concurrent mission-essential projects.
Potential candidates need to be able to think and act quickly, including coming up with solutions on the fly with only half the picture. If you are the kind of person that needs to see the whole-completed puzzle before making a decision this is NOT the environment for you. We need candidates that can operate and operate well in a fast-paced, sometimes hectic environment.
• Research and Analyze data in content, relationships, business rules and business processes for NAU's administrative systems, HR/Payroll/Benefits/TAM, Student Financials/Student Records, etc., departmental databases and independent data sources. Typically this requires collaborative working relationships with
- NAU data experts.
- NAU business analysts.
- NAU technical analysts.
- IRM customer service analysts.
- IRM technical analysts.
• Develop in-depth knowledge of the data structures within the university's transactional systems.
• Develop and maintain ETL process using available tools (e.g. Informatica, Unix/Linux/Windows Scripts, and Appworx) to extract data from the university's transactional systems, ensuring:
- Data is loaded into appropriate database structures.
- Data is available to people and processes as needed.
- Data is cleansed, aggregated and calculated as required.
- Data is normalized and denormalized as needed by Data Warehouse Business Analysts and others granted access to NAU's data warehouse.
• Ensuring the technical environment is available according to the business requirements of NAU administrators.
• Support university reporting requirements using Business Objects, typically:
- Develop and/or revise reports as required.
- Ensure reports contain appropriate documentation and change history.
- Deliver information in a timely manner.
- Ensure reports are written efficiently and effectively.
• Design, develop, test and implement:
- Standard business reports.
- Pre-defined, customizable business reports.
- statistical analysis reports.
- ad-hoc reports as requested by NAU administrators.
• Work collaboratively with Enterprise Reporting Solutions team and across ITS's technical and support analysts to ensure:
- Standards are established, revised and adhered to.
- Documentation requirements are complete and readily available.
- High level design and purpose of mapping is understood.
- Scheduling requirements are documented and implemented appropriately.
- Accurate and timely delivery of data.
- Awareness of data issues that impact usage.
- Awareness of data corruption or absence.
- Data is available as requested.
- End users are aware of data issues affecting their reports, including corruption and absence.
- Ensure scheduling information is documented and complete.
- Attend scheduling meetings and advise Operations staff on scheduling changes.
- Scheduling changes or significant events are effectively communicated.
• Bachelor's degree in Computer Science or related field from a recognized institution -AND - two years of systems and/or programming experience, -OR-,
• Associate's degree in Computer Science or related field from a recognized institution AND four years of systems and/or programming experience, -OR-,
• Any equivalent combination of experience, training and/or education.
• Experience in a higher education (public or private sector), or state government environments.
Knowledge Skills and Abilities
• Demonstrated expertise supporting development central data warehouse applications using ETL and / or Business Intelligence software.
• Strong analytical and problem-solving skills.
• Experience with Oracle database development, SQL and relational database design.
• Experience with MicroSoft SQL Server 2008 and SQL Server Integration Services.
• Strong skills using Microsoft Word, Excel, Project, Access and Internet Explorer.
• Demonstrated Customer Service skills.
• Ability to put the team goals and the team accountability ahead of their own individual situation.
• Strong oral presentation and written communication skills.
• Ability to concurrently handle multiple complex priorities.
• Experience in taking initiative within areas of responsibility.
• Flexible and able to adapt to change.
• Experience acting as expert in business or functional area.
• Experience defining system scope and objectives.
• Demonstrated commitment to quality assurance processes.
• Ability to quickly and efficiently transition development support between tasks on a variety of application modules.
This position has been identified as a safety/security sensitive position. Therefore, per AZ Revised Statute, Northern Arizona University requires satisfactory results for the following: a criminal background investigation, employment history investigation, degree verification (in some cases) and fingerprinting.
Additionally, as an employer in the state of Arizona, NAU is required to participate in the federal E-Verify program that assists employers with verifying new employees' right to work in the United States.
This is a Service Professional (SPF) position. NAU offers an excellent benefit package including generous health, dental and vision insurance; participation in the Arizona State Retirement System or the Optional Retirement Program; 22 days of vacation and 10 holidays per year; and tuition reduction for employees and qualified family members. More information on benefits at NAU is available at www.nau.edu/hr .
Service Professionals are hired on a contract basis, renewable each fiscal year according to terms of the Conditions of Professional Service, which may be found on the Internet at: https://azregents.asu.edu/rrc/Policy&/….
Employees offered a position on or after July 20, 2011, will be eligible for state health plans (including NAU's BCBS Plan) after 90 days of employment. If you accept an offer on or after July 20, 2011, and you choose the ASRS retirement option, you will begin participating in the Arizona State Retirement System, and the long-term disability coverage that accompanies it, on the first of the pay period following 27 weeks (6 months) after your start date. New employees who choose to participate in the Optional Retirement Plan (ORP), which is an alternative to the ASRS plan for faculty and other appointed staff, will begin to participate on the first day of employment. Additionally, the long-term disability plan that accompanies the ORP will begin on the first day of the pay period following 90 days after start date. More information is available at: http://hr.nau.edu/node/10159.
Open until further notice.