Department: AdministrationPosition: Data AnalystEmployee Category: Exempt Reporting Relationship: Manager of Data AnalyticsCharacter First Qualities:Dependability- Fulfilling what I consented to do, even if it means unexpected sacrifice.Determination- Purposing to accomplish right goals at the right time, regardless of the opposition. Endurance- The inward strength to withstand stress and do my best.Discernment Understanding the deeper reasons why things happenResponsibility- Knowing and doing what is expected of me. Summary of Duties and Responsibilities:Provide business intelligence (BI) analytics and reporting solutions, working closely with the business to understand needs and using existing BI environment, design, develop, and validate assumptions before delivering results to support the business requests for ad-hoc and scheduled reporting.
Primary Duties and Responsibilities:1.Uses formal business intelligence tools to answer business and clinical analytical needs.Uses formal business intelligence tools to answer Claim processing and billing needs.Creates KPIs and Monthly Reports to help Billing Identify potential Gaps in the Claims Payment ProcessUnderstand business objectives, questions and problems directly from the business stakeholders and/or in conjunction with the departments and business units within Variety Care. Combines financial, operational and clinical data to address issues or requests from the departments within Variety Care or the leadership team. Interfaces directly with management and staff (as clients). Assigned projects are expected to be completed by the individual from start to finish (data gathering and manipulation, overall analytical assessment, project documentation, communication packaging, and presentation of results).Creates data results through techniques and tools that range from basic queries to multidimensional analyses and data mining. Uses queries to extract data in order to develop models, reporting to external entities or for ensuring data integrity.Derives new data relationships or formulate new calculations as necessary. Based on reporting requirements, extracts valid information content from datasets. Analyzes business information requirements and convert this knowledge into data requirements documents, analyses and resulting actionable information. Works with production data to validate how business requirements map to the data environment. Discovers, validates and presents dimensional hierarchy relationships in production data. Develops the necessary reports, analyses and recommendations as directed. Documents and implements a support plan for any created analytical work products. Assists users in finding the right information required to answer their questions. Ability and willingness to learn new tools and techniques as they are adopted by the organization.Supports Variety Cares accreditation as a Patient Centered Medical Home and our commitment to provide care to all Variety patients that is Safe, Effective, Patient Centered, Timely, Efficient, and Equitable. Provide leadership and work with all staff to achieve the goals of the Triple Aim of healthcare reformto improve the experience of care, improve health outcomes, and decrease healthcare costs.Embodies the strength of personal character. Places value on being an open and honest communicator who displays high moral and ethical conduct, integrity, adaptability, and sound judgment. Must be a leader in the department and community. Result-oriented problem solver who is responsible and accountable.Performs other duties as assigned.
Requirements, Special Skills or Knowledge: Three years of relevant work experience.Two years of experience using enterprise business intelligence solutions such as IBM Cognos or SQL Server Reporting Services.Preferred Requirements, Special Skills or Knowledge:Experience working with healthcare claims/billing Process.College graduate or equivalent professional consulting experience.ADA Requirements:Must be able to lift 25 pounds.Specific vision abilities: close vision, distance vision and ability to adjust focusFrequent walking and reaching with hands and arms