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

Sr. Data Warehouse Developer in Oak Brook, IL at Interactive Business Systems

Date Posted: 10/26/2018

Job Snapshot

Job Description

  • Experience with Tableau Software. 
  • Hadoop/Azure Data Lake data warehousing practices experience 
  • MPP Architectures, machine learning, and data science or statistical analysis experience
  • Agile and Kanban project management methodologies experience. 
  • Understanding of underlying architecture of Microsoft SQL Server and Microsoft BI Stack. 
  • Experience with monitoring, tuning, optimizing, profiling DW/BI environments
  • DBA skills related to DW/BI systems such as index design, aggregate design, partitioning, etc. 
  • Experience with web development (.NET Core, ASP.NET, C#, JavaScript, CSS, HTML). 
  • Geospatial (GIS) data sets experience.
  • 3rd Normal and Dimensional/Star Schema Data Modeling experience.
  • Experience with cloud-based data warehousing solutions such as Microsoft Azure. 

8+ years of experience developing and maintaining database solutions using SQL programming and related technologies. 

3+ years of experience working on data warehouse projects. 

3+ years of experience on ETL solutions preferably on the Microsoft BI Stack (SSIS). 

Proficient with SQL Server, experience designing, developing, indexing and tuning T-SQL queries. 

Understanding of Business Intelligence and Data Warehousing principles including staging source data, master data management, conformed dimensions, data stewardship and dimensional data models (Star Schema). 

Experience unit testing and validating data sets against tie out data sets and business requirements.

Opportunity to work remote