Job Description

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