At Houston Methodist, the IT Data Specialist is responsible for supporting an enterprise wide business intelligence and analytics framework that will provide the organization with solutions for effective decision-making. This position utilizes critical thinking, attention to detail, and effective communication skills along with an ability to work collaboratively with teams and to consult with business area leads to generate solution recommendations. The IT Data Specialist communicates effectively with technical and non-technical audiences.
The position utilizes technical expertise in Business Intelligence architecture, design and implementation with experience in business, healthcare and technology projects. The incumbent will be actively involved in supporting, developing and advancing Houston Methodist's Business Intelligence applications. The IT Data Specialist will use tools such as Microsoft SQL Server, Excel, Tableau, Epic Clarity/Caboodle and Epic SlicerDicer to implement innovative approaches to data collection, analysis, interpretation and presentation to support planning and decision-making at all levels of the organization and assist in managing data as a corporate strategic resource.
The IT Data Specialist will support Epic Access/Scheduling and Revenue Cycle Operational Reporting / Tableau dashboards.
PEOPLE ESSENTIAL FUNCTIONS
-
Communicates (oral and written) effectively with customers, vendors, colleagues, and management about services, contact information, system availability, and information
-
Assists the business analyst to elicit requirements to document technical and design specifications, set expectations and coordinate team members utilizing teamwork and collaborative skills
-
Assists with user education of analytics applications and helps ensure access to data with the goal of reduced reliance on technical specialists in order to obtain data
-
Performs development, testing, working on issues and making changes and corrections as needed
SERVICE ESSENTIAL FUNCTIONS
-
Develops Analytics Solutions including data marts, Business Objects, Universe, Oracle, BI, RPD, Tableau data sources, reports and dashboards that support operational and strategic decision making
-
Identifies required source system data and develops ETL processes that move data from source systems into the data warehouse and data marts
-
Participates in managing and resolving major system outages, disaster management and change control and provides technical or on call support for BI applications
-
Installs, configures, and deploys Analytics tools such as Microsoft SQL Server, SAP Business Objects, Oracle ODI, Oracle BI, Tableau, Epic Caboodle and Epic Slicer-Dicer
QUALITY/SAFETY ESSENTIAL FUNCTIONS
-
Ensures all reported data and information are accurate, consistent, relevant and timely
-
Performs required quality and profiling activities on the data and assists with quality assurance of team member's work to ensure information delivered from BI solutions is defect free and of high quality
-
Ensures detailed system test plan execution, provides issue tracking and consolidation. Manages a coordinated User Acceptance Test (UAT) effort.
FINANCE ESSENTIAL FUNCTIONS
-
Practices good time management, good assessment in professional decision making, and management reporting skills to provide problem resolution, technical analyses, costs and resource estimates, work plans, workflow documentation, and progress reports on assigned projects
-
Helps minimize excess cost(s) by assisting and recommending solutions in achieving organizational objectives.
GROWTH/INNOVATION ESSENTIAL FUNCTIONS
-
Proposes solutions to facilitate constructive discussion and fosters an environment that encourages innovation, continuous improvement and growth within the team to arrive at the most optimal solution
-
Uses internal and external resources to stay up to date with new Analytics technologies and trends
This job description is not intended to be all-inclusive; the employee will also perform other reasonably related business/job duties as assigned. Houston Methodist reserves the right to revise job duties and responsibilities as the need arises.
EDUCATION
-
Bachelor's degree in Computer Science, Business Administration, or related discipline with an information technology focus
WORK EXPERIENCE
-
Three years of experience in developing full life cycle BI / data warehousing solutions, using ETL tools such as Microsoft SQL Server Integration Services, Oracle ODI, Informatica, using Analytics tools, such as Business Objects, Oracle BI and Epic Caboodle to design the user access layer for analytics and dashboards.
-
Healthcare Industry experience preferred
LICENSES AND CERTIFICATIONS - REQUIRED
KNOWLEDGE, SKILLS, AND ABILITIES
-
Demonstrates the skills and competencies necessary to safely perform the assigned job, determined through on-going skills, competency assessments, and performance evaluations
-
Sufficient proficiency in speaking, reading, and writing the English language necessary to perform the essential functions of this job, especially with regard to activities impacting patient or employee safety or security
-
Ability to effectively communicate with patients, physicians, family members and co-workers in a manner consistent with a customer service focus and application of positive language principles
-
Intermediate Analytics / Business Intelligence / Data Warehousing systems & architecture experience in 'real world', practical, successful implementations.
-
Knowledge of ETL, Integration Technologies, Data Marts, Reporting Analytics
-
Ability to evaluate, prioritize and problem solve a variety and multiplicity of tasks and ensure their timely and accurate completion.
-
General knowledge of health care operations preferred
-
Demonstrated ability to work independently and take initiative in areas of responsibility.
-
Excellent analytical, organization, prioritization and oral/written communication skills.
-
Knowledge and appreciation of business concepts and requirements as applicable to a large academic, research, and/or healthcare facility.
-
Strong teamwork and interpersonal skills to interact with all management levels.
-
Understands Analytics tool architecture, functions, and features.
-
Strong knowledge of database technologies and data warehouse methodologies including data warehouse design and development
-
Intermediate SQL server based SQL coding and database programming skills
-
Understanding of relational and multi-dimensional database structures and schemas
SUPPLEMENTAL REQUIREMENTS
WORK ATTIRE
Uniform No
Scrubs No
Business professional Yes
Other (department approved) Yes
ON-CALL*
- Note that employees may be required to be on-call during emergencies (ie. DIsaster, Severe Weather Events, etc) regardless of selection below.
TRAVEL**
**Travel specifications may vary by department**
May require travel within the Houston Metropolitan area Yes
May require travel outside Houston Metropolitan area Yes
Company Profile:
Houston Methodist Specialty Physician Group is an integral part of Houston Methodist’s overall strategy to become one of the nation’s leading academic medical centers. Established as a nonprofit corporation certified by the Texas State Board of Medical Examiners, the Specialty Physician Group enables physicians to maintain autonomy with respect to clinical practice while growing their practice within an academic environment.
Houston Methodist is an equal opportunity employer inclusive of women, minorities, disabled persons and veterans.
Equal Employment Opportunity
Houston Methodist is an Equal Opportunity Employer.
Equal employment opportunity is a sound and just concept to which Houston Methodist is firmly bound. Houston Methodist will not engage in discrimination against or harassment of any person employed or seeking employment with Houston Methodist on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, status as a protected veteran or other characteristics protected by law. VEVRAA Federal Contractor – priority referral Protected Veterans requested.