Database Architect - 08-0160

About ARUPARUP Laboratories is a national clinical and anatomic pathology reference laboratory and a worldwide leader in innovative laboratory research and development. Owned by the University of Utah, ARUP offers an extensive menu of highly complex, unique, and esoteric medical tests for patients treated through more than half of the nations university teaching hospitals and children's hospitals, other major hospitals and independent laboratories, military and government facilities, and major clinics.Database Architect08-0160Salt Lake CityUT84108General Function:Responsible for architecture, creation, design and implementation of modifications to existing and future SQL database solutions. Responsible for overall architecture, creation, design, development, implementation and maintenance of Data Warehouse and Business Intelligence solutions.  Knowledgeable in all aspects of the Data Warehouse development life cycle, ETL architecture, technologies and processes and business intelligence technologies. Require developing requirements and design specifications.  Ability of serving as a technical lead in the integration of solutions, designing systems, and developing new business opportunities while working with business departments, functional experts and IT resources. Reporting Function:This position reports to IT Infrastructure Director. Representative Activities and Accountabilities:The specific job duties of this position are: 1.      Architects, develops, implements, documents, maintains, monitors and troubleshoots the Data Warehouse environment and Data Warehouse lifecycle.2.      Leads planning and implementation of improvements to existing database schema, security and architecture.3.      Design technology infrastructure to support performance, availability and architecture requirements in collaboration with other IT resources4.      Designs and builds Data Marts and OLAP cubes to support the mission critical Data Warehouse applications.5.      Designs and builds extractions, ETL processes, data quality (DQ) processes and report objects supporting business requirements.6.      Develops custom code and scripts to support the delivery and presentation of the Data Warehouse.7.      Technically oversees developers creating BI reports and analysis for business. 8.      Resolves Data Warehouse related production issues in a timely manner as required.9.      Leads, develops and maintains data architecture, both in the data warehouse and other relational databases, data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards.10.  Leads and mentors development of team members using industry standard data management practices and tools.11.  Participates in a collaborative team environment functioning within the SCRUM (agile) methodology.12.  Consults with project sponsors regarding development of project plans, information flow and content, including the facilitation of information gathering sessions.13.  Works with end users to understand business reporting requirements and in indentifying new data needs and delivery mechanisms.14.  Leads efforts to evaluate, select and implement Data Warehouse tools and components.15.  Creates written reports of findings and recommendations on performance analysis, feasibility studies and cost justification proposals.Job Qualifications Education/Credentials required:  Education required:       Bachelors or Masters Degree in Information Systems, Computer Science, or Engineering, or equivalent experience. Education/Credentials preferred: Professional certifications a plus. Experience/skills required: 8+ years managing and maintaining enterprise class relational database environments. Five years with SQL Server 2000/2005 environment.6+ years experience designing, developing and deploying data warehousing and business intelligence solutions including dimensional modeling.5+ Microsoft Windows Systems and Network services.Strong experience with multiple DWBI tools and practices, particularly with ETL tools. Proficiency with network security concepts and implementation. Experience/skills preferred:   ORACLE database experience.N-tier architecture and SOA implementation.Knowledge of Crystal Reports and Crystal Enterprise Physical and other requirements: ·      Regular and reliable attendance.  ·      Excellent customer service skills.·      Ability to work well and communicate with individuals and teams.·      Ability to work all required overtime.·      Demonstrate attention to detail·      Work independently, as well as in a group environment with peers/clients.·      Work on several assignments simultaneously.·      Able to work in a potentially stressful environment·      Telecommuting not allowed.ARUP Laboratories - Employee BenefitsARUP supports its employees with a variety of generous benefits, including low-cost medical, dental, vision, prescription drug, life, disability, and long-term care insurance, as well as a flexible spending cafeteria plan.  ARUP supports its employees with a variety of generous benefits; including low-cost medical, dental, vision, prescription drug, life, disability, and long-term care insurance, as well as a flexible spending cafeteria plan.  For further details and eligibility requirements visit www.aruplab.com For further details and eligibility requirements visit www.aruplab.com Why Work at ARUPARUP is committed to providing high quality health care services to its patients and clients while maintaining a corporate culture which promotes integrity, open communication, mutual respect, compassion, creativity, and innovation. Employees are ARUPs most valuable asset and the company backs up this belief with a workplace that supports family, health, and education. Employees are provided with training, support, empowerment, and assistance in developing a healthy work! life balance, as well as the means to continually advance their education and careers. ARUP is consistently recognized as one of Utah and the nations best employers and has earned several honors such as:-One of FORTUNES 100 Best Companies to Work For two years in a row-Seven-time winner of the Department of Workforce Services UUtah'sBest Companies: Work/Life Awards-The American Psychological Associations National Psychologically Healthy Workplace Award In addition, ARUP upholds a strong philosophy of corporate social responsibility. ARUP sustains an active recycling program; provides UTA Eco-Passes and Van Pool options to employees for better utilization of alternative transportation modes; pioneered the mandatory newborn genetic testing mission in the state of Utah; and actively participates in annual food drives and the Angel Tree and Sub for Santa programs. Salt Lake is UUtah's/st1:State> largest city in a large region of the interior West and serves as the industrial, financial, and commercial center of Utah. Salt Lake City welcomed the world by hosting the 2002 Winter Games.  The average maximum daytime temperature for the metropolitan area ranges from 37 degrees in January to 93 degrees in July. Contact Us / How to ApplyFor further information on current career opportunities or to apply online, please visit www.aruplab.com From the home page go to About ARUP/Careers at ARUP/Open Positions. Job board:  https://www2.ultirecruit.com/aru1000/JobBoard/ListJobs.aspx  Please apply for your ideal position(s) through our new online application portal:  http://www.aruplab.com/AboutARUP/Employment/employment_main.jsp.  Applications and resumes can not be viewed by recruiters and hiring managers until an application is completed.       Jobs may close at any time. Applications and/or resumes must be submitted to Human Resources to determine qualifications for specific openings. Some positions require specific formal training. However, depending upon education and the type or quality of prior experience, some exchanges can be made. ARUP is an Equal Opportunity Employer M/F/D/V. All interested persons are encouraged to apply. PLEASE SEND CORRESPONDENCE TO:Recruiting Specialist500 Chipeta WaySalt Lake City, UT 841 08-1221Phone: (801) 583-2787, ext. 2813Toll Free: (800) 242-2787, ext. 2813Fax: (801) 584-5238E-mail: HR@aruplab.com     Reference Code: 08-0160 View all "ARUP Laboratories" jobs