ETL/Cube Developer - SSIS/SSAS/SSRS - PowerBI

Job Description

Data Warehouse ETL and Cubes Developer(NO SPONSORSHIP AVAILABLE)We are looking for a Microsoft BI developer with design, development and support experience. The applicant must have significant experience in working in a business-facing support and development function.This is a permanent position, based at head office in Watford, Hertfordshire, reporting to the business intelligence manager. Two days homeworking available after you have settled in.Job responsibilities:· providing support for current solutions, processes and business users· troubleshooting, performance-tuning and regularly maintaining the data warehouse and processes· implementing incremental changes to existing processes, to achieve stability and improved performance· carrying out detailed design and development of ETL using SSIS, Tabular and OLAP cubes using SSAS· delivering ETL/cube development work required (technical specifications, coding and unit-testing)· reporting progress of own ETL/cube development work against agreed plans, in line with agreed milestones· documenting development, testing and deployment tasks· providing post-live support for all ETL/cube development workEssential experience/skills:· bachelors degree, preferably in computer science, business, management information systems or related fields· extensive experience in Microsoft SSIS, Microsoft SSAS, MDS, DQS, DevOps for Version Control, Deployment, PowerShell and various connectivity protocols for source systems· database skills in SQL Server 2017/19: T-SQL, stored procedures, triggers, functions, indexes, constraints, MDX and DAX· experience in SSRS, MS Power BI reports and dashboard-developing· understanding data-warehousing concepts and dimensional data-modelling· experience in design architecture for data warehouse/cubes for performance, capacity and stability· experience in building data-marts and data warehouses· experience in high-volume database performance-tuning techniquesDesired experience/skills:· cloud computing in AWS/Azure· experience in IBM Cognos· knowledge of/experience in other ETL tools, SAP BODS and web services(e.g. API, REST, SOAP and .Net)· understanding SFTP/FTPs, security implications, what information is neededto set up a connection, common faults (e.g. firewall ports, DNS names, etc).Salary: £55,000/£60,000 - based on experienceBenefits:25 days paid holiday (plus bank holidays) pro rata; head-office bonus scheme; free shares (after 18 months with the company); private medical insurance; contributory pension scheme; free head-office parking.Please note you will receive an automated response advising you that we have received your CV.Morgan Philips Group is a global talent solutions business that disrupts conventional thinking in executive search, recruitment and talent consulting. We operate in over 18 markets in Europe, North & South America, Asia, and the Middle East & Africa. Weunderstand that the future is digital and social, so we embrace the latest technology, including video ads and CVs, as well as social recruiting. Our innovative services are tailored to the new world of work yet we do not lose sight of the fact that employeesbe they existing and potential are ultimately human beings.We are committed to ensuring that all job applicants are treated equally, without discrimination because of gender, sexual orientation, marital or civil partner status, gender reassignment, race, colour, nationality, ethnic or national origin, religion orbelief, disability or age.

Keyskills :
ETL/Cubes/SSIS/SSAS/SSRS/PowerBi/AWS/Azure/API/Devops