Developer / Reporting / BI Analyst - Leeds

Interface Recruitment UK; Leeds; On-site; GBP 30,000 - 50,000; Full time

Job summary

An established industry player is seeking a Reporting / BI Analyst to enhance reporting efficiency and support ongoing development projects. This role involves querying and extracting data from SQL databases, designing automatic reports using MS products, and collaborating with the sales and marketing team to analyze data. The ideal candidate will possess strong analytical skills, a can-do attitude, and expertise in Microsoft Excel, SQL, and Visual Basic. Join a dynamic team where your contributions will drive business improvements and innovations in IT solutions.

Qualifications

• Strong analytical skills and a can-do attitude are essential.
• Proven experience with SQL and Visual Basic programming.

Responsibilities

• Develop efficient systems and databases for reporting.
• Assist in ongoing development projects and provide IT support.

Skills

Analytical Skills

Curiosity

Microsoft Excel

Visual Basic

SQL

Power BI

PowerShell

PowerApps

Tools

MS Excel

Power BI

MS Query

Job description

Reporting / BI Analyst

Gain an understanding of systems and databases at the department's disposal and the constraints of each. Develop them to become more efficient.

Present new ideas to take the business forward & assist in ongoing development projects, for e.g. CRM, Sales force, Ecommerce, Barcode reading.

Complete reports as required that involve querying, extracting and gathering data from multiple sources including SQL databases.

Design and implement automatic reports/alerts within the MS range of products, including Excel, MS Query, VB, Powershell & Power BI.

Work closely with the commercial manager, sales & marketing team to provide and analyse data and help focus these resources.

Using your knowledge and new IT solutions, assist the Commercial Manager to analyse areas of the business and job-specific tasks that will benefit from automation and efficiencies.

Day-to-day IT support and assisting the IT Manager in maintaining various software applications and associated hardware, including PC’s, servers, scanners, printers, security equipment, and telecommunications equipment.

Any administrative duties as required within the role or additional duties as requested.

Essential Skills and Experience Required:

• Must be curious and analytical.
• Can-do attitude with a willingness to help out with all aspects of IT.
• Good knowledge of PC’s and Servers.
• Strong Microsoft Excel skills:
  • Vlookup, Hlookup, Pivot Table, Charts, Nested If, Countif, Countifs, Sumif, Sumifs, Sum product, Index, Match, Conditional Formatting, Slicer, etc.
• Proven programming experience using Visual Basic.
• Sound experience in SQL.
• Power BI / Powershell / Powerapps.
• Experience working with Sensitive Data.