Required Experience:
- SSIS: 5 years, 2012-2016, recent experience, including pulling from multiple data sources, unattended execution, error handling and auditing
- SSRS: 5 years, 2012-2016, recent experience
- Azure: Database, VMs with SQL Server
- C# – 3 – 5 years
- T-SQL: 5-10 years, 2012-2016, recent experience
- Visual Studio/SSDT for database development
- Know the difference between clustered and non-clustered indexes
- Data modeling
- TSQL Troubleshooting techniques (performance, execution plans)
- Data Warehouse: 3 – 5 years, recent experience
- Active participant team player
Preferred Experience:
- Experience with or very familiar with data warehouse/data marts
- Visual Studio Team services
- Source control
- Agile
- Power BI (e.g. developing executive dashboards)
- Hospitality industry
- PowerShell
- Sql Server database backups, log shipping
- Data architecture experience and skills
Additional Experience:
- Git
- Microsoft Certs
- ER Studio
- Dynamics CRM
- DB2
- Azure Data Factory