data analyst

Summary:

A Data Analyst collects, organizes, and maintains data, transforming raw information into usable insights for an organization. Key responsibilities include ensuring data integrity, security, and accuracy; developing and managing databases; creating reports and queries; and implementing data storage and transfer systems. They work to make data accessible for decision-making and use their expertise to translate complex findings into clear, actionable information.

Nature and Scope of Job Description:

The duties and responsibilities of this job description have been developed in conjunction with and support of the hospital's mission, vision statements, and facility scope of services.

This job description has excluded the marginal functions of the position that are incidental to the performance of fundamental job duties. This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by their supervisor(s).

Supervisory Responsibilities:

None.

Qualifications:

To perform this job successfully, an individual must be able to perform the functions described in the Job Summary. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree in Information Systems or related field. Experience may substitute for education requirement.
• Experience with popular DBMS like Microsoft SQL Server, MySQL, PostgreSQL, Oracle, or MariaDB
• Experience with ETL processes and ETL tools such as SSIS and scripting for data manipulation
• Two (2) years practical experience working with SQL and relational databases in a professional setting, required.
• Experience with data commonly collected and managed in healthcare organizations preferred
• Proficiency in English

Skills:

• A strong command of SQL, including writing complex queries, stored procedures, functions, and understanding concepts like JOINs, GROUP BY, and subqueries
• Ability to perform database administration functions including installation, configuration, monitoring, maintaining, and improving performance
• Knowledge of ETL processes and use of ETL tools such as SSIS
• Knowledge of, and ability to use SSRS
• Knowledge of, and ability to use Visual Studio
• Self-starter with the ability to manage multiple projects with changing priorities.
• Demonstrates the ability to provide effective and polite customer service to internal and external customers; treats others with dignity and respect
• Understanding how to design and structure databases, including creating tables, indexes, and defining relationships
• Ability to optimize data queries by identifying and resolving performance issues in SQL queries
• Proficiency with data storage systems, database management, and data-oriented programming languages
• Ability to analyze data, identify trends, and solve complex problems
• Capability to troubleshoot database problems and improve existing processes
• Meticulous approach to information verification and data accuracy
• Ability to present findings in a clear and concise manner
• Effective verbal and written communication skills for collaborating and explaining technical concepts

Responsibilities:

• Implement, maintain, and support analytics and visualization applications that transform raw data into meaningful information for analysis and interpretation
• Design, develop and maintain databases, including data dictionaries and models
• Collect, verify, and ensure the accuracy of data from various sources
• Extract meaningful information, interpret data, and generate complex queries and reports
• Configure, maintain and support report and data file distribution
• Manage database backups, recovery procedures, and access control to ensure security and integrity
• Analyze and make recommendations on projects of significant scope requiring advanced analytical judgment
• Configure, monitor, and maintain data storage, especially databases
• Configure, monitor, and maintain data transfers and exchange
• Provide support and training to end users on data models and reporting tools/applications
• Perform regular audits to ensure data integrity and quality.

Physical requirements:

While performing the duties of this job, the employee is regularly required to talk, see, and hear. This position sometimes requires sitting for long periods of time and sometimes requires standing, walking, bending, kneeling, stooping, and crouching. The employee may need to lift and/or move items up to 20 pounds.