Systems Architect Iii

The Systems Architect III will be responsible for modernizing legacy BI and data platforms by leading migrations from on-premise SQL Server ecosystems to cloud-native Microsoft analytics solutions. This role focuses on Power BI development, SSRS/SSAS modernization, and building scalable data engineering pipelines using Azure and Microsoft Fabric technologies. The ideal candidate will have strong hands‑on experience in BI reporting, data engineering, and large‑scale migration initiatives.Key Responsibilities
Lead migration of legacy SSRS (Paginated Reports) to modern Power BI dashboardsDesign, develop, and optimize Power BI reports using DAX and Power QueryOptimize report performance and enable efficient export of large datasetsBuild and maintain ETL pipelines using Azure Data Factory and Azure DatabricksQuery, transform, and validate data throughout the migration lifecycleImplement DirectQuery, composite models, and aggregations to manage large data volumesModernize SSAS Tabular or Multidimensional models to Microsoft Fabric semantic modelsWork with MS Fabric components including OneLake, Data Engineering, and Data FactoryEstablish CI/CD deployment pipelines for Power BI and Fabric artifactsImplement data governance practices including RLS, security, and data lineageCollaborate with stakeholders to ensure successful platform modernizationEnsure reliability, scalability, and performance of BI and analytics solutionsRequired Skills
Strong experience migrating SSRS to Power BI5+ years of Business Intelligence and Data Engineering experience requiredHands‑on experience with Azure Data Factory and Azure DatabricksStrong SQL skills for querying and transforming dataExperience managing large datasets and performance tuningKnowledge of DirectQuery, composite models, and aggregationsStrong problem‑solving and analytical skillsPreferred Skills
Experience migrating SSAS models to Microsoft FabricHands‑on knowledge of Microsoft Fabric (OneLake, Direct Lake, Data Engineering)Experience with CI/CD pipelines for Power BI and FabricUnderstanding of data governance, RLS, and data lineageFamiliarity with DevOps practices in BI environmentsEducation
Bachelor’s Degree in Computer Science, Information Technology, Data Analytics, or related field
#J-18808-Ljbffr