Lead ETL Developer

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.

• Leads, designs, builds, tests and maintains on-premises and cloud-based data structures such as data marts, data warehouses, data lakes and data pipelines.
• Leads, designs, builds, tests and maintains on-premises and cloud-based data pipelines to acquire, profile, cleanse, consolidate, integrate and persist structured, semi-structured and unstructured data.
• Works with internal and external data providers and subject matter experts to understand data sources and formats.
• Understands and influences the data provider roadmap of planned changes.
• Advocates for additional data sets and elements to improve delivered data products.
• Leads, designs and develops ETL processes for the data warehouse lifecycle (staging of data, ODS data integration, EDW and data marts).
• Prepares key documentation to support the technical design in technical specifications.
• Authors and executes unit test scripts.
• Leads solution design workshops, championing and promoting the application of ETL best practices.
• Leads the design and development of the Data Warehouse’s batch management control processes and error handling procedures.
• Works with the Data Architect to design and develop the Data Warehouse, schematics and layouts. Develops capacity planning.
• Develops and maintains relational databases for data storage and mining. Designs and tests complex data warehouses. Creates enhanced and new components for existing data warehouses.
• Implements and updates disaster recovery procedures.
• Keeps apprised of current and emerging data, development and cloud-based technologies and best practices.
• Identifies opportunities for process improvement/optimization; designs and implements these improvements as directed.
• Collaborate and work alongside with other technical professionals (BI Report developers, Data Analysts, Architects).
• Mentors and trains other ETL staff members in best practices.
• Fosters team success by encouraging learning and growth of team members.

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.