Data Architect #116
Data Architect, United Wholesale Mortgage, Pontiac, MI.
Design & develop Data Pipelines, Extract, Transform & Load (ETL)/ Extract, Load, Transform (ELT), using SQL Server Integration Service (SSIS), Talend, Azure Synapse Data Pipelines, & Azure Data Factory. Design Online Transaction Processing (OLTP) & Online Analytical Processing (OLAP) data models including dimensional modeling using ER Studio Data Architect. Design & develop SQL Server Analysis Services (SSAS) Multidimensional/Tabular analytical cubes using SQL Server Data Tools (SSDT). Design & develop business-critical reports, dashboards & applications using Microsoft PowerBI & SQL Server Reporting Services (SSRS). Architect & develop Cloud based Data Warehouse & Data Lake using Azure Synapse Analytics. Design & build Machine Learning (ML) data science data pipelines & Python custom libraries. Architect custom system health monitoring applications using SQL Server Dynamic Management Views (DMVs). Design Data Replication using Qlik Replicate &SQL Server Availability Groups (AGs). Architect data retention frameworks using Transact-SQL (TSQL) &Azure Hosted Server less SQL databases.
Bachelor, Computer Science, Computer or Electronical Engrg, Electronics &Telecommunication Engineering, or related. 60 months experience as Engineer, Developer, Architect, Analyst, or related, developing or performing SQL Server TSQL coding, using SSIS, SSAS & SSRS, & performing dimensional data modeling, or related.