Business Intelligence Developer Nashville 110K Perm in Nashville, TN at Vaco

Date Posted: 7/2/2019

Job Snapshot

Job Description

Primary Responsibilities * Analyze business needs to produce data warehouse/business intelligence solutions in support of BI strategy. * Produce quality & timely deliverables as part of data warehouse project team(s). * Design and develop Data Warehouse ETL processes in SSIS & SQL Stored Procedures. * Design and develop Reports from Data Warehouse using SSRS & SQL Stored Procedures. * Perform peer reviews and take ownership to ensure quality of data in data warehouse. * Become expert in very short time in existing BI solutions to troubleshoot and correct issues. * Efficiently work in an Agile environment - both Sprint and KanBan. * Production support on a rotating basis. * Contribute to build team knowledge base * Able to take additional responsibility over time to perform design and development of Data Warehouse database schema(s) & structures. * Able to take additional responsibility over time to perform design

Primary Responsibilities
* Analyze business needs to produce data warehouse/business intelligence solutions in support of BI strategy.
* Produce quality & timely deliverables as part of data warehouse project team(s).
* Design and develop Data Warehouse ETL processes in SSIS & SQL Stored Procedures.
* Design and develop Reports from Data Warehouse using SSRS & SQL Stored Procedures.
* Perform peer reviews and take ownership to ensure quality of data in data warehouse.
* Become expert in very short time in existing BI solutions to troubleshoot and correct issues.
* Efficiently work in an Agile environment - both Sprint and KanBan.
* Production support on a rotating basis.
* Contribute to build team knowledge base
* Able to take additional responsibility over time to perform design and development of Data Warehouse database schema(s) & structures.
* Able to take additional responsibility over time to perform design and development of Data Warehouse Cubes - Dimensional, Tabular, Relational, and Multidimensional OLAP cubes.

Qualifications

Technical Skills:
* 7+ years of experience with ETL Design & development using Microsoft BI stack, including SQL and SSIS in Data Warehouse setting.
* 2+ years of experience with Tableau solution development, and integration with existing architecture and data engineering assets.
* Must have expertise in SQL and SSIS.
* Familiarity with database design and architecture for data warehouse is a plus.
* Experience with architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems is a big plus
* Understanding of quality assurance and data quality principals as applied to an ETL architecture is a plus.
* 6+ months of experience in SSAS (Dimensional and Tabular), SSRS, DAX, MDX, and other components is a plus.