IT Data Specialist

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, SAP Business Objects, Oracle ODI, Oracle BI, Tableau, Epic 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

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

• N/A

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._

• On Call* Yes

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 Academic Institute oversees the Education Institute and Research Institute, including 772 faculty and 56,250 learners. The Academic Institute aligns our research and education initiatives in service to the clinical mission, providing solutions that answer the call for new technologies and skills our clinicians need for patient care.

Houston Methodist Education Institute coordinates our primary academic affiliation with Weill Cornell Medicine and other joint programs, including the Engineering Medicine Program at Texas A&M University Intercollegiate School of Engineering Medicine. The Education Institute also oversees continuing medical education and graduate medical education, and supports more than 1,000 trainees in residence for medical, nursing, allied health and research education programs.

Houston Methodist Research Institute supports research programs and infrastructure that enable faculty across the system to bring new scientific discoveries to patients as rapidly as possible through the full cycle of a cure from conceptual bench research, to prototyping and development, to clinical trials and FDA approval. The Research Institute supports more than 1,387 clinical research protocols and $70.3 million in extramurally funded translational research programs.

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.

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.