D365 F&O Technical Lead Consultant & BI Developer

Job Title: D365 F&O Technical Lead Consultant & BI Developer

Position Type: Hourly Contract

Experience: 6+ years
Role Type: Lead D365 F&O Technical Consultant
Pay Rate: $15/hour (processed monthly)
Work Hours:

• Must have 3–4 hours overlap with US CST (approx. 6 PM – 10 PM IST)
• Remaining hours can be in IST to collaborate with other resources

About the Role

We are seeking a rare hybrid professional, a D365 F&O Technical Expert & BI Developer to lead both the customization of our ERP environment and the evolution of our enterprise analytics. This is a "full-stack" technical role: you will be responsible for modifying the core behavior of D365 F&O through X++ development and ensuring that data flows seamlessly into a high-performance Azure Analysis Services (AAS) and Power BI ecosystem.

What You Will Do

• D365 X++ Customization: Act as the lead developer for system enhancements and Change Requests (CRs). This includes writing X++ code, creating extensions (Chain of Command), developing new forms, and modifying business logic across Finance, Supply Chain, and Operations modules.
• Data Engineering & Exposure: Identify, create, and extend Data Entities and Aggregate Measurements. You will ensure that any new business logic or custom fields created in X++ are properly architected to be exposed for downstream reporting.
• SQL Data Architecture: Ownership of the reporting database layer. You will write advanced T-SQL queries, design optimized Views, and manage Primary/Foreign Keys to transform normalized ERP tables into a performant Star Schema.
• Semantic Modeling (AAS): Architect and maintain enterprise tabular models in Azure Analysis Services (AAS). This involves defining relationships, managing partitions, and developing complex DAX measures for business KPIs.
• Enterprise Reporting: Develop interactive Power BI dashboards for real-time data exploration.
• Author Paginated Reports (RDL) for pixel-perfect, high-volume documents like Invoices, Statements, and Regulatory filings.

Required Qualification

• X++ Mastery: 5+ years of hands-on experience in D365 F&O technical development. Deep expertise in AOT, Extensions, Event Handlers, and the SysOperation/Batch frameworks.
• SQL Expert: Mastery of T-SQL with a focus on data warehousing, including query optimization, indexing strategies, and complex joins across ERP schemas.
• BI Architecture: Proven experience building and deploying Azure Analysis Services (AAS) models and writing advanced DAX.
• Reporting Tools: Advanced proficiency in Power BI Desktop, Power BI Service, and Power BI Report Builder.
• Techno-Functional Insight: Ability to translate a business requirement into a technical X++ change and subsequently into a BI data point.

Must-Have Skills:

• D365 F&O Technical Depth
• Advanced SQL
• Azure Analysis Services (AAS)

Good To Have Skills

• Integration Expertise: Knowledge of OData, Dual-write, or Business Events.
• LCS & ALM: Experience managing code deployments via Lifecycle Services (LCS) and Azure DevOps build pipelines.
• Performance Tuning: Experience using Trace Parser or SQL Execution Plans to troubleshoot performance bottlenecks in both the ERP and the BI layer.
• Power BI
• DAX

Additional Details

• Client interview required before onboarding.
• Work closely with US-based stakeholders and Indian team members.
• Contract position with monthly payout at $15/hour.

How to Apply

Send your resume and a brief note highlighting your relevant experience to "recruitment@truvantconsulting.com" with the subject line:
“Lead D365 F&O Technical Consultant & BI Developer”

Job Types: Part-time, Contractual / Temporary, Freelance
Contract length: 2 months

Pay: ₹1,300.00 per hour

Expected hours: 15 – 20 per week

Benefits:

• Flexible schedule
• Work from home

Application Question(s):

• If I asked you to build a view for 'Customer Invoiced Revenue' that includes the Customer Name, Invoice Date, and the Financial Dimension 'Department', which core tables would you join? How would you handle the fact that Financial Dimensions are stored in a single field or a complex attribute table?
• When building a tabular model in AAS for Inventory Aging, do you prefer to perform complex calculations in the SQL View (source) or via DAX measures? Why?

Also, how would you handle a situation where the AAS model refresh is taking too long?

• The CFO needs a monthly "Balance Sheet" and the Sales Team needs an "Interactive Pipeline Dashboard".

Describe your approach to building these two requests. Would you use the same tool? How do you handle 'Print-to-PDF' requirements for the Balance Sheet while ensuring the Sales Dashboard is near real-time?

Experience:

• Microsoft Dynamics 365: 6 years (Required)
• SQL: 5 years (Required)
• Power BI: 3 years (Required)
• Azure Analysis Services : 2 years (Required)

Language:

• English (Required)

Work Location: Remote