Apply!

Position Details

Department: IT Integration & Data
Category: Information Technology
Location: Phoenix
Posting #: 446163
Date Posted: 4/3/2019
Employee Type: Regular

Position Summary

Performs activities related to the design, development, testing, implementation, and support of enterprise data warehouse and business intelligence reporting. Gathers reporting requirements and provides recommendations. Working closely with IT project teams, supplies data to support new organizational initiatives.

PCH Values

  • Family-Centered care that focuses on the need of the child first and values the family as an important member of the care team
  • Excellence in clinical care, service and communication
  • Collaborative within our institution and with others who share our mission and goals
  • Leadership that set the standard for pediatric health care today and innovations of the future
  • Accountability to our patients, community and each other for providing the best in the most cost-effective way.

Position Duties

  1. Creates new reports using enterprise data warehouse and other systems
    • Works with requesting stakeholders to understand and validate business needs
    • Creates reports in SQL Server Reporting Services/Power BI Report Server
    • Tests reports and works with stakeholders to refine content and presentation of data
  2. Fulfills data requests for IT Projects and other strategic objectives
    • Works closely with IT Leadership, Project Manager and project team to analyze data needs for projects, and make recommendations in order to meet the identified needs
    • Creates reports and provides data specific to new projects and initiatives
    • Creates automated data extracts to integrate current PCH systems with new applications and vendors
  3. Troubleshoots issues with existing SQL Server Reporting Services reports, and updates as needed
    • Works closely with end users and other internal customers to define reporting needs.
    • Troubleshoots, and corrects issues using the help desk ticketing system
    • Researches, plans and makes recommendations to meet business requirements
    • Works with stakeholders and subject matter experts to test and validate deliverables
  4. Performs miscellaneous job related duties as requested.

Apply for this position?


Note, ONLY 1 attachment will be visible to system per applicant for all applications per active profile. When you upload your resume, our system will attempt to update your profile here, which may overwrite previously completed fields. The attached file is accepted as the resume. It is also allowable to combine both the resume (positioned first in the file) followed by a cover letter into the one file attachment.

or drag your file to this box

Position Qualifications

Please review the following qualifications and specify whether you meet each of the requirements listed.
Do you meet this requirement?
Education
1. Bachelor degree in a computer science, IT, or an information systems related discipline, or equivalent experience. Required
Do you meet this requirement?
Experience
1. Five (5) years of experience working with data and reporting applications. Required
2. Experience working with a variety of database management systems and applications Required
3. Experience working with data in a health care organization Preferred
4. Experience working with reporting tools such as SSRS, SSIS, SSAS, and/or Power BI desirable Preferred
Do you meet this requirement?
Special Skills
1. Advanced SQL skills with ability to write complex SQL queries in a relational database environment. Required
2. Strong analytical skills Required
3. Attention to detail with the ability to work on a variety of concurrent projects Required
4. Background in statistics or statistical analysis desirable Preferred
5. Basic understanding of hospital and health care workflows and processes Preferred
Physical Requirements & Occupational Exposure/Risk Potential
1. Physical Requirement - Fine Motor Skills (pinching, gripping, etc) Occasionally
2. Physical Requirement - Hearing Frequently
3. Physical Requirement - Reaching Occasionally
4. Physical Requirement - Sitting Frequently
5. Physical Requirement - Standing Frequently
6. Physical Requirement - Stooping/crouching/kneeling/crawling Occasionally
7. Physical Requirement - Talking Frequently
8. Physical Requirement - Walking Frequently
9. Physical Requirement - Near Vision Frequently
10. Physical Requirement - Far Vision Occasionally
11. Physical Requirement - Color Discrimination Occasionally
12. Physical Requirement - Use of keyboard, mouse and/or computer equipment Constantly
13. Physical Requirement - Lift up to 35 pounds without assistance Occasionally
14. Occupational Exposure/Risk Potential - Inside office environment Applicable
internal/external
I have reviewed the qualifications, physical requirements and occupational exposure/risk potential for this position and wish to apply