Summary: Sr. Software Engineer 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. He must be comfortable leading internal meetings, presenting and defending analysis findings to key stakeholders, and participating on client calls.
Sr. Software Engineer 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. Maintains a solid understanding of AmTrust’s mission, vision, and values. Upholds the standards of the AmTrust organization.
Responsibilities
Responsibilities:
Qualifications
Qualifications: Required:
- Candidates must have 10+ years of experience across multiple database platforms, ETL development as well as the following:
- College degree in computer science/computer information systems or equivalent business experience.
- 10+ years of related experience in software development including a broad technical background with extensive integration experience
- Proven analytical, evaluative and problem solving abilities.
- 5+ year experience in building applications using SSAS, SSRS and .net technologies.
- 5+ year experience in building ETL process using SSIS.
- 2+ year experience in building ad-hock reporting environment using report model, share point.
- 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).
- 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.
This job description is designed to provide a general overview of the requirements of the job and does not entail a comprehensive listing of all activities, duties, or responsibilities that will be required in this position. AmTrust has the right to revise this job description at any time.
Skills Required
- College degree in computer science, computer information systems, or equivalent business experience
- 10+ years of related software development experience
- Broad technical background with extensive integration experience
- 5+ years building applications using SSAS, SSRS, and .NET technologies
- 5+ years building ETL processes using SSIS
- 2+ years building ad hoc reporting environments using report models and SharePoint
- Hands-on experience with SQL, stored procedures, and BI report development
- Ability to scope data work and contribute to strategies and roadmaps
- Experience creating presentations and technical design documents
- Hands-on ability to deliver working databases using SQL, T-SQL, and PL/SQL
- Experience with at least one BI tool or ETL tool, preferably the Microsoft BI stack
- Experience with dimensional and 3NF data modeling
- Experience with OLTP and OLAP
- Excellent written and oral communication skills
- Proven analytical, evaluative, and problem-solving abilities
- IT consulting experience and ability to work in a team-based environment
What We Do
AmTrust Financial Services, Inc., through its subsidiaries, operates as a multinational property and casualty insurance company. Founded in 1998 to provide workers’ compensation insurance to small businesses in the United States, the company now operates in three segments around the globe: Small Commercial Business Insurance, Specialty Risk and Extended Warranty, and Specialty Middle-Market Property and Casualty Program Insurance.
