Senior Software Engineer

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: 

1. Ensure that applications meet business requirements and systems goals, fulfill end-user requirements, and identify and resolve systems issues.
2. Review and analyze existing applications effectiveness and efficiency, and then develop strategies for improving or leveraging these systems.
3. Work effectively with business liaison to identify and analyze needs.
4. Attend fact-gathering sessions (when applicable), analyze and solve problems with some assistance
5. Work effectively with the project team to identify, estimate, prioritize and resolve issues
6. Develops business oriented data dictionaries.
7. Provide data input during an engagement that will impact scope and delivery
8. 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
9. Work with internal teams to define an enterprise-wide data aggregation approach that encompasses multiple systems and various data integration points
10. Profiles the data to measure quality and integrity of the data collected
11. Develop systems specifications based on business rules, specifications and process flows
12. Develop data flow, application and ER diagrams and technical specifications
13. Implement tools, scripts, queries or applications for accessing and analyzing data and associated metadata.

1. Keeps current with market trends and demands.
2. Performs other functionally related duties as assigned.

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.