Data Solutions Engineer: SQL, Databricks & ERP

Rust-Oleum; Maple Shade Township (NJ); On-site; USD 95,000 - 120,000; Full time

Benefits offered by this job

Health plan

Paid time off

401(k) match

Pension plan

Stock purchase plan

Job summary

RPM Performance Coatings is seeking a Data Solutions Engineer to develop, maintain, and optimize enterprise data pipelines and data products across Azure and Databricks. You will transform data from ERP systems, create trusted datasets, and support analytics for business stakeholders.

The role emphasizes collaboration with Data Engineering, BI teams, and business units, while advancing data governance, quality, and scalable architectures in a dynamic North American market.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, or a related field.
• 3-5+ years of experience developing and supporting data solutions, data integration processes, or data engineering initiatives.
• Proficiency in SQL and modern data management concepts.
• Strong knowledge of data modeling, ETL/ELT processes, and database management principles.
• Experience integrating and validating data from enterprise business applications, including ERP systems.
• Strong analytical and problem-solving skills with the ability to troubleshoot data quality and integration issues.
• Understanding of data governance, security, and data quality best practices.
• Experience working with Business Intelligence and Analytics teams to deliver trusted, business-ready data.

Responsibilities

• Design, build, and maintain data pipelines for ingestion, transformation, and delivery.
• Automate workflows to ensure efficiency and reliability.
• Develop and enhance Bronze, Silver, and Gold layer datasets to support business and analytical requirements.
• Integrate data from ERP and other enterprise systems into enterprise data platforms.
• Create and maintain data transformations, joins, calculations, and business logic to support downstream consumption.
• Support deployment of new data assets, enhancements, and data products.
• Validate, reconcile, and troubleshoot data to ensure accuracy, completeness, and consistency.
• Investigate data quality issues and collaborate with business stakeholders to identify and resolve discrepancies.
• Support data governance standards through adherence to established data quality, security, and documentation practices.
• Create and maintain logical and physical data models.
• Ensure compliance with data quality, security, and governance standards.
• Work closely with BI teams, data analysts, and business stakeholders to deliver actionable insights.
• Stay current on emerging technologies and best practices in data engineering and architecture.
• Other duties that may be assigned.

Skills

SQL

Python

Data modeling

ETL/ELT

ERP data

Azure

Databricks

Automation

Education

Bachelor's degree in CS/IS/Data Engineering/Data Analytics

Tools

Databricks

Power BI

Microsoft Fabric

Job description

RPM Performance Coatings is seeking a Data Solutions Engineer to develop, maintain, and optimize enterprise data pipelines and data products across Azure and Databricks. You will transform data from ERP systems, create trusted datasets, and support analytics for business stakeholders.

The role emphasizes collaboration with Data Engineering, BI teams, and business units, while advancing data governance, quality, and scalable architectures in a dynamic North American market.