Senior Data Analyst

Job Summary:

• We are seeking a skilled Data Analyst with expertise in Microsoft Dynamics 365, Power Platform, Dataverse, and Power BI to support enterprise reporting, analytics, and business intelligence initiatives. The ideal candidate will be responsible for gathering, analyzing, and visualizing data from Dynamics 365 and related systems to provide actionable insights that drive business decisions.
• The successful candidate will collaborate with business stakeholders, functional teams, and technical teams to develop dashboards, reports, and data solutions that improve operational efficiency and data-driven decision-making.

Responsibilities:

• Analyze business data from Dynamics 365 Customer Engagement (CE), Finance & Operations (F&O), and Dataverse.
• Create and maintain interactive dashboards, reports, and scorecards using Power BI.
• Gather and document business reporting requirements from stakeholders.
• Develop KPIs, metrics, and analytical models to identify business trends and opportunities.
• Design and optimize data models for reporting and analytics.
• Extract, transform, and analyze data using SQL, Power Query, and Power Platform tools.
• Build automated reporting solutions using Power Automate and Power Platform.
• Ensure data accuracy, integrity, and consistency across multiple business applications.
• Collaborate with Dynamics 365 administrators, developers, and business users to improve data quality.
• Perform data validation, cleansing, and reconciliation activities.
• Support data migration and integration initiatives involving Dynamics 365 and external systems.
• Provide recommendations based on analytical findings and business insights.
• Create documentation and train end users on reports and dashboards.

Experience:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field.
• 5+ years of experience as a Data Analyst, Business Intelligence Analyst, or Reporting Analyst.
• Hands-on experience with Microsoft Dynamics 365 and Microsoft Power Platform.

Strong expertise in:

• Power BI
• Dataverse
• Power Query
• Power Automate
• Advanced Excel
• Experience developing SQL queries, stored procedures, and data analysis solutions.
• Strong understanding of relational databases and data modeling concepts.
• Experience working with large datasets and enterprise applications.
• Excellent analytical, problem-solving, and communication skills.
• Ability to translate business requirements into data-driven solutions.

Nice to Have:

• Experience with:
• Dynamics 365 Sales
• Customer Service
• Finance & Operations
• Marketing/Customer Insights
• Knowledge of Azure data services including:
• Azure SQL Database
• Azure Data Factory
• Azure Synapse Analytics
• Microsoft Fabric
• Experience supporting CRM and ERP reporting environments.
• Familiarity with ETL processes and data warehousing concepts.
• Microsoft certifications in Power BI, Power Platform, or Dynamics 365.