Database Design Analyst

Other jobs >> General




Location(s)Jacksonville FL


Kemper Corporate Services is seeking to add a Data Warehouse Analyst to staff the Enterprise Data Services team reporting to the Director of Enterprise Data Services, P & C.

This position is responsible for the development and maintenance of data warehouse and analytical environments to support financial, management and statutory reporting requirements along with enhancing and facilitating corporate decision-making capabilities.

Position Responsibilities:

- Independently work with business customers and members of the EDS team to create solutions that support reporting, analytic and warehouse needs using the appropriate platforms and tools.

- Analyze business requirements and work with client areas to produce functional specifications for use as reference in creation of reporting and analytical solutions.

- Perform the first level of testing for a new and/or enhanced functionality and provide support for user acceptance testing.

- Analyze source data to understand relationships and determine business rules.

- Assist in designing the data warehouse and assure that data is stored and maintained in consistent formats.

- Create source to target mapping documents to transform the source data into the target warehouse and test final transformations.

- Develop and/or maintain relationships with business customers to identify and acquire additional data sources to incorporate into the warehouse.

- Train and assist users with retrieving data from the warehouse.

- Provide guidance in the creation of reporting and analytical solutions.

Position Qualifications:

- Requires a bachelors degree or equivalent certifications in technical system design.

- 7+ years of experience developing data warehouse solutions preferably within the insurance industry.

- Sound understanding of data warehouse best practices, relational data structures and dimensional data modeling.

- Strong knowledge of current relational database and big data software and query concepts

- Advanced SQL skills

- Experience supporting large scale Enterprise Data Warehouses

- Ability to analyze and solve complex problems and to work independently on multiple tasks

- Must be able to communicate effectively verbally and in writing with technical and non-technical associates
  • 1
  • Negotiable
  • None
  • None
  • Re-97520
  • Permanent
  • 1

How to Apply: Please click here to create a free account and post your resume. Only logged in job seekers can apply for a job.

Find us at:

Never provide bank account, credit card details or any other financial information, or make any form of payment, when applying for a job. If you are ever asked to do this by a recruiter on Pure Jobs please click the Report button or contact us with the advertiser's company name and the title of the job vacancy. You should not send any money to anyone. A genuine employer with a job offer would never ask you to do this.

Report this job

Report a job

If you're concerned about a job advert, let us know and our quality team will investigate.

Your name(*)
Invalid Input

Your email address(*)
Invalid Input

Please select you reason(*)

Additional information(*)
Invalid Input

Invalid Input

Get new jobs for this search by email.

Also get an email with jobs recommended just for me.

Create Alert

Subscribe to updates from our blog