Data Analyst I

Farmers Insurance Company - Minnesota Woodland Hills , CA 91367

Posted 6 months ago

Job Description:

We are Farmers!

Join a team of diverse professionals at Farmers to acquire skills on the job and apply your learned knowledge to future roles at Farmers. Farmers Insurance also offers extensive training opportunities through the award winning University of Farmers named by Training magazine amongst top 10 corporate training units in the world. Start your career at Farmers today!

Job Summary

Reconcile data after data loads into the personal lines data marts. Analyze the root causes of data variances. Communicate the results to the business stakeholders to obtain the release of the new data in the data marts. Analyze the system changes to automated scripts & reconciliation tableau reports and make the necessary changes.

Essential Job Functions

  • Extract data using Business Objects or similar business query interfaces.

  • Extract data directly from relational databases (e.g. DB2, SQL Server), data warehouses, or other data stores using SQL or SAS.

  • Format data for business use in Excel, Access, or similar format.

  • Reconcile data in the target to the sources and analyze the root causes of the data variances.

  • Produce reports manually and through automated scripting and Tableau.

  • Create and maintain scripts and macros used to automate reports.

  • Support application testing for enhancements or system upgrades.

  • Identify and communicate data quality issues or data differences.

  • Communicate effectively. Be concise and precise in written communication.

  • Demonstrate business understanding.

  • Develop in-depth knowledge of data associated with at least one line of business (LOB), and effectively support the data needs of that LOB.

  • Demonstrate commitment to lifelong learning.

  • Exemplify good teamwork.

  • Proactively communicate with customers and team members.

  • Provide excellent customer service by making realistic commitments and keeping them.

  • Work productively on assigned tasks.

  • Collaborate effectively with other team members.

  • Demonstrate accountability to management and customers for hours spent on assigned tasks.

  • Diligently strive to deliver value in the fewest possible hours.

Physical Actions: Essentially sedentary work consisting of occasional walking, standing, and lifting/carrying 10 lbs. maximum. Functional ability of seeing, hearing and speaking. Ability to type proficiently.

Physical Environment: Work in a climate-controlled office, with occasional travel by car or airplane

Education Requirements:
High school diploma or equivalent required. Bachelor's degree preferred, in Information Systems or related field.

Experience Requirements:
2+ years experience with data extraction, analysis, manipulation, reconciliation and presentation in usable format, Farmers or other insurance experience is preferred.

Special Skill Requirement

  • MS Excel: advanced proficiency (Pivot Tables, Pivot Charts, AutoFilter, and formulas).

  • BI query tools: proficient in Business Objects or similar systems.

  • SQL: proficient with queries involving a few tables.

  • Tableau experience is preferred.

  • SAS knowledge will be a plus.

Farmers is an equal opportunity employer, committed to the strength of a diverse workforce.


Schedule: Full-time

Job Posting: 05/15/2019

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Associate Business Data Analyst Woodland Hills CA

Unitedhealth Group Inc.

Posted 1 week ago

VIEW JOBS 10/16/2019 12:00:00 AM 2020-01-14T00:00 Optum360, a UnitedHealth Group company, exists to transform today's revenue cycle and modernize the business of health care - through health information, skilled services and innovative technologies. We are advancing the entire revenue cycle by aligning payers, providers and consumers. Strategically situated in the center of the cycle, we are uniquely positioned to identify and seize opportunities that drive positive financial performance for all stakeholders. Our technologies and methodologies are the industry's most advanced, and our people are the industry's most proficient. We are working to create a future so seamlessly interconnected that no claim is ever denied. We serve health care providers, including health systems, hospitals and physician practices. In addition to managing revenue services end-to-end for clients, we also have thousands of customers using our content, technologies or a specific service to improve their revenue management performance and increase patient satisfaction. We work closely with payers, bringing more transparency and efficiency to the revenue cycle for the benefit of our clients and ultimately, consumers. This is a place like no other and where you'll do your life's best work.(sm) We are seeking an Associate Business Data Analyst to conduct and document moderate to complex data analysis projects. You will also responsible for planning and implementing projects that drive efficiency and quality within the Revenue Services department. The ideal candidate must be able to manipulate, analyze, and interpret data using MS Excel and other tools (MS Access, SQL and VBA), and then be able to provide answers to business questions and billing issues found through analyzing the data. This team is based in our Woodland Hills, CA location. Primary Responsibilities * Manipulate, analyze, and interpret large amounts of data using Access, Excel, SQL, and VBA * Automate processes and reports * Recognize inefficiencies in processes (operational or technical) * Design solutions to address billing issues * Pull ad hoc reports from various billing systems * Perform data validation to ensure accuracy and quality * Data mining for advanced analysis of data presented in reports for management * Analyze insurance medical billing denials to identify trends * Recommend solutions to decrease bad debt and increase cash for receivables from laboratory tests * Assist Billing department in the resolution of billing issues * Provide feedback to Senior Management regarding contractual issues impacting Revenue Services * Collaborate with other business units and departments on analysis projects You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in. Required Qualifications * Bachelor's degree or 3 years of directly related experience * 1 years of experience in a role performing data analysis using MS Excel and other tools (MS Access, SQL and VBA) Preferred Qualifications * Experience with data mining and complex ad hoc analyses * Healthcare or Medical claims experience (ICD-10 medical codes) * Experience with insurance health plans or HMOs * Experience using MS Access, SQL and/or VBA for data analysis * Ability to work in a fast paced environment and adapt to ever changing priorities * Demonstrate problem-solving and strong analytical skills * Self-motivated, able to work in a team, and demonstrates the ability to work independently * A passion for and commitment to a consumer and client driven culture Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world?s large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm) Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment. Job Keywords: Associate Business Data Analyst, Woodland Hills, CA, California, Business Data Analyst, Excel, Access, SQL, VBA, claims, coding, ICD-10, codes, revenue cycle Unitedhealth Group Inc. Woodland Hills CA

Data Analyst I

Farmers Insurance Company - Minnesota