• 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 ...