Work effectively with business liaison to identify and analyze needs.Attend fact-gathering sessions (when applicable), analyze and solve problems with some assistanceWork effectively with the project team to identify, estimate, prioritize and resolve issuesDevelops business oriented data dictionaries.Provide data input during an engagement that will impact scope and deliveryProvide input into the technical architecture and the data warehouse technology stack, as well as establish and follow through on data modeling and ETL standardsWork with internal teams to define an enterprise-wide data aggregation approach that encompasses multiple systems and various data integration pointsProfiles the data to measure quality and integrity of the data collectedDevelop systems specifications based on business rules, specifications and process flowsDevelop data flow, application and ER diagrams and technical specificationsImplement tools, scripts, queries or applications for accessing and analyzing data and associated metadata.
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.
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
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 experienceProven analytical, evaluative and problem solving abilities.Able to deliver input into scope and timelineWilling 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 roadmapsExperience creating presentations and technical design documentsAbility to work hands-on and be willing to deliver working database (SQL, TSQL, PL/SQL) and Linux scripting (Bash, Ruby, Python) codeExperience with at least one BI tool OR one ETL tool including, preferred Microsoft BI stackExperience with dimensional and 3NF modelingExperience with OLTP and OLAPExcellent written and oral communication skills. Good to Haveunderstanding of NoSQL platform (Hadoop, MongoDB)Experience in multiple industries, including financial services, insurance.Previous .net experience or other programming languagesUnderstand of MPP enterprise data warehouse (Teradata, Oracle, DB2, Neteeza, MySQL, HP Vertica, Red Shift)Proficient with data modeling concepts #LI-POST
Number of Openings1
Employee Referral Eligible
Employee Referral PayoutThis position is currently accepting applications.