Data Warehouse BI Architect Fabric
canyon associatesEatontown NJ On site (Fridays WFH) 125-180k bonus eligilbe 7+ years of experience in data engineering, data architecture, or BI development, including 2+ years with Microsoft Fabric or Azure Synapse. Proven experience designing data warehouses, dimensional models, and ETL/ELT pipelines. Proficient in SQL (T-SQL) and Python/PySpark for data processing and automation. Experience with Power BI, Azure Data Factory or Fabric Pipelines, OneLake, and Lakehouse architecture. Experience integrating REST APIs, webhooks, and partner data. Experience with Delta Lake / Parquet optimization (Z-ordering, partitioning, compaction) Experience of Dimensional modeling (Kimball) and medallion architecture (bronze/silver/gold). Strong understanding of data governance, metadata management, and data security. Hands-on experience implementing CI/CD for data solutions using Git / Azure DevOps. Strong analytical, problem-solving, and communication skills. -175k , bonus eligible position Pay: $130,000.00 - $180,000.00 per year Benefits: 401(k) 401(k) matching Dental insurance Flexible spending account Health insurance Health savings account Life insurance Paid time off Professional development assistance Tuition reimbursement Work Location: In person