BI Developer (Analyst)

Department: BI
Location: Manchester

Key Responsibilities

  • Review and refine /evolve existing data warehouse, extending scope from current sales reporting focus to providing a data platform for the wider business
  • Define core data requirements with stakeholders across the business, identifying all data inputs from internal and external data source
  • Set-up data transfer processes and schedule from input data sources
  • Where applicable, in conjunction with stakeholders, design & create input templates and ETL processes for the SQL data warehouse
  • In conjunction with IT department, manage and maintain DB server(s) and data flows to ensure:
    • reliable data delivery through robust data transfer process
    • database integrity through best practice design and adequate back-up processes
    • high availability and performance monitoring
    • services and components meet agreed performance targets and service levels
    • security, access control permissions and privileges
  • Build SQL queries (procedures and views) to support reporting outputs
  • Advise & assist on creation of reporting outputs, including within Power BI
  • Build alerting system for data warehouse covering status and data changes

Essential skills

  • MS SQL server (SSIS / SMSS, potentially SRSS) within a data warehouse and BI / MI reporting environment
  • SSIS package design and development
  • Advanced SQL to DBA standard
  • Familiarity with ERP/CRM datasets (Salesforce desirable) and BI reporting tools
  • Experience working with large complex data sets
  • Strong communication and stakeholder management skills

Desirable skills

  • BI reporting tools (Power BI desirable)

How to Apply:

Please email your CV and cover letter to careers@m247.com

By applying for a role, you are agreeing to our Candidate Privacy Notice, which you can access here.

All applicants, regardless of gender, ethnic background, sexual orientation, age, religion, socio-economic status or any other factor will be treated equally and fairly in the application process.

Sales: 0808 253 6500

Support: 0161 822 2580

Email us

To find out how our technology can transform your business get in touch

Share this job