Position Overview
β’ 8+ years strong Experience working with the overall Microsoft SQL Server BI/ DW stack (SSRS/SSMS/SSIS/ SSAS)
β’ SSRS- required to do canned and ad hoc reports
β’ SSIS- there will be lots of integration work
β’ Knowledge of data warehouse design (e.g., dimensional modeling) and data mining
β’ SSMS (SQL Server Management Studio) -including Experience with all these- Structured Query Language (T-SQL)/ coding transact- SQL, writing queries, stored procedures, triggers, functions & building tables. Must know how to set up a Universe of tables
β’ Must learn how to design dimensional model tables (Kimball methodology) and have helped build Data Marts
β’ Experience with relational database management systems and ETL (Extract, transform, load) framework
β’ Works independently with little supervision
β’ Ability to work in an open team environment, to take the initiative, and be innovative
β’ An analytically minded go-getter with an ownership mentality and a ...