Information Analyst – Data Analyst

Experience Required: 5+ years of experience with Microsoft data platform technologies

The Data Analyst will be responsible for designing, implementing, and optimizing data solutions using Microsofts data platform technologies, including Azure Data Services, SQL Server, Power BI, and Fabric. This role involves collaborating with business stakeholders to gather requirements, develop data models, and deliver actionable insights through reports and dashboards.

Key Responsibilities:

• Design, develop, and maintain data models, ETL/ELT pipelines, and data warehouses using Microsoft technologies (SQL Server, Azure Data Factory, Synapse Analytics, Databricks, etc.).
• Analyze business requirements and translate them into technical specifications for data solutions.
• Perform data profiling, cleansing, and transformation to ensure data quality and integrity.
• Collaborate with business data engineers, and BI developers to understand data needs and deliver solutions.
• Collaborate with business stakeholders to understand data needs and translate them into technical requirements.
  
• Implement and maintain data governance, metadata management, and security best practices.
• Troubleshoot and resolve data-related issues and performance bottlenecks.
• Develop dashboards, reports, and KPIs using Power BI and other Office 365 tools (Excel, Power Query, Power Automate).
• Monitor data integrity and work on deduplication, normalization, and enrichment tasks.
• Develop and maintain documentation related to data models, processes, and definitions.
• Perform ad-hoc analysis and deliver data-driven recommendations.

Required Skills & Experience:

• Bachelor&aposs degree in Computer Science, Information Systems, Statistics, Mathematics, Economics, or a related quantitative field.

• Looking to get Placed? Try our Placement Guarantee Plan

  Get Hired
  5+ years of experience as a Data Analyst, Business Intelligence Analyst, or similar role with a strong focus on Microsoft data technologies.
• Strong proficiency in SQL for data querying, manipulation, and database management.
• Expertise in Microsoft Power BI, including: Connecting to various data sources, Data modeling (DAX, relationships), Creating interactive reports and dashboards, Publishing and managing reports in Power BI Service.
• Design, develop, and maintain data pipelines, ETL processes, and data warehouses using Azure Data Factory, Synapse Analytics, SQL Server, and Databricks.
• Proven experience in data cleaning, transformation, and validation.
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Strong communication and presentation skills, with the ability to explain complex data insights to non-technical audiences.