Information Technology Data Analyst Lead - Health Outcomes

The Information Technology Data Analyst Lead is responsible conducting full lifecycle analysis to include requirements, design, documentation, testing and validation to support the implementation of data and analytics solutions. Data Analyst must have expertise in methodology, design, specifications, programming, delivery, monitoring, and support standards leading to development of data and analytics solutions. SQL querying experience in a range of databases such as transactional, analytical, columnar and massively parallel processing is required. Experience in data mining using advanced SQL or Business Intelligence tools is required., * Meets expectations of the applicable OneCHRISTUS Competencies: Leader of Self, Leader of Others, or Leader of Leaders.

• The ability to work on multiple projects/tasks simultaneously to meet project deadlines for self and others as required.
• Functions as a database administrator for any of the following: Care Discovery, Care Discovery Quality Measures, Midas, and other databases as identified for the Quality Department. Monitors integrity of the interface daily, corrects problems as they are identified, writes reports as requested, and maintains knowledge of the system. Functions as a resource of the database functions for other hospital staff.
• Maintains system interfaces for supported applications to ensure the accuracy of data submission. Maintains and updates related database applications used for routine and ad-hoc internal and external reporting.
• Design, implement, and analyze databases for tracking and trending organizational quality metrics and infection prevention data for quality improvement across the organization.
• Enters data into databases for targeted populations and then uses this database to generate reports as needed.
• Communicates effectively across the organization as required to prepare analysis, interpret data, and evaluate statistical information for quality improvement.
• Collaborates with internal department management and staff as appropriate to develop new data collection processes as needed using various file formats and reports.
• Maintain the Texas Healthcare Information Collection (THCIC) database, providing error analysis, approval, and timely submission and certification of data sets.
• Serves as knowledge expert for Excel, PowerPoint, Access, and other software used for project management.

• Must have communication skills and the ability to develop and present solutions to all levels of management (including executive levels).
• Must have demonstrated the ability to solve complex problems.
• Must have demonstrated the ability to give direction to other technical resources in accomplishing shared objectives.
• Must have the ability to work on multiple projects/tasks simultaneously to meet project deadlines for self and others as required.
• Must have a solid understanding of the Business Intelligence and analytics landscape, preferably in large-scale development environments., * Bachelor?s degree in Information Systems, Computer Science, Engineering, Math, or related field is required.
• Master?s degree in Information Systems, Computer Science, Engineering, Math, or related field is preferred.
• An advanced level of SQL programming for data analysis is required.
• An advanced level of SQL programming for data consumption is required.
• Data analysis with large datasets on Big Data Databases (such as Hadoop/Hive/Impala) is required.

Experience

• A minimum 12 years of experience in SQL programming in platforms with large data assets within an OLTP, OLAP, and MPP architecture.
• A minimum 12 years of experience with writing and debugging complex SQL queries.
• A minimum 12 years of IT experience in technical analysis or design and implementation.
• 8 years of experience with large datasets on ODS or Datawarehouse systems (such as MS SQL Server, Postgres SQL, Hadoop/Hive/Impala).
• 8 years of Healthcare IT experience preferred.
• Experience in integrating and cleansing data from source systems is preferred.
• Experience using BI Tools (i.e., Power BI, IBM Cognos, Tableau, Looker, MicroStrategy) is preferred.

Licenses, Registrations, or Certifications

• Certifications in SQL, BI Tools, SAS, Hadoop, or Agile Scrum are a plus.