The Data Analyst II uses their technical skills and training to extract data from core application libraries for the purposes of creating and manipulating complex spreadsheets and formulas, discovery of patterns and relationships, creation of summarized reports for senior management. These reports are used to assess business events and trends, as interpreted from health care clinical data and corporate financial data. Candidates must have a strong mathematical ability and a passion for analytical work. Under the direction of the Chief Financial Officer, the Data Analyst serves as a decision support specialist for projects relating to practice workflow improvement, enhancements to quality outcomes for patient services, and the proper use of professional resources to meet the organizational objectives.
Prepare and maintain all documentation needed for due diligence, projects, etc.
Organize a methodology to auto-generate stating reports and to quickly respond to prioritized information requests.
Performs other duties as assigned
TYPICAL PHYSICAL DEMANDS:
Ability to operate a keyboard, sit for long periods of time, bend, squat and reach occasionally. Requires manual and finger dexterity and eye-hand coordination. Occasionally lifts and carries items weighing up to 25 pounds. Vision must be correctable to 20/40 and hearing must be in the normal range for telephone contacts. Frequent public contact; constant decision-making, concentration; ability to work independently.
Bachelors degree with a major in Mathematics, Statistics, Economics, Finance or Computer Sciences, and at least 3 years of experience in scientific or enterprise data analytics. Examples are: real estate analysis with an investment group or fund, investment trust asset valuation, banking or insurance risk/actuarial studies, or data analysis for hospital, public health or advocacy institutions.
Expert or very advanced Excel skills level.
Expert or very advanced SQL report composition skills
Expert or very advanced skills with Oracle Discoverer or other ad hoc querying tools
Advanced data analysis (“mining”), data modeling, and financial modeling skills, using 4th dimension, interdisciplinary modeling dynamics.
Excellent professional presentation and written communication skills.
Experience developing pitch book, business plans, and/or cash flow models is preferred
Experience with healthcare (medical or surgical) data analysis is preferred
Knowledge, Skills and Abilities
Knowledge of principles and practices of organization, administration, and personnel management
Knowledge of statistical methods and methods of graphic presentation
Knowledge of modern office procedures, methods and computer equipment
Knowledge of principles and procedures of financial record keeping and reporting
Knowledge of technical report writing procedures
Ability to analyze facts and make sound recommendations
Ability to work with and control sensitive, confidential information
Advanced skills in using computer and calculator
Skill in identifying problems and recommending solutions
Ability to exercise initiative, judgment and decision-making
Ability to express oneself clearly and concisely both orally and in writing
Ability to prepare comprehensive statistical and narrative reports
TYPICAL WORKING CONDITIONS:
Most daily tasks are performed in the corporate headquarters business office. This employee may be required to attend meetings and conferences away from the main office, at other CMC sites and elsewhere.
Additional Salary Information: Depends on experience and qualifications
Internal Number: DAII
About Community Medical Centers, Inc.
Community Medical Centers, Inc. (CMC) began in the 1960's as a volunteer effort of the San Joaquin Medical Society, the San Joaquin Local Health District and the Community Action Council. Local physicians, nurses, dentists and community activists who recognized the lack of health and social services programs formed service teams to address the needs of migrant farm workers and their families. The providers went out to the fields and worked from their cars to deliver medical care, to supply food and clothing and to link families with available services. In 1967, the San Joaquin Medical Society received state and federal funding to support the development of two small facilities, as well as mobile clinics to provide services throughout the county. From these early beginnings, CMC has grown to provide comprehensive primary and preventive care at eleven clinical sites in the counties of San Joaquin, Solano, and Yolo.