Business Analyst with MS stack

E-Solutions; United Kingdom; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading company in the UK is seeking a Business Analyst to enhance the Marketing department's analytics capabilities. The successful candidate will be responsible for using Data Factory and Databricks to analyze customer data, while also collaborating closely with various stakeholders. This role requires a strong background in data analysis, with proficiency in tools such as Power BI and SQL Server, and at least 3 years of relevant experience. The position offers a competitive benefits package and opportunities for professional growth.

Benefits

A competitive and comprehensive benefits package

Qualifications

• 3+ years of experience as a Business Analyst.
• Strong knowledge and hands-on experience with Power BI and SQL Server.

Responsibilities

• Use Data Factory and Databricks for P&L analytics.
• Collaborate with stakeholders to gather and analyze business requirements.
• Support data integration and transformation using MS stack.
• Provide training and support on analytical tools.

Skills

Power BI

SQL Server

T-SQL

Education

Bachelor's degree in business, Information Systems, Computer Science, or related field

Job description

Key Responsibilities: • Use Data factory, Databricks to combine source with customer data for Marketing department for P&L analytics. • Collaborate with stakeholders to gather, analyze, and document business requirements and translate them into functional specifications. • Use Microsoft tools such as Power BI, Excel, SQL Server, and Azure to create reports, dashboards, and data visualizations. • Perform data analysis to identify trends, patterns, and opportunities for operational improvements. • Work closely with technical teams to support data integration, transformation, and warehousing using the MS stack (e.g., SSIS, Azure Data Factory). • Support the implementation and ongoing enhancement of Dynamics 365 CRM/ERP solutions. • Develop and maintain documentation, process flows, and user manuals. • Provide training and support to end-users on analytical tools and dashboards. • Participate in Agile/Scrum ceremonies and contribute to iterative solution development. Required Skills & Qualifications: • Bachelor's degree in business, Information Systems, Computer Science, or related field. • 3+ years of experience as a Business Analyst. • Strong knowledge and hands-on experience with: o Power BI o SQL Server / T-SQL

• A competitive and comprehensive benefits package
• A competitive and comprehensive benefits package