Assistant Data Analyst/Data Analyst Job at AIPSO, Johnston, RI

UGlWdnRKcUd1bDlOZzEzM2hnbjZndHNkS1E9PQ==
  • AIPSO
  • Johnston, RI

Job Description

AIPSO is a management organization and service provider for various insurance industry groups responsible for administering the residual market. We are a national organization that serves local customer needs. Centralization and standardization are key to many AIPSO services because of the inherent economies of scale and other efficiencies. However, our organization is based on customer focus and recognizes the need for flexibility in serving customer groups with diverse interests.

Essential Duties and Responsibilities:
  • Support IBM mainframe system production processes.
  • Support production processing including identifying, troubleshooting, processing, and resolving issues for daily systems.
  • Support internal, SQL server databases, websites and the integration of open systems.
  • Process reported statistical data, and analyze data for completeness, reasonability, and anomalies.
  • Research and analyze data issues using MS Office tools and SQL queries.
  • Execute IBM mainframe batch jobs to produce reports for data analyzation, completeness, reasonability, and anomalies. 
  • Review discrepancies in data received.
  • Serve in the role of Automated Batch Scheduler consultant and job developer.
  • Create and maintain system and process documentation.
  • Support testing and production implementation for process and system changes.
  • Identify and act upon opportunities to streamline and automate processes.
  • Identify and recommend appropriate continuous improvement opportunities.
  • May provide training to other team members on technology tools.
Education:
Bachelor's degree (BA/BS) from four-year college or university in Data Analysis or related field preferred. Additional appropriate experience or training may be considered in lieu of degree.

Experience:
1 to 3 years' experience working with databases and reporting tools for data analysis and reporting. Experience in the automobile insurance industry a plus.

Skills/ Knowledge:
  • Demonstrate understanding of databases, queries, and reporting tools including SQL and  Power BI.
  • Demonstrate knowledge and experience executing processes on IBM Mainframe using JCL,  TSO, ISPF/SDSF and CICS.
  • Strong analytical skills to analyze, interpret and question data validity.
  • Knowledge of technology platforms and software (e.g. job scheduling software) a plus.
  • Proficient in the use of Microsoft Office productivity tools (e.g. Outlook, Word, Excel) to manage work.
  • Effective problem-solving skills, including ability to analyze complex issues, find the root cause of the problem and consider a wide range of alternatives before acting.
  • Demonstrate strong verbal and written communication skills, including ability to effectively present information and respond to questions from groups or individuals.
  • Ability to multi-task and demonstrate flexibility while maintaining attention to detail.
  • Demonstrate excellent organizational and customer service skills.
  • Ability to work independently and interact professionally and effectively in a team  environment.
  • Knowledge of the automobile insurance industry preferred.
Salary Range: $51,200 - $81,800/$61,200 - $97,800 Annual . A ctual salary for this position will be determined by a number of factors, including the scope, complexity, and location of the role as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; internal equity and other conditions of employment.

AIPSO is an equal opportunity employer. To this end, all employment related decisions are made on a non-discriminatory basis and in full compliance with federal, state, and local laws prohibiting discrimination in employment.

Job Tags

Full time, Local area,

Similar Jobs

Uline

Supply Chain Manager Job at Uline

 ...Kenosha Branch 12355 Uline Way, Kenosha, WI 53144 Find fulfillment in your Warehouse career - at Uline! As a Supply Chain Manager at our Kenosha location, you'll ensure our extensive inventory of over 40,000 shipping, industrial and packaging products are organized... 

HNTB

Sr. Project Engineer / Civil Task Lead Job at HNTB

 ...solutions for some of the largest, most complex infrastructure projects across the country. With our historic growth, it is an exciting...  ...team of employee-owners. Join HNTB Chicago as a Sr. Project Engineer/Task Lead! Our office has an extensive history delivering exciting... 

Mike Anderson Chevrolet of Merrillville

Automotive New/Used Car Sales Porter (Merrillville) Job at Mike Anderson Chevrolet of Merrillville

Jump start your career! Mike Anderson Chevrolet of Merrillville is currently growing their winning team. This is a rare opportunity to join a General Motors Dealer of the Year location.One of the best compensation plans in the industry -- paid training, stellar company...

MatrixRecruiters.com

Remote Workflow Implementation Trainee - Work from Home | No Experience or Degree Required | Free 5-Day Training Included Job at MatrixRecruiters.com

 ...Remote Workflow Implementation Trainee Work from Home | No Experience or Degree Required | Free 5-Day Training Included Curious how businesses...  ...More button below to begin your onboarding. Youll get immediate access to your training dashboard, where youll be guided... 

Sun-itsolutions inc

Smartsheet Administrator Job at Sun-itsolutions inc

 ...Looking for a Smartsheet Administrator local to Tallahassee, FL to support a State Gov project. Requirements ~2 years experience as a Smartsheet Administrator, Developer or Consultant or similar role required ~ Ability to implement Smartsheet resources...