Senior ETL Developer

We are seeking a Senior 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.
• Strong problem-solving skills and the ability to troubleshoot data pipeline issues.
• Experience with version control systems (e.g., Git) and CI/CD pipelines.

Preferred Qualifications:

• Experience with Microsoft Fabric, DevOps and Azure Event Hubs.
• Knowledge of PySpark & Fabric Notebooks is a plus.
• Familiarity with cloud services beyond Azure (e.g., AWS, Google Cloud) is a plus.
• Experience in Agile or Scrum development methodologies.

Education:

• Bachelor s degree in Computer Science, Engineering, Information Technology, or related field (or equivalent work experience).

What We Offer:

• Competitive salary and benefits.
• Collaborative and innovative team environment.
• Opportunities for career growth and advancement.
• Flexible working arrangements.

Why Maxim:

Maxim Crane is a leading company in the crane and heavy equipment industry, and working in the IT department would give you the unique opportunity to support and enhance the backbone of a thriving, fast-paced organization. By joining Maxim Crane s IT team, you'd be working with cutting-edge technology to ensure systems run smoothly and securely, supporting teams across various business functions.

The dynamic environment at Maxim Crane will give you a chance to be involved in solving complex technical challenges, optimizing the company's IT infrastructure, and contributing to overall operational efficiency. The opportunity for growth is significant, as Maxim values innovation and technology-driven solutions to improve both internal operations and client services.

In addition, being part of an IT department at Maxim means playing an integral role in ensuring the safety and reliability of the heavy equipment fleet, enhancing real-time data analytics for decision-making, and helping the business stay at the forefront of technology in an industry that relies heavily on effective communication, data, and system integration.

If you are someone who enjoys collaborating with other teams, solving problems, and making a direct impact on the success of the company, Maxim Crane s IT department offers a fulfilling and challenging career path with opportunities for continuous learning and growth.

Maxim is an equal opportunity employer and does not discriminate against employees or applicants for employment based on their race, color, religion, creed, sex, national origin or ancestry, age, sexual orientation, disability, genetic information or veteran status, as those terms are defined under applicable laws, or any other characteristic protected by law.