EXPERIENCE
Essential skills and experience
- Expertise at Development using Microsoft Power BI including DAX
- Proven experience as a BI Developer or Data Scientist
- Background in data warehouse design and data mining
- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
- Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
- Analytical mind with a problem-solving aptitude
- BSc/BA in Computer Science, Engineering or relevant
- Skilled with a wide variety of data exploitation applications such as SPLUNK, and SQRRL
- Consulting and business analysis skills to understand client's requirements
- Experience in Agile delivery methodology
- Produce technical specifications
- Experience in Big Data platforms including HADOOP ecosystems
- Experience working as a Database Analyst or Database Developer
- Ability to programme in languages such as SQL, .NET, Python and Bash script
- Understand Data modelling and ETL concepts
- Understand and design Business Intelligence and reporting architecture
- Understand concepts of dimensions, measures, metadata & schemas
- Understand analytical processing
Nice-to-have skills and experience
- Previous experience working within a defence or intelligence environment
- Previous experience working within a defensive cyber security environment
- Previous experience working within an agile development environment