JD - SQL/SSIS/MSBI
Experience Range – 3 to 7 years
Analyst Programmer
- 3+ years of Business Intelligence experience
- Experience of database design or data integration experience with SQL Server databases
- Expertise with MS SQL Server and the full Microsoft BI Stack (SSAS, SSRS, SSIS) – Preferably in SSIS 2016 environment
- Experience in Query optimization
- Design and implement ETL process, manage and maintain databases
- Experience delivering reporting, database and data integration
- Relational database and SQL Language knowledge
- Data Warehouse knowledge and understanding
- Interaction with the Senior Analyst Programmer to ensure that the technical design and technical requirements are understood and embedded into the code with expected quality.
- Development of full documentation, including code comments, data dictionaries for new development done by the team.
- Unit testing of code to ensure alignment to the detailed requirements and quality standards.