We Need the Following Skill Sets:
- SQL Querying/Structure (know how to write complex SQL queries and understand database structures)
- SQL Server Reporting Services (SSRS – know how to build reports, embed queries, manipulate parameters, etc.)
- SQL Server Integration Services (SSIS – know how to build ETL packages that can move data from one platform to another)
Nice to Have:
- Power BI (know how to build reports/dashboard using Microsoft’s Power BI toolset) or related toolset
- Electronic Data Interchange (EDI – know and understand the transfer of data between a company and their Supply Chain)
Must Know:
- How to use a version control system in order to check in/out code
- Understand the typical Systems Development Lifecycle (SDLC)
- Comfortable with peer reviews, submitting implementation requests, and test cases