Data Solutions Architect
Core
Designing and owning end-to-end data architecture on Microsoft Fabric and Power BI to translate complex data into actionable business insights for executive-level reporting.
Role type
Senior Data Solutions Architect (Microsoft Fabric & Power BI)
Builds
Scalable, governed data foundations (medallion architecture) and high-performance Power BI dashboards for Finance Business Partnering and FP&A.
Domain
Manufacturing/Engineering industry, Data Engineering & Business Intelligence
Required skills
Medallion architecture (Bronze/Silver/Gold), PySpark, Spark SQL, Microsoft Fabric (Lakehouse, Pipelines, OneLake), Dimensional modeling (Star Schema), DAX, Power BI, SQL, Data quality testing & reconciliation
Preferred skills
Microsoft Dynamics 365 (F&O, C&O), ERP systems (SAP, NetSuite), Direct Lake, REST API integration, CI/CD pipelines
Technologies
Microsoft Fabric, Power BI, PySpark, Spark SQL, D365 Finance & Operations, D365 Customer Engagement, Arena PLM, Delta Lake, Git
Responsibilities
Design and maintain medallion architecture in Fabric Lakehouse; Develop Spark notebooks and pipelines for data ingestion and transformation; Build and optimize Power BI reports and semantic models; Act as strategic partner to management to identify reporting needs and define KPIs; Establish data governance, best practices, and testing/validation standards; Lead transition to predictive analytics.
Seniority
Senior, hands-on IC