This site uses cookies. To find out more, see our Cookies Policy

Data Warehouse SQL Developer in Nashville, TN at The General® Insurance

Date Posted: 6/21/2018

Job Snapshot

Job Description

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.

Job Requirements

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

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs