Azure & Microsoft Fabric Data Engineer & Architect

Stand8 Technology Consulting provides end-to-end IT solutions to enterprise partners across the United States. They are seeking a Microsoft Fabric Architect to support a financial initiative focused on building a next-generation financial data platform, blending strategic architecture with hands-on engineering to develop advanced data processing pipelines using Microsoft Fabric and Azure services.

Responsibilities:

• Architect, design, and hands-on develop end-to-end data solutions using Azure Data Services and Microsoft Fabric
• Build and maintain complex data models in Azure SQL, Lakehouse, and Fabric environments that support advanced financial calculations
• Lead and execute data migration efforts from multiple upstream and legacy systems into Azure and Fabric
• Develop, optimize, and maintain ETL/ELT pipelines using Microsoft Fabric Data Pipelines, Data Factory, and Azure engineering tools
• Perform hands-on SQL development, including stored procedures, query optimization, performance tuning, and data transformation logic
• Partner with finance, engineering, and product stakeholders to translate requirements into scalable, maintainable data solutions
• Ensure data quality, lineage, profiling, and governance across ingestion and transformation layers
• Tune and optimize Azure SQL databases and Fabric Lakehouse environments for performance and cost efficiency
• Troubleshoot data processing and pipeline issues to maintain stability and reliability
• Document architecture, data flows, engineering standards, and best practices

Requirements:

• Experience Leading Microsoft Fabric Migrations
• Microsoft Azure Tools Experience
• Expert, hands-on experience with Azure Data Services (Azure SQL, Data Factory, Data Lake Storage, Synapse, Azure Storage)
• Experience designing a Fabric Platform and POC
• Deep working knowledge of Microsoft Fabric, including Data Engineering workloads, Lakehouse, Fabric SQL, Pipelines, and governance
• Strong experience designing and building data models within Azure SQL and Fabric architectures
• Proven track record delivering large-scale data migrations into Azure environments
• Advanced proficiency in SQL/T-SQL, including stored procedures, indexing, and performance tuning
• Demonstrated success building and optimizing ETL/ELT pipelines for complex financial or multi-source datasets
• Understanding of financial systems, data structures, and complex calculation logic
• Excellent communication and documentation skills with the ability to collaborate across technical and business teams