Data Designer, Contracts
Indigo Slate
ETLPythonSQLTableau
Job Level
JuniorMid-Level
Tech Stack
ETLPython
About the role
- VetsEZ is seeking an experienced Power BI Engineer with expertise in integrating and developing business intelligence solutions using Microsoft Dynamics products (such as Dynamics 365 Sales, Customer Service, Finance, or Supply Chain). The ideal candidate will bridge the gap between Dynamics data and actionable insights, enabling stakeholders to make informed business decisions through advanced analytics and interactive dashboards. The candidate must reside within the continental US. Responsibilities: 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.
Requirements
- Bachelors 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 Additional Qualifications: Experience with MS Dynamics products at the Department of Veterans Affairs Microsoft Power Platform or Dynamics 365 certifications. Experience with other BI tools or scripting languages (Python, R) for data analysis. Knowledge of Power BI administration and workspace management. Prior experience collaborating with Veterans Affairs stakeholders to optimize CRM workflows and enhance service delivery. Demonstrated experience implementing or supporting CRM systems (e.g., Microsoft Dynamics) within a federal agency environment. Proven knowledge of Department of Veterans Affairs operations, policies, and programs, with an emphasis on client-facing technology solutions.
