Business Intellligence Analytics Developer in Alpharetta, GA at LeasePlan

Date Posted: 7/29/2018

Job Snapshot

  • Employee Type:
  • Job Type:
  • Experience:
    3 to 5 years
  • Date Posted:

Job 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.
  • Creating/modifying cubes and tabular models in SSAS 2016
  • Creating/modifying reports/data visualizations utilizing Power BI

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 Optional

  • 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


  • Bachelor's degree, preferably in a technical field, with 3 to 5 years’ applicable experience in Information Technology


  1. Programmer Jobs
  2. Software Developer 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.