National Interstate is a member of Great American Insurance Group. As one of the leading commercial transportation insurers in the nation, we offer risk financing solutions in all 50 states tailored to meet the needs of a wide variety of transportation classes. Our offerings include traditional insurance and innovative alternative risk transfer (ART) programs, including more than a dozen group captive programs catering to niche wheels markets. We are proud to be a multiple Northcoast 99 winner and Cleveland Plain Dealer Top Workplace in Northeast Ohio. It is because of our talented and dedicated team that we are able to live out our company values of integrity, transparency, fairness, accountability, empowerment and collaboration with each transaction we make. If you are ready to join an engaging and driven team such as ours, we would love to hear from you!
Developer/Architect is responsible for ETL strategy, architecture, design and development of the Enterprise Data Warehouse (EDW), designing and writing ETL code and batch management and error handling processes. Additional responsibilities include the documentation of technical specifications and related project artifacts, including solutions-oriented design across the data warehouse (i.e. architecture feedback, business process redesign, and the implementation of automated control processes).
ESSENTIAL FUNCTIONS & WORK DUTIES
The following essential functions of this position are performed personally, in cooperation with your supervisor, and/or in coordination with other staff. Additional work functions and duties may be assigned.
Education: Bachelor’s degree or equivalent experience
Field of Study: Computer Science, Information Technology or a related discipline
Experience: 8 or more years of related experience. Strong Informatica Power Center 10 and TSQL skills required. Experience with Cognos reporting, via custom SQL, Power Exchange connectors, web services (SOAP and RESTful) and, parsing JSON documents, Informatica Cloud, scrum and agile experience a plus.