Posted: Thursday, February 1, 2018 7:50 PM
Company:Hawaii Medical Service Assn.Job Title:Advanced Data Analyst IExempt or Non-Exempt:ExemptIsland:OahuCity:HonoluluLocation:HonoluluEmployment Type:Full TimeJob Summary:Works independently with internal and external customers to clearly articulate and define business problem(s) to be solved; reviews data sources and preps needed data; performs required analysis; applies accepted statistical methodologies where applicable; documents the process that was followed and data sources/tools used; ensures results have been validated (statistically, if necessary); and prepares/presents findings that are informative and audience appropriate to drive decision making across various levels of the organization.Duties and Responsibilities:Data Management: Reviews data sources and preps needed dataIdentifies existing and new data sourcesPerforms data prototyping, if necessary, to agree what data can/not be usedPreps data for use in analysis, goes back to source if problems are found, and identifies other options/alternatives if problems cannot be resolvedPerforms review of data to ensure completeness/accuracy/timeliness for the purpose of the analysisEnsures existing, approved, corporate tools used can accept/integrate the dataWhere necessary (and if practical to be done within the delivery timeframe of a project), facilitates the identification and use of new tools and works with the Technical Review Committee to authorize its useAnalytics and Technical Acumen : Performs required analysis, applies accepted statistical methodologies where applicable, and documents the process that was followed and data sources/tools usedDetermines what kind of analytics will be performed (descriptive, predictive, prescriptive) and defines/documents overall framework.Where appropriate, applies linear regression (correlation, contingency table, ANOVA, inference, chi-square, t-test) and/or time series methods (data set-up, conversions, trends, decomposition, models, forecasts, confidence).Utilizes appropriate tools to load, integrate, and analyze dataConducts analysis and documents findings, identifies unexpected anomalies and root cause (if possible) and determines if analysis can continue, identifies alternatives if anomalies cannot be resolvedEnsures reproducibility of outcomesDocuments entire analysis process, including business problem, data sources, methods and tools used, project reference, and outcomesImplements pre-emptive actions, where possible.Project Definition and Coordination: Lead meetings with internal and external customers to clearly articulate and define business problem(s) of medium/high complexity and impact (department/function specific, external customer centric, or part of a corporate project)Types of projects include descriptive and predictive analyticsApplies a whole company perspective, draws upon previous knowledge and experience, and where necessary researches new/other approaches to identify and agree upon objectives, approach, and success measuresWorks with customer to submit appropriate paperwork (ISS, TPDR, etc.) and ensures necessary agreements are in place for external customersDefines delivery milestones and negotiates timeframes, monitors progress, and periodically notifies customer of statusEffective Communication: Works primarily with department heads or function leads to prepare/present findings that are informative and audience appropriateReviews findings and outcomes with customer, ensures business problem/objectives have been met, and prepares documentation of the analysisWhere necessary, manage divergent views in the audience and advises the internal/external customer on any recommendations or options that will facilitate data and analysis driven decision making.Prepares a presentation of the analysis, process followed, and reviews it with the customer to ensure the results are audience appropriate.Other duties/functions:Trains others on Microstrategy and ExcelFunctions as a team player within the department and embodies collaborationPerforms other duties as assigned.Minimum Qualifications:Bachelor s degree and four years of demonstrated analytics experience or equivalent combination of education and related work experience.Proficiency in Microsoft Word, Excel, PowerPoint and Outlook.Proficiency with Online Analytical Processing (OLAP) tools and databases.Knowledge of one or more of the following: SQL, R or SAS.Demonstrated understanding of data (types, content reliability, etc.).Demonstrated problem solving and data collection, analysis, and interpretation.Demonstrated understanding/use of dashboards, data visualization tools, and advanced and custom graphics.Demonstrated organization and time management skills where individual worked on multiple projects simultaneously and meet project deadlines.
• Location: Honolulu, Honolulu (Oahu)
• Post ID: 9922982 honolulu