For the given job description <<About Milliman

Independent for over 75 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the worlds most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation.

Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance and financial services, and property and casualty insurance.

Milliman's San Diego Healthcare Technology practice is looking for a Healthcare Analyst to support data warehouse projects, analytical services, claims analysis, and creating client reports. The ideal candidate has strong critical thinking and technical skills to contribute to a variety of projects. The analyst will gain experience using a wide variety of qualitative and quantitative healthcare data to support client needs.

Job Responsibilities

Key responsibilities will include the following:
Work on data loading for data warehouse projectsProvide analytic services, primarily but not exclusively associated with the analysis of healthcare claims dataHelp develop and refine analytic algorithms to analyze claimsConduct analyses for clients and draft reports explaining the resultsConduct projects as determined by clients or consultantsBe able to work independently and but also participate actively as a member of various project teams, fostering the sharing of relevant information and helping to build consensus collaboratively
Experience Desired

The ideal candidate should demonstrate experience using the following skills to design and develop analytical solutions:
2 to 5 Years of Experience and knowledge of healthcare data and analyticsStrong technical capabilities, especially with Microsoft tools and technologies; this includes using Microsoft business analytics tools, and perhaps delivering solutions that include:Microsoft Office componentsExperience with SQLExperience with Azure DatabricksExperience with Microsoft Visual StudioStrong experience with database tools and technologies
Applicants RequirementsQualifications
Strong SQL, Azure Databricks, Visual Studio experienceProficiency with basic statistics and management reportingKnowledge of, and experience with, healthcare claims data and their nomenclatures
Milliman Benefits

At Milliman, we focus on creating an environment that recognizes  and meets  the personal and professional needs of the individual. We offer a competitive benefits package which includes:
Medical, dental and vision coverage for employees and their dependents, including domestic partners A 401(k) plan with matching program, and profit sharing contribution Employee Assistance Program (EAP) A discretionary bonus program Paid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; full-time employees will accrue 15 days of PTO per year, and employees working less than a full-time schedule will accrue PTO at a prorated amount based on hours worked Family building benefits, including adoption and fertility assistance and paid parental leave up to 12 weeks for employees who have worked for Milliman for at least 12 months and have worked at least 1,250 hours in the preceding 12-month period A minimum of 8 paid holidays Milliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disability coverage Flexible spending accounts allow employees to set aside pre-tax dollars to pay for dependent care, transportation, and applicable medical needs 
Location

This position will be based out of the Milliman office in San Diego. Applicants must be willing to work onsite in the Milliman office.

Compensation

The salary range for this role is $62,000 to $99,200, depending on a combination of factors, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, location, etc.

Milliman is an Equal Opportunity Employer

All qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.>> the resume: <<SummaryAmbitious, inquisitive, meticulous, forward
thinking accounting professional with sustained career success at global
executive search firm. Possesses strong analytical and detail oriented thought
process, written and verbal communication skills, is self-motivated, high
energy, dedicated to growing knowledge for career, and a proactive problem solver.
HighlightsGeneral ledger accountingAnalytical reasoningPeopleSoft knowledgeFlexible team playerFinancial statement analysisComplex problem solvingLawson Financials knowledgeEffective time management
EducationDePaul UniversityChicago,ILExpected in2012––Bachelor of Science:Accountancy-GPA:
Professional ExperienceCurrent-Senior AccountantSpartanburg,SC,11/2015-CurrentPerform monthly journal entries and account reconciliations of variable compensation plans.Review and approve staff accountant journal entries and account reconciliations on a monthly basis.Perform monthly analysis of P&L statement, corporate balance sheet, and cash flow statement for all employee compensation line items.Review and discuss variable compensation plans with regional finance controllers.Align all financial activity with the regulations of the GAAP.Assist the CFO on special projects detailing the financial impact of changes to employee variable compensation plans.Collaborate extensively with auditors during preliminary and year-end audit processes.Sunpro-Staff AccountantDecatur,IL,11/2013-11/2015Performed monthly journal entries and account reconciliations of specific employee compensation items.Provided senior accountant with monthly analysis covering fixed compensation and variable compensation plans.Reviewed and discussed fixed and variable compensation costs with regional finance controllers.Delivered monthly schedules to business insights team for budgeting purposes.Worked closely with senior accountant to streamline processes and compensation schedules.Work closely with payroll department and IT department to identify and correct process inefficiencies related to the recording of monthly payroll recording and reconciliation.Completed ad-hoc analysis for senior management as requested relating to fixed and variable compensation plans.Sunpro-Staff AccountantEdwardsville,IL,08/2012-11/2013Perform physical inventory reconciliations involving large
     variances, receiving issues, errors caused by mistakes in inventory counting,
     and document processing issues related to shrink.Investigate out of margin invoice and credit memo exceptions for
     over 130 stores twice a month and perform corrective action when necessary.Assess and correct report of purchase exception issues every month
     for stores who have goods available, ending inventory, or cost of goods
     sold margins outside of the standards set by Follett for the eight
     different departments associated with their product.Review with store managers their inventory issues including those
     caused by a lack of receiving and sale of goods that can lead to issues
     such as negative inventories and misstated financial statement.Reconcile monthly and year-end distribution center inventory
     including processing of markdowns and other prepaid related expense.Proactively ensure issues related to interstore and distribution
     center transfers have processed correctly from merchandise management
     system to the general ledger.Process SKU adjustments, physical acquisition corrections, markup
     and markdowns, receiver adjustments, and return of return adjustments for
     more than 900 stores on a daily basis.
SkillsDeveloped and demonstrated advanced Excel skills in creating new
     compensation files.Exceptional communication skills used in the planning and
     execution of all projects undertaken by the compensation team when working
     with outside departments.Ability to organize, plan, test, and release new Excel models,
     accounting processes, and analytical tools.Effective communication skills and ability to work as a member of
     a team to complete assigned projects in the time frame required by senior
     management.>>. The result is, No Fit

Fit assessment: No Fit