IT Data Specialist- Finance/ Reporting (Telecommute- Must live within Houston area)

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.