What are the responsibilities and job description for the Finance & Analytics Analyst (Adv SQL & Excel Required) position at Lensa?
Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for Molina Healthcare. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.
Job Description
Job Summary
Designs and implements processes and solutions associated with a wide variety of data sets used for data/text mining, analysis, modeling, and predicting to enable informed business decisions. Gains insight into key business problems and deliverables by applying statistical analysis techniques to examine structured and unstructured data from multiple disparate sources. Collaborates across departments and with customers to define requirements and understand business problems. Uses advanced Excel, SQL querying, and reporting methods to develop solutions.
Job Duties
REQUIRED EDUCATION:
Associate’s degree or equivalent combination of education and experience
Required Experience
Bachelor’s degree or equivalent combination of education and experience
Preferred Experience
2 – 4 years related experience
Physical Demands
Working environment is generally favorable and lighting and temperature are adequate. Work is generally performed in an office environment in which there is only minimal exposure to unpleasant and/or hazardous working conditions. Must have the ability to sit for long periods. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function.
To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.
Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.
Pay Range: $80,168 - $128,519 / ANNUAL
Job Description
Job Summary
Designs and implements processes and solutions associated with a wide variety of data sets used for data/text mining, analysis, modeling, and predicting to enable informed business decisions. Gains insight into key business problems and deliverables by applying statistical analysis techniques to examine structured and unstructured data from multiple disparate sources. Collaborates across departments and with customers to define requirements and understand business problems. Uses advanced Excel, SQL querying, and reporting methods to develop solutions.
Job Duties
- Extracts and compiles information from large data sets from various systems to identify and analyze outliers.
- Provide quantitative and qualitative data analysis in the reporting of patterns, insights, and trends to decision-makers.
- Works with internal, external and enterprise clients as needed to research, develop, and document new standard reports or processes.
- Implements and uses analytics software and systems to support department goals.
- Tracks trends related to various feeds, with focus on membership, revenue, and commissions.
- Identify any deficiencies within the process, strategize and design improvements where possible.
REQUIRED EDUCATION:
Associate’s degree or equivalent combination of education and experience
Required Experience
- 1-3 years related experience
- Proficiency in MS SQL queries and database development.
- Proficient in MS Office Suite products, key skills in Excel (VLOOKUPs and pivots).
- Intermediate proficiency with complex SQL queries, and stored procedures.
- Strong critical thinking and attention to detail.
- Ability to effectively communicate with technical and non-technical stakeholders.
- Strong time management skills to manage simultaneous projects and tasks to meet internal deadlines
Bachelor’s degree or equivalent combination of education and experience
Preferred Experience
2 – 4 years related experience
Physical Demands
Working environment is generally favorable and lighting and temperature are adequate. Work is generally performed in an office environment in which there is only minimal exposure to unpleasant and/or hazardous working conditions. Must have the ability to sit for long periods. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function.
To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.
Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.
Pay Range: $80,168 - $128,519 / ANNUAL
- Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.
Salary : $80,168 - $128,519