• Lead ETL Developer

    Location US-OH-Richfield
    Posted Date 3 weeks ago(1/30/2019 10:34 AM)
    Job ID
    24640
    # of Positions
    1
    Category
    Technology
    Position Type
    Full Time
  • Overview

    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!

    Responsibilities

    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.

    Qualifications

    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 TSQL skills required.  Experience with Cognos reporting, Informatica Power Center 10 and via custom SQL, Power Exchange connectors, web services (SOAP and RESTful) and, parsing JSON documents, scrum and agile experience a plus.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Build your career profile here to connect with us!