Data Analyst II

Position Summary

Evaluates data using analytical and logical reasoning to examine each component of the data provided to incorporate into SMC³ data formats.

Performs duties with minimal supervision and direction. Execute, modify and/or maintain processes/programs that manipulate data for existing products. This involves analysis, testing and documentation.  Also performs other duties related to the support of SMC³ data content and products.  

Essential Job Functions

Note: The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar.

·        Performs duties with minimal supervision and direction.

·        Subject matter expert for one or more of SMC³ core products.

·        Follows Procedures, runs programs and processes to build and verify product(s).

·        Determine applicable procedures, programs and processes needed to build and verify the product(s) based on customer requirements.

·        Modifies existing procedures, programs and processes to create and modify data for customers.

·        With minimal assistance, develops new procedures, programs and processes to create and modify data for customers.

·        Performs all aspects of data verification, including Regression Testing.

·        Works with customers to gather and develop project requirements.

·        Build relationships with customers to ensure data continuity and accuracy.

·        Stay current on software used to build/create SMC³ products and data content.

·        Considers and presents alternatives to direct manager/supervisor and Data Services team.

·        Able to lead small to basic intermediate projects.

·        Participates in Agile Teams as needed.

·        Performs other related duties as required.

Qualifications/Education

Note: Qualifications listed are guidelines. Other factors may be taken into consideration.

Required

·        Minimum 2-year Programming or Data related college degree, professional certification or equivalent related work experience.

·        Adobe 

·        Customer service 

·        ExamDiff Pro 

·        File Zipping (WinRAR) 

·        Knowledge of Rating, Transit Time, etc. 

·        Microsoft CRM 

·        Microsoft Office (Excel, Word) 

·        Ready API (SoapUI) using SOAP and REST API’s  

·        SharePoint 

·        VBA Script (MS Access) 

·        Working with data in text or csv files 

Preferred

·        Database (MS SQL, MySQL and/or Access) 

·        Programming language (REXX, VB6, VB.net, C#, Java, etc.) 

·        Working in an agile environment

Skills Required

·        Accuracy

·        Adaptability

·        Attention to Detail

·        Confidence and follow-through on decisions

·        Dependability

·        Initiative

·        Interpersonal

·        Logical Thinking

·        Oral Communication

·        Problem Solving

·        Time Management with attention to required delivery dates

·        Written Communication

·        Adherence to information and Enterprise Security principles

·        Initiative to investigate subject matter from various sources