ETL/Cube Developer – SSIS/SSAS/SSRS – PowerBI | Morgan Philips Specialist Recruitment

Morgan Philips Specialist Recruitment

Job Title: ETL/Cube Developer – SSIS/SSAS/SSRS – PowerBI
Employer: Morgan Philips Specialist Recruitment
Location: Hertfordshire, United Kingdom
Employment Type: Permanent
Reference Number: 88717f03-43d9-48a6-96fd-df61d0fc27bf


Job Details:

Data Warehouse ETL and Cubes Developer


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.



Apply for this ETL/Cube Developer – SSIS/SSAS/SSRS – PowerBI job vacancy via Bubble Jobs today.  You can find other jobs like this ETL/Cube Developer – SSIS/SSAS/SSRS – PowerBI job vacancy in Hertfordshire with our simple job search feature. As well as advertising vacancies like this ETL/Cube Developer – SSIS/SSAS/SSRS – PowerBI job vacancy, Bubble Jobs specialises in advertising web jobs, digital jobs, tech jobs and other specialist jobs for a wide range of employers and recruiters. If you’re looking for career advice or job searching tips, then make sure you check out our blog which is updated regularly with useful advice and resources.  Don’t forget to follow us on Twitter to get the latest job updates and addition career related news and posts. Thanks for using Bubble Jobs and good luck with your job search.

Skip to content