We are seeking an experienced ETL Developer with hands-on expertise in azure data factory development. This role is integral to building robust, scalable data integration solutions to streamline data flows across our data lakes and data warehouses. The ideal candidate will also possess strong knowledge of Power BI for reporting and visualization, with the added advantage of Purview experience for data governance and lineage. While some flexibility may be offered, this role requires a consistent on-site presence at our corporate office in Canonsburg, PA to support key meetings, collaboration, and team functions. Key Responsibilities: Design, develop, and implement ETL processes to extract, transform, and load data across various systems and databases, including data lakes and data warehouses. Develop and maintain data pipelines using ADF, ensuring high-quality, efficient, and scalable data flows. Integrate data sources from both on-premises and cloud environments. Work closely with data architects and analysts to ensure proper mapping, transformation, and structuring of data to meet business needs. Implement and manage data lakes and data warehouses with an emphasis on performance, scalability, and security. Optimize and troubleshoot ETL processes to improve data processing speed and efficiency. Create Power BI dashboards and reports based on data warehouse/lake data, ensuring actionable insights for business stakeholders. Support data governance processes, leveraging tools like Azure Purview to ensure data quality, security, and lineage. Collaborate with cross-functional teams, including business analysts, data engineers, and data scientists, to understand data requirements and ensure data availability. Provide ongoing maintenance and support for the ETL pipeline infrastructure. Required Skills: Proven experience as an ETL Developer, Data Engineer, or similar role, with strong expertise in ADF development. Solid experience working with data lakes and data warehouses, preferably in a cloud environment (Azure preferred). Hands-on experience with Power BI, including creating interactive reports, dashboards, and visualizations. Strong SQL skills for data extraction, transformation, and querying. Familiarity with Azure Purview for data governance, cataloging, and lineage tracking. Solid understanding of data integration principles, including data modeling, data profiling, and data cleansing techniques. To view the full job description please use the link below. https://www.aplitrak.com/?adid=YmJnZW5lcmljLjExMjE2LjEwODY1QG1heGltY3JhbmVjb21wLmFwbGl0cmFrLmNvbQ

Maxim Crane Works LLC

Latest Jobs

Senior ETL Developer