Data Analyst

Jersey City, New Jersey
Not Specified
Oct 03, 2016
Dec 02, 2016
Actuary, IT
Job Type
Not Specified
Career Level
Not Specified

Title_Data Analyst_

About the OrganizationAmTrust Financial Services, Inc., (Nasdaq: AFSI) headquartered in New York City, is a multinational insurance holding company, which, through its insurance carriers, offers specialty property and casualty insurance products, including workers' compensation, commercial automobile and general liability; extended service and warranty coverage.

PositionData Analyst

LocationNJ, Jersey City

DescriptionData Analysts to work intensely with the data work stream through all phases of an engagement, including conceptual design, detailed design, implementation, testing and production deployment. Responsibilities entail defining, assembling and presenting all technical data deliverables and work products. Data Analyst must be comfortable leading internal data meetings, presenting and defending analysis findings to key stakeholders, and participating on client calls. Data Analysts are responsible for contributing to the technical design, implementation and testing of the complete enterprise solution. They must possess skills in design and implementation, master data management, operational data store design (logical and physical models), dimensional design, implementation, stored procedures implementation, and database administration. A passion for making processes faster and more efficient through the use of the latest technology is also important. Candidates must have a proven track record delivering results in a timely and accurate fashion. They must be proficient with standard ETL tools, modeling tools, and standard enterprise databases. They must also have IT consulting experience, be familiar with a team approach to execution, and demonstrate excellent written and verbal communication skills. Duties and Responsibilities
  • Work effectively with business liaison to identify and analyze needs.
  • Attend fact-gathering sessions (when applicable), analyze and solve problems with some assistance
  • Work effectively with the project team to identify, estimate, prioritize and resolve issues
  • Develops business oriented data dictionaries.
  • Provide data input during an engagement that will impact scope and delivery
  • Provide input into the technical architecture and the data warehouse technology stack, as well as establish and follow through on data modeling and ETL standards
  • Work with internal teams to define an enterprise-wide data aggregation approach that encompasses multiple systems and various data integration points
  • Profiles the data to measure quality and integrity of the data collected
  • Develop systems specifications based on business rules, specifications and process flows
  • Develop data flow, application and ER diagrams and technical specifications
  • Implement tools, scripts, queries or applications for accessing and analyzing data and associated metadata.

    Open Date7/21/2015

    Position RequirementsCandidates must have 5+ years of data analysis experience across multiple database platforms, as well as the following:
  • College degree in computer science, information systems, or computer engineering or equivalent business experience.
  • A track record as a Data Analyst, preferably with insurance industry experience
  • Proven analytical, evaluative and problem solving abilities.
  • Able to deliver input into scope and timeline
  • Willing to be hands-on, with an updated skills toolset to work on data projects (SQL, stored procedures, BI report development)
  • Ability to scope data work and deliver input into strategies and roadmaps
  • Experience creating presentations and technical design documents
  • Ability to work hands-on and be willing to deliver working database (SQL, TSQL, PL/SQL) and Linux scripting (Bash, Ruby, Python) code
  • Experience with at least one BI tool OR one ETL tool including, preferred Microsoft BI stack
  • Experience with dimensional and 3NF modeling
  • Experience with OLTP and OLAP
  • Excellent written and oral communication skills. Good to Have
  • understanding of NoSQL platform (Hadoop, MongoDB)
  • Experience in multiple industries, including financial services, insurance.
  • Previous .net experience or other programming languages
  • Understand of MPP enterprise data warehouse (Teradata, Oracle, DB2, Neteeza, MySQL, HP Vertica, Red Shift)
  • Proficient with data modeling concepts #LI-POST


    Req NumberINF-15-00012


    Number of Openings1

    Employee Referral Eligible

    Employee Referral PayoutThis position is currently accepting applications.