Birmingham AL, Charlotte NC, Dallas TX, Lake Mary FL, Phoenix AZ
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.
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.