Analyst - Data Quality

Kemper Corp. Lake Mary , FL 32795

Posted 2 months ago

Location(s)

Birmingham AL, Charlotte NC, Dallas TX, Lake Mary FL, Phoenix AZ

Details

POSTING TITLE: Analyst - Data Quality

Kemper is one of the nation's leading specialized insurers. Our success is a direct reflection of the talented and diverse people who make a positive difference in the lives of our customers every day. We believe a high-performing culture, valuable opportunities for personal development and professional challenge, and a healthy work-life balance can be highly motivating and productive. Kemper's products and services are making a real difference to our customers, who have unique and evolving needs. By joining our team, you are helping to provide an experience to our stakeholders that delivers on our promises.

POSITION SUMMARY:

Working closely with business and technical partners, this analyst will test and support complex dashboards and reports that provide key business insights for the Claims organization to drive results and support strategic initiatives. This analyst will profile and test the quality of data being used for reporting and analytics. You will have the opportunity to showcase and develop your quality assurance and presentation skills to tell a story with a wide variety of data that will be used to measure results and shape the behaviors for the organization. As a key member of a fast-paced team in a growing company, you will work on multiple projects and workflows that leverage and expand your knowledge of data quality, reporting tools, querying, relational databases, and data analysis. Growth opportunities in this role will focus on increasing technical development skills, incorporating cloud-based tools and building operational acumen (i.e. learning claims processes, financials and key performance indicators.) This role will also learn to provide coaching and development assistance to other members of the team. Over time a successful candidate will learn how to navigate the organization independently both inside and outside of Claims. As a result, a candidate can expect to learn about Claims, Actuarial and Product Management processes and roles.

PRINCIPAL DUTIES AND RESPONSIBILITIES

  • Support the creation of complex interactive dashboards in Tableau and other tools that utilize data to provide business intelligence to key business partners across the organization.

  • Profile and evaluate data from multiple sources to present opportunities for data quality and reporting improvement providing consistently formatted views allowing users to easily find and understand results specific to their business function.

  • Test and validate extracts to populate underlying data-marts using tools like Informatica and Python. Maintain relationship with database teams to adapt to changes and enhancements to underlying data schemas.

  • Create technical specifications and complex solutions based on business requirements. Provide guidance on options for summary and detail presentation views that can be best utilized to answer specific business questions.

  • Responsible for team coordination of the change-management process on existing dashboards.

  • Schedule and monitor multiple refresh schedules. Build error handling notifications and processes.

  • Assist with the maintenance and support of existing report processes across multiple distribution channels and schedules. Migrate existing reporting packages to Tableau.

  • Document code and workflows to facilitate transparency and operational continuity.

  • Develop data quality reporting solutions including target values and improvement plans

  • Works independently with limited direction from supervisor

MINIMUM JOB REQUIREMENTS:

  • Bachelors degree in business analytics, computer science or a related field, or the equivalent in related work experience.

  • 3+ years of experience working in business intelligence with a focus on data quality.

  • Demonstrated experience with testing reports and dashboards developed in various reporting tools. data source creation and scheduling.

  • Demonstrated knowledge of informational dashboard design principles and experience displaying multiple summary datapoints in effective and interactive graphical methods.

  • Experience combining and presenting large and complex data sets; able to write queries and create calculated fields.

  • Experience with data query languages and tools. Functional knowledge of relational databases and combing disparate data sets.

  • Understanding of the functional areas of insurance, especially claims terminology and concepts, is preferred.

  • Experience with cloud-based data warehousing with tools such as Snowflake and AWS.

REQUIRED JOB SKILLS:

  • Expert level data quality skills

  • Experience with Python coding

  • Experience with AWS or another cloud-based platform

  • Advanced computer skills in Excel including pivot tables, lookups, macros and array processing. Experience with VBA a plus.

  • Advanced ability to extract data using SQL, Informatica, Python, R, Informatica or similar tools.

  • Demonstrated understanding of the collection of data and the concepts behind relational databases.

  • Clear, concise and effective oral and written communication skills.

  • Ability to present results within and outside of team to users of various technical knowledge.

  • Consistently demonstrate constructive critical thinking and problem solving.

  • Demonstrated ability to handle multiple competing priorities effectively.

  • Experience documenting development processes and codebase, both for ease of support and inclusion in a re-usable knowledge base.

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified. The incumbent must have the abilities or aptitudes to perform each essential function proficiently with or without reasonable accommodation. Our organization has a dynamic work environment where positions evolve and change. Therefore, the Company reserves the right to modify, delete, or add job duties, responsibilities and skills that are stated in this job description at any time.

Kemper is proud to be an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, disability status or any other status protected by the laws or regulations in the locations where we operate. We are committed to supporting diversity and equality across our organization and we work diligently to maintain a workplace free from discrimination.

Kemper does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Kemper and Kemper will not be obligated to pay a placement fee.

#LI-JO1

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
lc_ad

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
Senior Financial Services Analyst

Verizon

Posted 5 days ago

VIEW JOBS 10/23/2021 12:00:00 AM 2022-01-21T00:00 When you join Verizon Verizon is a leading provider of technology, communications, information and entertainment products, transforming the way we connect across the globe. We're a diverse network of people driven by our ambition and united in our shared purpose to shape a better future. Here, we have the ability to learn and grow at the speed of technology, and the space to create within every role. Together, we are moving the world forward - and you can too. Dream it. Build it. Do it here. What you'll be doing... The Finance Organization At Verizon, we are building a world-class Financial Planning & Analysis (FP&A) organization. We have begun a comprehensive program to streamline processes, improve systems, realign the organization and add opportunities for personal skill-building and professional growth. We're finding new ways to add value and provide strategic support. This is the kind of work we do. We want to build leading FP&A practices within Verizon, setting the stage to become the place any FP&A professional wants to work. You can become a catalyst for change. FP&A Corporate and Business Unit Team Move beyond compiling data and help tell the story behind the numbers. The Business Unit facing positions offer opportunities to drive better business partnering and insights, while growing your FP&A leadership and interpersonal skills. You are considered a business partner and your contributions will make a difference. You'll become involved in, but not limited to, pricing decisions and new initiatives to develop new products and services. You can have an impact on new business growth opportunities through development of business case scenarios. Prepare final financial plan, forecast, reporting and analysis for the business clients.Develop the Business Plan, Commitment View, Best View, including analysis, distribution and recommendations for management reviews.Prepare final monthly analyses of business trends and budget variance of financial results and Key Performance Indicators to be used in management reviews and strategic business analysis sessions.Develop the final in depth analysis of the business performance and recommend action plans; including gap closures, considerations for managing cost, growing the revenue and profitability.Develop final capital planning models, reports and templates.Create cash flow statement and ad-hoc cash flow analysis/trending.Define the need for and the source of data requirements for the planning & forecasting and reporting processes.Conduct the development of strategic business analysis with overlays and commentary.Create final performance reports, including business insights, ad-hoc analysis and recommendations to executive management.Proactively identify possible scenarios, risks and opportunities around business performance.Create profitability/costing models and oversee/communicate model updates to the Center of Excellence.Develop and analyze economic drivers of the business client (e.g. customer churn, renewals).Model/assess performance scenarios to analyze risks and opportunities.Communicate with partners in a clear and concise manner. What we're looking for... You'll need to have: Bachelor's degree in Accounting, Finance, Economics or four or more years of work experience.Four or more years of relevant work experience.Experience with Microsoft Office Suite with knowledge of Excel. Even better if you have one or more of the following: Master's degree in Accounting, Finance, or Economics.Experience in the technology and/or telecommunications industry.A professional certification (e.g. CPA, CMA).Understanding of corporate financial planning, reporting & analysis, and costing/profitability methodologies and processes.Knowledge of common business and cost drivers, financial statement analysis, and deep-dive analysis.Familiarity with the preparation of General Ledgers, Basic Knowledge of FASB requirements, Generally Accepted Accounting Principles.Proficiency in Essbase, Smart View, Hyperion Planning, and Hyperion Strategic Finance.Excellent communication skills and ability to focus on the details. If Verizon and this role sound like a fit for you, we encourage you to apply even if you don't meet every "even better" qualification listed above. What we're looking for... Additional requirements: Willingness to travel. Equal Employment Opportunity We're proud to be an equal opportunity employer - and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. At Verizon, we know that diversity makes us stronger. We are committed to a collaborative, inclusive environment that encourages authenticity and fosters a sense of belonging. We strive for everyone to feel valued, connected, and empowered to reach their potential and contribute their best. Check out our diversity and inclusion page to learn more. Internal ID: 578677PandoLogic. Category:Finance, Keywords:Senior Financial Analyst, Location:Lake Mary, FL-32746 Verizon Lake Mary FL

Analyst - Data Quality

Kemper Corp.