ETL Developer at Maxim Crane Works LP in Canonsburg, Pennsylvania

Job Description:

We are seeking an experienced ETL Developer with hands-on expertise in Fabric Gen2 and Pipeline 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.

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.

Duties and 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 Fabric Gen2, 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.

Requirements:

* Proven experience as an ETL Developer, Data Engineer, or similar role, with strong expertise in Fabric Gen2 and data pipeline 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 other data engineering tools such as Azure Data Factory, Databricks, or Azure Synapse Analytics.
* Knowledge of big data technologies (e.g., Hadoop, Spark, etc.) 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).

Physical Demands:

The physical demands described herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is frequently required to walk, use hands to finger; handle or feel; and kneel; crouch; or crawl; and talk; or hear; push and/or pull; reach; bend and/or stoop. The employee may occasionally lift and/or move up to 25 pounds.

Work Environment:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. While performing the duties of this job, the employee is in a typical office setting.

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.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled