Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
Similar Jobs
Business Intelligence Administrator
Valley Medical Center
Renton, WA
Apply Now >
Software Design Engineer 3
Harman International Industries
Redmond, WA
Apply Now >
Sr Manager Tax Technology Operations
Expedia, Inc.
Bellevue, WA
Apply Now >
Customer Service Business Analyst Job
PACCAR, Inc.
Renton, WA
Apply Now >
Digital Music QA Bilingual Japanese English 16 Positions
Aerotek, Inc
Seattle, WA
Apply Now >
View more jobs in Renton, WA
View more jobs in Washington

Job Details

Business Intelligence Administrator

Company name
Valley Medical Center

Location
Renton, WA

Apply for this job






8 hit(s)  

Profile

Job Detail




  • Job Title:Business Intelligence Administrator


  • Req:2018-0090


  • Location:VMC Main Campus


  • Department:Information Technology


  • Shift:Days


  • Type:Full Time


  • FTE:1


  • Hours:










Job Description:

VALLEY MEDICAL CENTER

Job Description

Information Technology

This position description is a guide to the critical duties and essential functions of the job, not an all-inclusive list of responsibilities, qualifications, physical demands and work environment conditions. Position descriptions are reviewed and revised to meet the changing needs of the organization.

Title: Business Intelligence Administrator

Overview: The Business Intelligence Administrator is responsible for the planning, development, maintenance, and growth of the databases that support the Epic applications and the data marts that drive dashboards supported by Epic and other systems. This position will support one or more solutions of moderate to extreme complexity, and perform with a high degree of independence on small to moderate projects and assignments. This position will play an active role in complex projects such as software implementations and upgrades as a business/technical collaborator, subject matter resource, and task/assignment resource.

Area of Assignment: Information Technology

Hours: Typically, Monday – Friday, 7:30 am to 4:00 pm or as needed to meet departmental needs

Responsible to: Director, Business & Support Applications

PRE-REQUISITES:



  • Minimum Bachelor’s degree in Information Technology, Computer Science, or related field is required, OR an equivalent combination of education and/or experience.


  • Minimum of seven (7) plus years of progressive IT data services experience, including a minimum of five (5) years of direct development experience in using SQL Server tools (SSAS, SSRS and SSIS).


  • Hands-on experience with SQL Server 2008/2012 database management platform.


  • Hands-on experience with gathering requirements and implementing ETL processes in a Data Warehouse environment.




Certifications/Licenses:

Any certifications related to software applications, technology infrastructure, and/or a clinical specialization is an advantage.

Must be able to obtain Epic certification – if not Epic certified at time of hire, must become certified or have initiated the process of scheduling within 6 months of employment (certification training availability is based on vendor schedule options. Some positions may require multiple certifications.)

GENERAL QUALIFICATIONS:



  • Demonstrated experience in Data Warehouse development.


  • Demonstrated experience creating data visualizations utilizing data visualization tools, Tableau for example.


  • Hands-on experience developing Crystal Reports a plus


  • Hands-on experience with software patching and upgrades


  • XML parsing and manipulation experience a plus


  • Microsoft Windows Server administration and Alteryx Server experience a plus


  • Ability to work independently and in teams with good problem solving, communication, and organizational skills.


  • Demonstrated continued professional development in applicable areas.


  • Demonstrated ability to be self-directed, learn quickly with strong attention to detail.


  • Proven record of excellent leadership, communications, and organization skills.


  • Demonstrated ability to work with computer systems and personal computers.


  • Demonstrated Microsoft Excel intermediate experience is required.


  • Demonstrated Microsoft SQL Server Data Tools (SSDT) experience.




UNIQUE PHYSICAL/MENTAL DEMANDS, ENVIRONMENT, AND WORKING CONDITIONS:Requires the ability to move PC’s and printers weighing up to 40 lbs. Requires planning, organizing and working on multiple tasks at one time. Tolerates ambiguity in instructions and work situations. Provides after-hours support as required.

PERFORMANCE RESPONSIBILITIES:



  • Generic Job Functions: See Generic Job Description for Administrative Partner


  • Unique I.T. Job Functions:


  • Implement physical database objects, manage data, and utilize common development toolsets such as Microsoft SQL Server Data Tools.


  • Demonstrate an understanding of dimensional & relational data architecture approaches to real world problems.


  • Read and understand data models using various methods of notation.


  • Demonstrate technical writing skills and the ability to effectively communicate with customer managers and executives on technical and business issues.


  • Demonstrate strong organization, time management, project management, and negotiation skills.


  • Performance tune moderate to extremely complex queries and data extractions.


  • Develop moderate to complex SQL and T-SQL queries.


  • Develop moderate to complex ETL deliverables in (SSAS, SSIS, and SSMS).


  • Develop moderate to complex Tableau visualizations.


  • Actively participate in software lifecycle special updates/upgrade


  • Provides Manager with a weekly summary of activities.


  • Performs project management work to include: current and proposed information flow, cost/benefit analysis, detailed system specifications, procedure writing, SQL programming and testing.


  • Creates scope statements, defining size and planning parameters of projects or multiple groups of tasks.


  • Prepares detailed work plans and target dates for all projects.


  • Performs work tasks according to work plan and within target dates and times.


  • Tests changes comprehensively so that fixes are minimal; review all work for accuracy before submission.


  • Provides training to VMC and department personnel.


  • Organizes and coaches team members by ability, skills, and knowledge set.


  • Condenses and refines project development files into comprehensive documentation.


  • Provides Manager with a weekly summary of activities.


  • Documents change control and system problems according to departmental procedures.


  • Advises Manager of potential problems, requirements for expanded services and status of current systems on an ongoing basis.


  • Promptly notifies Manager of problems, unexpected tasks and missed targets.


  • Responds to all requests according to departmental standards. Assists in the planning and completion of projects on time and as designed.


  • Provides complete documentation of all tasks and projects; develops and maintains specifications according to departmental standards.


  • Understands relationships between system processes/programs, system parameters, files and data relationships across platforms.


  • Listens to business needs expressed by clients and documents clearly in terms of system capabilities and constraints.


  • Interprets and validates users request and communicates them to correct I.T. staff.


  • Uses standard flowcharting tools and techniques to create and maintain business process and functional flow charts. Is able to read and edit technical flow charts.


  • Creates functional definition and documentation of input, output, and processes in high level of detail.


  • Identifies and manages complex issues to resolution. This includes identifying appropriate parties and potential solutions independently.


  • Troubleshoots, documents and resolves problems, and coordinates vendor support in a timely manner for assigned products independently.


  • Builds complete testing plans to include unit, function and integration testing for complex and/or multiple systems independently.


  • Accesses data from existing systems and produces complex, formatted reports using multiple links, complex computations and output files independently.


  • Maintains software maintenance and report requests through service center tracking system.


  • Ensures that reports, data and devices are appropriately accessed.


  • Maintains the security of the Data Center systems and information, per VMC and departmental Information Privacy Policies.


  • Actively pursues training and knowledge of new technologies, and completes training programs as required.


  • Ability to organize, schedule, manage (chair) meetings and publish meeting minutes.


  • Ability to contact vendor for support and successfully open a trouble ticket with vendor.


  • Ability to complete annual Valley educational requirements.


  • Ability to deliver clear communication to customer base.


  • Performs other duties as required.




Updated: 12/17

Grade: 25, 27 DOE

FLSA: E

#CB


Job Qualifications:

PRE-REQUISITES:



  • Minimum Bachelor’s degree in Information Technology, Computer Science, or related field is required, OR an equivalent combination of education and/or experience.


  • Minimum of seven (7) plus years of progressive IT data services experience, including a minimum of five (5) years of direct development experience in using SQL Server tools (SSAS, SSRS and SSIS).


  • Hands-on experience with SQL Server 2008/2012 database management platform.


  • Hands-on experience with gathering requirements and implementing ETL processes in a Data Warehouse environment.




Certifications/Licenses:

Any certifications related to software applications, technology infrastructure, and/or a clinical specialization is an advantage.

Must be able to obtain Epic certification – if not Epic certified at time of hire, must become certified or have initiated the process of scheduling within 6 months of employment (certification training availability is based on vendor schedule options. Some positions may require multiple certifications.)

GENERAL QUALIFICATIONS:



  • Demonstrated experience in Data Warehouse development.


  • Demonstrated experience creating data visualizations utilizing data visualization tools, Tableau for example.


  • Hands-on experience developing Crystal Reports a plus


  • Hands-on experience with software patching and upgrades


  • XML parsing and manipulation experience a plus


  • Microsoft Windows Server administration and Alteryx Server experience a plus


  • Ability to work independently and in teams with good problem solving, communication, and organizational skills.


  • Demonstrated continued professional development in applicable areas.


  • Demonstrated ability to be self-directed, learn quickly with strong attention to detail.


  • Proven record of excellent leadership, communications, and organization skills.


  • Demonstrated ability to work with computer systems and personal computers.


  • Demonstrated Microsoft Excel intermediate experience is required.


  • Demonstrated Microsoft SQL Server Data Tools (SSDT) experience.






Complete Application

Company info

Valley Medical Center
Website : http://www.valleymed.org

Company Profile

Similar Jobs:
Senior SDE (Full Stack)
Location : Bellevue, WA
Are you the go-to person on your team? Do the hard problems always seem to land on your desk because youre the only one who can solve them? Do you spend more of your time convincing people to let you build what needs to be built t...
Sr Database Administrator - SQL
Location : Seattle, WA
Seattle Washington REPORTS TO Manager, IT Database Platforms ALASKA AIRLINES' STORY Alaska Airlines is one of the most respected names in aviation and flies throughout its namesake state and the Lower 48, as well as to Hawaii, Can...
Technical Support Analyst
Location : Seattle, WA
Job Description An employer is looking for a Technical Support Engineer in Washington DC! The typical duties will include monitoring client applications, infrastructure and networks. Additionally, you will be expected to do proces...
The number of jobs listed on EmploymentCrossing is great. I appreciate the efforts that are taken to ensure the accuracy and validity of all jobs.
Richard S - Baltimore, MD
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
SQLCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
SQLCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 SQLCrossing - All rights reserved. 168