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: <<Experience10/2019to06/2019Data AnalystAngi Homeservices Inc.–Rockledge,FL,Built an end to end analytics-based solution for animal shelters to verify optimality of current capacity, with a vision to deliver recommendations to improve animal outcomes and health in the future.Created a cloud-based (AWS/Flask/HTML) UI to source animal shelter data & present optimal solution.Utilized Delphi method to generate synthetic data (for missing values) using information from animal experts.Leveraged SQL/Python to pre-process and optimize animal shelter data.Dealt with a tricky client, with unclear outcomes (and impacted by COVID-19 times) - yet delivered a complete, extendable analytics/ UI solution.Predicted the outcome of animals with 73% accuracy, based on characteristics of the animals at the time of intake.01/2019to06/2019AnalystAmeresco–Half Moon Bay,,INDTraders of import export licenses in India, Operationalized and negotiated the prices/rate of various MEIS/SEIS by predicting the price of the MEIS/SEIS licenses using Time-series analysis and supervised machine learning model, resulting in savings of INR 1,000,000.Created a new billing system from scratch to increase efficiency and reduce time spent in creating bills using Excel, VLOOKUP, HLOOKUP and Formulas, which resulted in time spent in creating bills reducing by 50.06/2018to09/2018Analyst InternSpencer Stuart–Chicago,,INDAlthough junior, quickly earned responsibility for creation of data architecture & automation for BSE's Mutual Funds.Processed 1 million+ weekly transactions to enable audits, executive reporting - Presented to CXOs weekly.
EducationExpected inJuly 2018totoBachelor of Engineering:Information TechnologyUniversity of Mumbai, Vidyalankar Institute of Technology-Mumbai,GPA:Expected inJunetotoMaster of Science:Business AnalyticsUniversity of California-San Francisco,CAGPA:
SummaryA motivated data enthusiast with 5+ years of SQL and data analysis experience, 3+ years of Object-Oriented Programming experience and 2+ years of Python and R experience. Self-taught Machine Learning and Big Data and applied to various settings by taking 3 Coursera Courses, 3 Udacity Courses, 2 Udemy Courses and am an AWS Certified Cloud Practitioner. Motivated to make a difference and hence currently analyzing publicly available animal shelter data.
HighlightsTools: SQL, Python, Jupyter Notebook, Flask, R, Tableau, Spark, MongoDB, Excel, HTML, MapReduceSkills: A/B Testing, Data Analysis, Database Management, Data Mining, Data Visualization, Hypothesis Testing, Modeling, Machine Learning, Statistical Analysis, DashboardsAutomationBilling systemClientData AnalysisData MiningData VisualizationDatabase ManagementDelphiFundsHTMLMachine LearningExcelModelingMongoDBPythonReportingSQLStatistical AnalysisTableauVision
SkillsTools: SQL, Python, Jupyter Notebook, Flask, R, Tableau, Spark, MongoDB, Excel, HTML, MapReduceSkills: A/B Testing, Data Analysis, Database Management, Data Mining, Data Visualization, Hypothesis Testing, Modeling, Machine Learning, Statistical Analysis, Dashboards,Automation, billing system, client, Data Analysis, Data Mining, Data Visualization, Database Management, Delphi, Funds, HTML, Machine Learning, Excel, Modeling, MongoDB, Python, reporting, SQL, Statistical Analysis, Tableau, vision>>. The result is, No Fit

Fit assessment: No Fit