Permanent General Companies, Inc.

  • Data Warehouse SQL Developer

    Location US-TN-Nashville
    Posted Date 1 month ago(5/21/2018 12:57 PM)
    # Positions
    1
  • Overview

    The General® Insurance, also known as Permanent General Companies, Inc., is a growing company and a leading non-standard automobile insurance provider.  We are currently  seeking qualified applicants for a Data Warehouse SQL Developer.  We offer great training, a well defined career path and a fun and challenging work environment where the right candidate will learn and grow with the company.  We pride ourselves on teamwork and quality customer service.  If you do too, please check us out!

     

    The General® offers a generous benefits package to its employees including medical, dental, vision and life insurance after one month of employment; health care and dependent care flexible spending accounts, tuition reimbursement, paid time off (vacation, sick, holidays), 401(k) participation with a matching contribution,wellness initiatives and much more!

    Responsibilities

    Design, develop, test and implement projects using Microsoft SQL Server development tools in support of data warehouse and business analytics applications.

     

     Essential Job Responsibilities

    • Design, develop and test SQL Server tables, views, stored procedures and T-SQL logic.
    • Develop and maintain complex ETL processes across multiple data sources.
    • Collaborate with the DW development team to share and acquire development ideas and knowledge.
    • Create efficient SQL queries to analyze data from external applications and the data warehouse.
    • Peer review the logic and test the results of team member development.
    • Define and develop quality control monitors to validate data loads.
    • Derive development estimates from project specifications.
    • Analyze and resolve data related user issues reported to the Support Desk.
    • Assist with upgrades of development applications.

    Qualifications

    Experience/Skills Requirements

    • A minimum of 2 years of development experience with Microsoft SQL Server
    • SSIS experience
    • SSAS experience is very beneficial
    • Experience parsing JSONs is very beneficial
    • Knowledge of automobile insurance systems is very beneficial
    • Knowledge of IT best operating practices and methodologies
    • Communicate well in both oral and written form
    • An understanding of the SQL Server Agent and scheduled jobs is beneficial
    • AWS experience with S3, EMR, EC2, Glue and Lambda is beneficial
    • Apache Spark experience is beneficial
    • Python experience is beneficial
    • SSRS experience is beneficial
    • Tableau or other data visualization experience is beneficial
    • COGNOS or other BI application experience is beneficial

    Education Requirements

     

    Bachelor’s degree in a computer related field (Computer Information Systems, Computer Science, Information Technology etc.), Business Analytics or Business Administration or an equivalent combination of education and experience.

     

    #CB

     

    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? Connect with us to submit your name and resume for future consideration.