POSITION TITLE: ITS Data Analyst
DEPARTMENT: ITS Analytics Services
FLSA STATUS: Exempt
REPORTS TO: Manager, Analytics Services
EVALUATION DATE: 09/2012
The incumbent in this position is responsible for the data integrity of San Francisco Health Plan’s Enterprise Data Warehouse (EDW) by performing regular audits of data in the core system along with audits of the data sources going into and out of EDW. The ITS Data Analyst will perform overall data analysis to ensure the highest data quality is collected and stored in EDW and work closely with colleagues to resolve identified data integrity issues.
ESSENTIAL DUTIES & RESPONSIBILITIES
Perform problem investigation, evaluation and recommendations of claims/encounter files by trading partners
Work closely with colleagues to identify data related problems and solve discrepancies or data integrity issues.
Perform overall data analysis of inbound data into EDW, including provider, members and claims/encounters for various data sources; i.e. files, SFHP transaction systems including but not limited to SFHP’s managed health care system, QNXT.
Assist in data analysis in support of prototyping canned/scheduled reports/extracts
Perform ad hoc analysis on health care operations data including QNXT and EDW
Solves moderately complex problems and/or conducts moderately complex analyses
Work with business owners and IT resources to define data and document mapping rules
Proactively monitor source system changes for data impacts and communicate resulting data warehouse modifications
Work with ETL Developers to build or enhance data loads & extracts
Serve as QA resource as needed on projects pertaining to data flowing into and out of EDW
Build analysis and monitoring processes as needed
Assist with documenting requirements for improved automation as needed
Communicate data enhancement needs with management, ETL developers and report developers
Performs other related duties and special projects as assigned
INDIVIDUAL CONTRIBUTOR EXPECTATIONS
Understands and supports the SFHP mission and its overarching business goals and objectives.
Acts with integrity, honesty and fairness, remaining mindful of the duty of trust SFHP has to it employees, and to its providers, employers and members.
Accepts and adapts to changes in SFHP policy, practice, procedures quickly and positively and proactively supports his/her colleagues in adapting to changes in the workplace.
Contributes actively and effectively to team discussions, sharing his/her knowledge and expertise willingly and collaboratively.
Implements, monitors, utilizes, supports and communicates agreed upon departmental performance competencies metrics.
Identifies business process improvements that are aligned with and supportive of SFHP business goals and objectives. Provides thoughtful analyses and recommendations.
Models professional behavior/conduct that remains in concert with the SFHP culture and business values.
CORE COMPETENCIES / KNOWLEDGE & SKILL REQUIREMENTS
Strong analytical skills and problem solving skills with the ability to formulate and communicate recommendations for improvement.
Strong SQL and MS Excel skills to support data analysis on a daily basis
Familiarity with process design and documentation methodologies, and design and production of quality deliverables, process and use case modeling, business case development.
Understanding of information systems, business processes, the key drivers and/or measures of success for the healthcare industry, particularly the Payor market, managed care and State-sponsored programs
Ability to produce accurate and precise work, detect discrepancies and resolve discrepancies all while meeting deadlines.
Ability to work effectively, independently, and as part of a team.
Strong organization, time management and multi-tasking abilities.
EDUCATION, EXPERIENCE & TRAINING REQUIRED
A degree from a four-year college (e. g., BS), which may be substituted with equivalent work experience
Prior experience at a healthcare organization, particularly at a managed health plan
Minimum 3 years of experience as a Data Analyst in a healthcare environment using SQL
COMMUNICATION & INTERPERSONAL SKILLS
Ability to analyze, evaluate and clearly present written information and findings.
Ability to clearly and concisely communicate health care concepts and technical information to management personnel.
Ability to interact well with co-workers and outside contacts.
All levels of company staff
State & Other Regulatory Agencies
ESSENTIAL FUNCTIONS – PHYSICAL POSITION REQUIREMENTS; MACHINES AND/OR EQUIPMENT USED
PC literacy required; MSOffice skills (Outlook, Word, Excel, PowerPoint)
Regularly required to operate standard office equipment (personal computer, photocopy machine, fax machine, etc.)
Ability to work on a computer up to 7 hours a day.
Regularly required to sit for long periods of time, and occasionally stand and walk.
Regularly required to use hands to operate computer and other office equipment.
Close vision required for computer usage.
Occasionally required to stoop, kneel, climb and lift up to 25 pounds.
Standard office environment without unpleasant or hazardous conditions. Work entails typical physical demands involved in office work. May require occasional weekend and/or evening work.
NOTE: This description is not intended to be construed as an exhaustive list of duties, responsibilities or requirements for the position. This position may change or assume additional duties at any time. The employee may be requested to perform different or additional duties as assigned.
San Francisco Health Plan - 14 months ago