Overview
Skills
Job Details
Technical Skills:
Microsoft Dynamics 365 Customer Service – 3 to 5 years
Microsoft Power Query – 3 to 5 years
Role Description:
· Power BI Development:
Design, develop, and deploy Power BI dashboards and reports that leverage data from Microsoft Dynamics applications.
· Dynamics Data Integration:
Connect Power BI to Dynamics 365 (via Dataverse, OData feeds, or APIs), ensuring seamless data extraction, transformation, and loading (ETL).
· Data Modeling:
Build and optimize data models that accurately represent Dynamics business processes and relationships.
· Requirements Gathering:
Collaborate with business users, Dynamics administrators, and IT teams to understand reporting needs and translate them into technical solutions.
· Performance Optimization:
Monitor and enhance the performance of Power BI solutions, including data refresh, query optimization, and report responsiveness.
· Documentation:
Document data models, integration processes, and report logic for maintainability and knowledge sharing.
· User Support & Training:
Provide support and training to end-users on accessing and interpreting Power BI reports connected to Dynamics data.
· Best Practices & Governance:
Promote data governance, security, and Power BI best practices, especially in the context of Dynamics data.
Required Qualifications:
· Bachelor’s degree in - Computer Science, Information Systems, Data Analytics, or a related field.
· 2+ years of experience developing Power BI solutions, including direct integration with Microsoft Dynamics 365.
· Proficiency in DAX, Power Query (M), and Power BI data modeling.
· Experience with Microsoft Dataverse, OData, and Dynamics 365 Security.
· Strong understanding of Dynamics 365 data structures, entities, and business processes.
· Familiarity with data security, compliance, and governance in a Dynamics environment.
· Excellent analytical, problem-solving, and communication skills
Preferred Qualifications:
· Experience with MS Dynamics products at the Department of Veteran’s Affairs
· Microsoft Power Platform or Dynamics 365 certifications.
· Experience with other BI tools or scripting languages (Python, R) for data analysis.