Data Analyst

GAK ENTERPRISES LTD; Milton Keynes; On-site; GBP 40,000 - 60,000; Full time

Job summary

A data solutions company located in the UK is seeking a skilled individual to gather client requirements, support Azure migration, and optimize SQL queries. Responsibilities include building ETL pipelines and ensuring compliance with data governance. The ideal candidate has experience with Power BI and Agile methodologies. This position offers an opportunity to work on impactful data solutions in a collaborative environment.

Responsibilities

• Gather client requirements and build technical designs.
• Support Azure migration and enhance scalability.
• Build and optimize SQL queries for reporting.
• Automate reconciliation processes for self-service BI.
• Collaborate with clients to ensure accuracy of datasets.
• Implement role-based security for reports.

Skills

Data analysis

Azure migration

SQL queries

ETL processes

Power BI

Agile project management

Data governance compliance

API testing

Tools

Informatica PowerCenter

Azure SQL

SQL Server

Microsoft Excel

Job description

Responsibilities & Skills

• Gather client requirements, build technical designs and translate complex data into business insights.
• Support Azure migration, enhance scalability and centralize reporting for enterprise clients.
• Build and optimize SQL queries and ETL pipelines for enterprise reporting and BI analysis.
• Automate reconciliation processes and develop parameterized/ad hoc reports for self-service BI.
• Collaborate with clients and QA teams to ensure accuracy, usability, and performance of analytical datasets.
• Implement role-based security and data governance compliance for enterprise reports.
• Develop and optimize stored procedures and queries to support operational and analytical systems.
• Project & Collaboration: Agile (Kanban, SAFe), Jira, stakeholder engagement, requirements gathering, project scoping
• Databases & Data Modeling: T-SQL, SQL Server, DB2, Azure SQL, Data Warehouse architecture
• ETL / Data Pipelines: Informatica PowerCenter, Control-M
• Programming & Tools: VBA (basic), .NET, PowerShell, API testing
• Version Control & CI/CD: GitHub, Tortoise SVN, Continuous Integration methodologies
• Data Governance & Security: Role-based access, encryption, dynamic masking, data quality management
• BI & Reporting: Power BI, SSRS, Microsoft Excel