Data Solution Architect Experience With Azure Fabric, Azure Data Factory (ADF), Azure Synapse Data Warehouse ETL At Jefferson City, MO

Role Data Solution Architect

Location Jefferson City, MO

Duration 12 Months

Primary Skills: Azure Fabric, Azure Data Factory (ADF), Azure Synapse Data Warehouse ETL

Solution Architect deep understanding of Microsoft data services, including Azure Fabric, Azure Data Factory (ADF), Azure Synapse, and ETL/ELT processes.

Key Responsibilities:

• Provide technical leadership in modernizing legacy data ingestion, ETL/ELT, and databases to cloud technologies (AWS/Azure).
• Design and map ETL/ELT pipelines for new or modified data streams, ensuring integration into on-prem or cloud-based data storage.
• Automate, validate and maintain ETL/ELT processes using technologies such as Databricks, ADF, SSIS, Spark, Python, and Scala
• Conduct unit, system, and integration testing for ETL/ELT solutions, ensuring defects are resolved.
• expertise in data warehousing concepts (ETL/ELT, data quality management, privacy/security, MDM) with hands-on experience using ADF, Data Factory, SSIS, and related tools.
• experience with cloud data and cloud-native data lakes/warehouses. Microsoft Azure services (Fabric Lakehouse, ADF, Data Factory, Synapse, etc.