Job Description
Data Engineer – MS Fabric - Chicago, IL (Hybrid) We’re looking for a hands-on Data Engineer to help ingest, transform, manage, and deliver trusted data and insights across investment, finance, and risk teams as the organization is modernizing its enterprise analytics platform using Microsoft Fabric. This role sits within the Data Engineering team and focuses on building and operating lakehouse-based analytics solutions end to end. What You’ll Do Build data pipelines in Microsoft Fabric ingesting data from: External files (CSV, XML, Excel, vendor feeds) SQL Server databases SharePoint and other enterprise sources Implement Bronze (raw), Silver and Gold (business-ready) layers in Fabric Lakehouse Design patterns and develop ETL/ELT processes Create semantic models for agentic frameworks and reporting Participate in Fabric environment management including workspaces, capacities, access, and promotion across environments Apply data governance, quality, and security standards Collaborate with enterprise engineering and Investments business and technology teams What You Bring 3+ years of experience in building implementing data engineering solutions Hands-on experience with Microsoft Fabric, including: Lakehouse, OneLake, Pipelines, Notebooks, DataFlow Gen2, Power Query Workspace, capacity, and environment management Strong SQL (T-SQL/Spark SQL) Strong PySpark/Python skills including experience using Dataframes Experience building Data Models. Experience with Semantic models preferred. Experience working with SQL Server and file-based data sources Strong collaboration and communication skills Nice to Have Financial services or investment data experience Experience developing Power BI reports and Data Agents