This site uses cookies. To find out more, see our Cookies Policy

Data Analyst in Murray, UT at APEX Systems

Date Posted: 5/17/2019

Job Snapshot

Job Description

Job #:  971431
Job Description
This position focuses the majority of their time producing analytical solutions (reports, dashboards, tools, etc.) for leadership and stakeholders across the organization that supports business or clinical initiatives. This position provides consultation and support in the development, analysis, interpretation, and management of a variety of highly complex data sources to support process improvement, operations, strategy, cost reduction, and increased patient safety and satisfaction.
Essential Job Duties
This position is responsible for providing analytical support - typically at a system-wide level. May work as part of a system-wide team or interact with stakeholders across the system. Typically this position performs analysis on highly complex projects under general supervision. This position works with data sources serving the needs of customers in one or more business areas:

•     Population Health Management / Decision Support: Population health management analytics (PHMA) supports the development, implementation, and measurement of systems of care that assess the health needs of a target population and proactively provides and coordinates services to improve the health of that population. PHMA provides support for the following functions: integration of population health data, value improvement, standard quality service and cost metrics and measurement, risk scoring and severity adjustment, attribution methods, contract analysis, and new data source insight. PHMA utilizes data from across the healthcare system and across the continuum, including hospital, physician, and claims data.
Core Essentials:

•     1. Creates reports that answer multiple related questions as well as reports with linked content, drilldown, and nested parameters. The report is formatted in such a way that leads the user through the report in a well-organized, easy to understand fashion.

•     2. Writes more advanced SQL including some query tuning and complex joins (e.g., outer joins on multiple tables). Uses sub-queries and the With Statement as well as more complex functions (e.g., Substr, To_Date, date calculations, etc.).

•     3. Assists in the identification of data quality (accuracy, completeness, etc.) issues. Assists with the process of database design for assigned projects. As appropriate, trains other individuals and teams in the routine use of data collection, analysis, and reporting and interpretation tools for measuring performance.

•     4. Demonstrates an understanding of Primary / Foreign Keys, Table / Field Aliases, and Partitions / Indexes to produce high quality material.

•     5. Provides project management / project leadership as appropriate to drive timelines and deliverables.

•     6. Trains others on skills and competencies required for previous levels of Data Analyst.
Additional Essentials:

•     1. Collaborates with corporate and region resources to design, create, test, and implement analytic tools (databases, reports, web applications, dashboards, etc.) that support enterprise / region needs and to improve data collection and reporting strategies (minimize duplication, redundancy, etc.).

•     2. Demonstrates high level SQL and data extraction skills (i.e., Uses pre-defined scripts, changes parameters, GUI query (e.g., MS Access, tools with drag-drop query creation capability, and Excel cubes).

•     3. Uses standard Intermountain Reporting tools to generate reports for end users that interpret data for others to promote evidence-based decision making.

•     4. Possesses a fundamental understanding of the domain's data and associated data models and uses it to produce high quality material.

•     5. Compares data output to ensure data accuracy. Creates basic QA test plans and validates data for accuracy.

•     6. Responsible to document work / projects per enterprise-wide standards (reports, project tracking, databases, etc.).

•     7. Understands the appropriate use of indexes, partitions, ability to understand Entity Relationship Diagrams.

•     8. Uses / analyzes Intermountain data sources (EDW, ORMIS, AS400, Essbase, Risk Management, etc.) to meet local and enterprise needs.

•     9. Provides consultation, data analysis and project management for clinical and business stakeholders across the organization. Communicates technical / analytical concepts to others.

•     10. Shares important and relevant information with the team. Proactively offers suggestions, provides resources, volunteers for assignments, and removes barriers to help the team accomplish its goals.

•     11. Contributes to Intermountain's analyst community by participating in monthly analyst community events such as ASK (Analysts Seeking Knowledge) through presenting, teaching, and mentoring.
Minimum Requirements (Senior level) 

•     Master's Degree and three years of analytics experience or Bachelor's Degree with five years of analytics experience. Degree must be obtained through an accredited institution. Education is verified

•     Experience demonstrating a working knowledge of SQL (structured query language), quality improvement principles, and a fundamental knowledge of database design principles.

•     Experience demonstrating success in the development, analysis, interpretation, and management of a variety of complex data sources to include all facets of decision support/financial reporting.

•     Experience using word processing, spreadsheet, database, internet and e-mail, and scheduling applications.

•     Experience in a role requiring effective verbal, written, and interpersonal communication skills.

•     Experience with the industry standard BI or analytical tools and technologies.
Physical Requirements

•     Interact with others requiring the employee to verbally communicate information.

•     Operate computers and other IT equipment requiring the ability to move fingers and hands.

•     See and read computer monitors and documents

•     Remain sitting or standing for long periods of time to perform work on a computer, telephone, or other equipment.
Preferred Requirements

•     Degree in an analytics-related field such as statistics, mathematics, information systems, computer science, finance, economics, or an MBA with an emphasis in analytics.

•     If degree is not in an analytics related field seven years of analytics experience demonstrating proficiency performing the job essentials at this job level.

•     Proficiency using statistical methods and tools.

•     Proficiency using programming languages and tools.

•     Experience presenting to a variety of audiences and coaching leaders, customers and peers on data analysis best practices, trends, tools, and techniques.

•     Strong experience with SQL query tuning.

•     General experience in healthcare or subject matter expertise in the job area (such as Actuarial, Clinical Programs, Clinical Services, Compliance, Finance/Accounting, Human Resources, Management Engineering, Quality, Revenue Cycle, Select Health / Insurance, Strategic Planning, Costing, Chargemaster, Budgeting, etc.).

•     Population Health Experience
EEO Employer
Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178-6178.