Posted on: 12/02/2024

Job type: Permanent

Sector: Tourism and Leisure

 
Sign up for job alerts

You will receive job alerts for:

Please enter your email address.

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 work

Essential experience/skills:

· bachelor’s 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 techniques

Desired 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 needed

to set up a connection, common faults (e.g. firewall ports, DNS names, etc).

Salary: £55,000/£60,000 - based on experience

Benefits: 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. We understand 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 employees be 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 or belief, disability or age.

Contact

Tim Kent

Morgan Philips Specialist Recruitment

United Kingdom

Send job by email

Apply for ETL/Cube Developer - SSIS/SSAS/SSRS - PowerBI
Job Reference: UK858721

Please complete all required fields marked *

*

*

*

*

*
Choose file from

Only MS Word, PDF, HTML and text formats.

Issues applying with LinkedIn? Click here

*
I have read the Privacy Notice.