MSBI Consultant

Job title:

MSBI Consultant

Company

NConsulting

Job description

JOB SUMMARYThe purpose of this position is to lead various BI development teams from technical standpoint ensuring efficient BI operations leading to optimum performance. Work closely with BI development & analytics teams during the design and hands-on implementation of multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics and reporting solutions.MAIN DUTIES

• Define, deliver, and continually improve the strategic technical data implementation capability including core processes, tools and standards, including cloud-based technology

• Strategically deliver consistent data solutions that align to the Data Management Standards/Policies whilst balancing pragmatism towards improving business developed solutions

• Create, optimise, and schedule ETL packages, analysis services cubes and reporting/information systems ensuring all developed components adhere to published standards and conventions.

• Work alongside BI Analysts to gather requirements through solicitation sessions with business users and translate requirements into technical architecture vision and implementation plan.

• Be responsible as the technical owner of the Chaucer’s enterprise Data warehouse and assume architecture, design decision duties and the impact of changes to overall data ecosystem

• Working with internal departments, external data suppliers and business partners to source new datasets that will grow and enhance data driven decisions

• BI development – ensure that our Data warehouse development standards are aligned to our SDLC and data strategy and that our systems are reliable, scalable, and relevant and appropriate while promoting best practices within the BI development teams.

• Plan and organise the translation of functional specifications into technical design and test scenarios and execute test plans.

• Commitment to continuous development through structured skills and personal or professional competence enhancement programmes.

• Lead team members, providing guidance, motivation and direction to ensure work is produced to a good and consistent standard.

• Work alongside various scrum teams following agile methodologies and manage incoming demands and instil agile best practices within the BI development teams. Also work with product owners and other leads in the data teams to assist with strategic initiatives.

• Understands Policy, Strategy, Data and Information Governance in relation to enterprise data warehouse

OUR REQUIREMENTSRELEVANTEXPERIENCEEssentialAt least 5 years of Business Intelligence & Data warehouse development experienceAt least 2 years of team lead experienceTECHNICAL SKILLSEssentialSQL Server (Advanced)SQL Server SSIS (Advanced)SQL Server SSRS (Advanced)SQL Server SSAS (Advanced)SQL Server MDS (Advanced)Kimball Design Principles (Advanced)DevOps (Intermediate)DesirableTableau (Intermediate)MS Office (Intermediate)Power BI (Intermediate)Experience or keen interest in cloud Services in Data & BI space such as Snowflake, Azure or AWS offeringsEDUCATION ANDQUALIFICATIONSDesirableDegreePERSONAL SKILLSEssentialWell-presented and business-likeProfessional outlookFlexible at all timesVery good interpersonal skillsExcellent organisational skillsExcellent communication skills with the ability to liaise at all levelsWork as part of a teamAdapt to a pressured environmentSelf-motivated

Expected salary

£60000 – 65000 per year

Location

London

Job date

Sat, 08 Jun 2024 00:43:17 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.org) you saw this job posting.