Business Intelligence Support Developer in Alpharetta, GA at LeasePlan

Date Posted: 10/23/2018

Job Snapshot

  • Employee Type:
    Full-Time
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    10/23/2018

Job Description

Description 

Position will be responsible for day to day SQL Server 2008R2, 2012 and 2016 database servers, SSIS ETL processes and SSAS tabular models/cubes.  Position will also be responsible for developing database objects such as tables, views, and stored procedures, SSIS packages, and SSAS tabular models.

Day to day activities will include:

  • Supporting SQL Server 2008R2 – 2016 servers and operations.
  • Creating/modifying SSIS packages utilizing SSIS 2008R2, 2012, and 2016.
  • Upgrading packages from 2012 to 2016.
  • Creating tables, stored procedures and indexes in SQL Server data mart.
  • Optimizing ETL processes for best performance.
  • Researching data discrepancies between data warehouse and existing reports/data.
  • Operating with minimal supervision or direction.

Technical Skills Required

  • 5+ years professional experience supporting Microsoft SQL Server with at least 4 years of SQL Server 2008 R2 and 3 years of SQL Server 2012+
  • 5+ years professional experience with Microsoft SSIS 2008R2 or 2012+
  • 3+ years professional experience with Microsoft SSAS, including recent use of the tabular model
  • 3+ years professional data warehouse experience utilizing the star schema
  • 3+ years professional experience working with large data warehouse installations
  • Strong T-SQL knowledge. Ability to create and troubleshoot large, complex stored procedures and triggers.

Technical Skills Desired 

  • DB2 for iSeries experience

Other Skills

  • Ability to manage time and resources to complete tasks on time
  • Ability to work with minimal supervision and direction.
  • Able to complete tasks and deliver a fully constructed and tested solution, ready to deploy to production.
  • Ability to communicate technical concepts and ideas effectively
  • Self motivated and driven to succeed
  • Able to work as part of a team and provide technical leadership

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs

Not ready to apply?

Joining our talent network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.