Sr. Azure Synapse Data Engineer

10 Jun 2024

Vacancy expired!

Sr. Azure Synapse Data Engineer

Responsibilities
  • Architecture Design – design, develop, and maintain the architecture of the Azure data estate (data lake, SQL analytics store, pipelines, ML/AI environment and network) to meet business requirements.
  • Data Acquisition & Integration – Ensure feeds from various platforms are established, primarily internal but increasingly external.
  • Use programming skills to develop, customize, and manage ingestion tools, storage accounts, and analytical applications including their access.
  • Perform ETL processes for optimal extraction, transformation, and loading of data from a wide variety of data sources using Azure Synapse tools and technologies.
  • Data Pipeline Development/Testing – Test the reliability and performance of each part of a system during the Development phase.
  • Identify, Design, Implement Process Improvements – Automate manual processes, optimize data delivery, and re-design the infrastructure for greater scalability and data quality.
  • Track Pipeline Stability – Monitor the overall performance and stability of the system and ensure the automated parts/scheduled tasks are monitored.
  • Manage structured and unstructured data and metadata stored in the data estate.
  • Ensure availability of clean, transformed data to meet business needs.
  • Partner with IT Operations to provide business Intelligence tools/infrastructure.
  • Set-up tools, views, and access permissions for different user groups, enabling them to view data, generate reports, and create visuals.
  • Data Strategy – Contribute to the broader organizational data strategy including data privacy and governance practices.
  • Develop strong relationships with key stakeholders across the business and help determine critical objectives.

Requirements
  • Experience with Microsoft Azure Synapse.
  • End-to-end data warehouse experience.
  • Ability to build processes supporting data transformation, data structures, metadata, dependency, and workload management, as well as the ability to manipulate, process, and extract value from large, disconnected, structured and unstructured datasets.
  • Experience with SQL, SSIS.
  • Experience performing root cause analysis on data, ability to answer specific business questions and identify opportunities for improvement.
This a 6 month Contract-to-Hire opportunity with our Lenexa, KS client. 100% Paid employee medical/Dental Benefits, Paid time off, Paid Holidays, and 401(k) (with immediately-vested company match) available with TriCom during the contract period. H-1B Visa sponsorship is not available for this opportunity. No third-parties, please.

  • ID: #42727944
  • State: Kansas Lenexa 66215 Lenexa USA
  • City: Lenexa
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-06-10
  • Deadline: 2022-08-05
  • Category: Et cetera