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
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 REQUIREMENTSWORK ATTIRE
Uniform No
Scrubs No
Business professional Yes
Other (department approved) Yes
ON-CALLNote that employees may be required to be on-call during emergencies (ie. DIsaster, Severe Weather Events, etc) regardless of selection below.
On Call Yes
TRAVELTravel 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 OpportunityHouston 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.
