Data Engineer & Reporting Analytics Consultant

Fftalos Technologies; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Fftalos Technologies is seeking a Data Platform Engineer in the United States to design and maintain data pipelines using Microsoft Fabric and Azure Data Factory. You will build a Lakehouse architecture, implement Bronze-Silver-Gold layers, and ingest data from Dynamics 365 and other sources to deliver analytics-ready datasets and dashboards.

The role requires advanced SQL, data modeling, and strong Power BI capabilities.

Qualifications

• Experience with Microsoft Fabric and Azure Data Factory.
• Ability to implement Medallion Architecture (Bronze, Silver, Gold).
• Ingest data from Dynamics 365 CE and Dynamics 365 F&O, SQL databases, APIs, and files.
• Develop data loading frameworks with incremental and watermark-based approaches.
• Create fact and dimension models optimized for analytics and reporting.
• Develop and support Power BI datasets, reports, and dashboards.
• Troubleshoot pipeline failures, data-quality issues, and performance bottlenecks.
• Support Git, Azure DevOps, CI/CD, and deployment processes.

Responsibilities

• Design and maintain data pipelines using Microsoft Fabric and Azure Data Factory.
• Build and manage Lakehouse, Warehouse, Dataflows, and Data Pipelines.
• Implement Medallion Architecture (Bronze, Silver, Gold).
• Ingest data from Dynamics 365 CE, Dynamics 365 F&O, SQL databases, APIs, and files.
• Develop incremental and watermark-based data loading frameworks.
• Create fact and dimension models optimized for analytics and reporting.
• Develop and support Power BI datasets, reports, and dashboards.
• Troubleshoot pipeline failures, data-quality issues, and performance bottlenecks.
• Support Git, Azure DevOps, CI/CD, and deployment processes.

Skills

Advanced SQL

Data transformation

Data modeling

Medallion Architecture implementation

Power BI data modeling

Tools

Microsoft Fabric (Lakehouse, Warehouse, Dataflows, Pipelines)

Azure Data Factory

Dynamics 365 CE integration

Dynamics 365 F&O integration

Power BI

Git

Azure DevOps

CI/CD

Job description

Key Responsibilities

• Design and maintain data pipelines using Microsoft Fabric and Azure Data Factory.


• Build and manage Lakehouse, Warehouse, Dataflows, and Data Pipelines.


• Implement Medallion Architecture (Bronze, Silver, Gold).


• Ingest data from Dynamics 365 CE, Dynamics 365 F&O;, SQL databases, APIs, and files.


• Develop incremental and watermark-based data loading frameworks.


• Create fact and dimension models optimized for analytics and reporting.


• Develop and support Power BI datasets, reports, and dashboards.


• Troubleshoot pipeline failures, data-quality issues, and performance bottlenecks.


• Support Git, Azure DevOps, CI/CD, and deployment processes.

Required Skills

• Microsoft Fabric (Lakehouse, Warehouse, Dataflows, Pipelines).


• Medallion Architecture implementation experience.


• Azure Data Factory and Fabric Data Pipelines.


• Advanced SQL and data transformation skills.


• Dynamics 365 CE and Dynamics 365 F&O; integration experience.


• Fact and Dimension modeling expertise.


• Power BI data modeling and reporting.


• Git, Azure DevOps, and CI/CD knowledge.