BI Analyst

North Yorkshire
10 Mar 2018
19 Mar 2018
Contract Type
Full Time
We are the fastest growing Marketing Solutions Provider in the UK. To support our large ambition, we have invested heavily into our solutions and as a result have won a number of large retail clients. Our solutions span; Single Customer View, Digital Attribution, Analytics, CRM, Reporting and Data Services. Our mission is to enable and guide our customers to engage more fully and profitably with their customers through the use of data and automation. All of this is underpinned by an ethos of monetisation, measurement and testing. We are growing a team of bold and bright XCM’ers to make this our vision a reality.

Primary Purpose
The primary purpose of the role will be to use the BI stack to produce reports from XCM’s ETL system. The data will be interrogated using SSAS and reports will be developed in Power BI to be both visually impactful and provide insightful information for our customers.

Key Responsibilities
• Develop reports to produce information from the ETL system
• Ownership for numbers and content of reports
• Analyse business requirements and translate them into unambiguous technical requirements
• Will work independently while also operate effectively as part of XCM team
• Troubleshooting and problem solving across the full BI technical estate
• Develop ELT processes using SSIS, SSRS and SSAS
• Develop stored procedures in TSQL

Experience & Qualities
• Highly IT literate with experience of the following BI tools: SQL Server database, SSAS, SSRS, Power BI, other data visualisation tools (e.g. Tableau) and Cloud technologies (Azure)
• Analytical and ability to provide insightful information
• Experience in working with ETL system
• Experiences in documentation and communications in conjunction with end users to gather business process and use-case requirements
• Identifies best practices inscript coding, data analysis and visualisation development requirements
• Must be able to troubleshoot problems on the various components of platforms

Similar jobs

Similar jobs