Job Description
Role: BI Engineer
Location: Bristol, UK
Job Description:
Good hands-on experience with SSIS SQL query writing Data warehouse knowledge is must have
Should have good communication skills as the person needs to work with multiple stakeholders
Data warehouse ETL knowledge is must have
Good hands on experience with SSIS SSAS SQL query writing
Should be good in Code review and Quality check
Should be very good in Client exposure
Should be good in Database security set up and active directory set up
Should have good experience in Database design and architecture
Need to have Databricks Spark SQL Azure ADF Azure mapping work flow
Experience in Azure SQL warehouse Experience
Strong experience in Azure ADF development hands on development experience in developing pipelines in ADF
Strong knowledge in ETL solutioning Strong experience in Azure SQL DB
Strong communication skills both oral written
Strong proficiency in Azure Data Factory SQL Server Azure Data Services Azure Data actory SSIS Copy Azure Batch Azure Data Warehouse
Troubleshooting knowledge for Connectivity issues between On premises data and Azure data storage through data management gateway
Monitoring of the data pipelines through Azure Preview Portal
Checking historical accounting of job execution data production status and system health in a single monitoring dashboard
Expertise in writing fine tuning stored procedures
Exposure to technologies such as Power BI will be added advantage
Good experience in creating database schemas data base models that represent and support business processes
Responsibly own project tasks and take it through completion
Technical expertise:
SQL
SSIS
SSAS (Nice to have)
Power BI
ADF
Databricks with Pyspark / SQL.