Data Solutions Engineer

Tech Sales Jobs; Maple Shade Township (NJ); Presencial; USD 95.000 - 120.000; Jornada completa

Descripción de la vacante

RPM Performance Coatings is hiring a Data Solutions Engineer to design and optimize enterprise data pipelines and data products. You will transform and integrate data across ERP systems, Databricks, and Azure, delivering trusted datasets for analytics and operations.

You will collaborate with Data Engineering, BI, and business stakeholders to ensure data quality, governance, and scalability while staying current with cloud data engineering trends.

Formación

• Bachelor’s degree in CS/IS/Data Engineering or related field.
• 3–5+ years in data solutions, data integration, or data engineering.
• Proficiency in SQL and modern data management concepts.
• Experience integrating data from ERP systems.
• Strong analytical and problem‑solving skills.
• Knowledge of data governance, security, and quality practices.
• Experience with BI/Analytics teams to deliver trusted data.

Responsabilidades

• Design, build, and maintain enterprise data pipelines for ingestion, transformation, and delivery.
• Develop Bronze, Silver, and Gold data layers for business needs.
• Integrate data from ERP and other systems into data platforms.
• Validate data accuracy, completeness, and quality.
• Collaborate with BI and stakeholders to deliver insights.
• Stay current on new data engineering technologies.

Conocimientos

SQL

Data modeling

ETL/ELT

Analytical skills

Problem-solving

Educación

Bachelor’s degree in CS/IS/Data Eng

Herramientas

Databricks

Power BI

Microsoft Fabric

Azure

ERP platforms

Descripción del empleo

Location: Maple Shade, NJ, United States

RPM Performance Coatings is a strategic operating unit of RPM International Inc. RPM Performance Coatings joins exceptional products, technologies, service and individuals together to provide a comprehensive building solution package to markets throughout North America, as well as internationally. RPM Performance Coatings products and services are sold directly to contractors, distributors and end users, such as industrial manufacturing facilities, public institutions and other commercial customers. RPM Performance Coatings generated $1.5 billion in net sales for the fiscal year ended May 31, 2024.

The Data Solutions Engineer is responsible for developing, maintaining, and enhancing enterprise data solutions that support reporting, analytics, and business operations. This role focuses on building and supporting data pipelines, transforming and integrating data within Databricks, and creating trusted, business-ready datasets for consumption across the organization.

A key responsibility is preparing and validating data from Microsoft Dynamics 365 Finance & Supply Chain Management (D365 F&SCM), Infor LN, and other enterprise systems. The role collaborates closely with Data Engineering, Business Intelligence, and business stakeholders to deliver reliable and scalable data solutions on Microsoft Azure and related enterprise platform.

Essential Functions

• Data Pipeline Development
  • Design, build, and maintain data pipelines for ingestion, transformation, and delivery.
  • Automate workflows to ensure efficiency and reliability.
• Data Transformation & Integration
  • 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.
• Data Validation & Quality
  • 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.
• Data Modeling
  • Create and maintain logical and physical data models.
  • Ensure compliance with data quality, security, and governance standards.
• Collaboration
  • Work closely with BI teams, data analysts, and business stakeholders to deliver actionable insights.
• Continuous Improvement
  • Stay current on emerging technologies and best practices in data engineering and architecture.
• Other duties that may be assigned.

Minimum Requirements

• 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.

Applicants must be authorized to work in the United States. We are unable to sponsor or take over sponsorship of an employment visa for this position.

Preferred Requirements

• Experience with enterprise data strategy and architecture principles.
• Advanced skills in SQL, Python, and automation scripting.
• Familiarity with modern data architecture patterns, including data lakes, data warehouses, and lakehouse platforms.
• Experience with Databricks or comparable cloud-based data engineering platforms.
• Experience developing and supporting Bronze, Silver, and Gold data layers or equivalent curated data models.
• Experience with Microsoft Dynamics 365 F&SCM, Infor LN, or other ERP platforms.
• Experience supporting Power BI, Microsoft Fabric, or other enterprise analytics platforms.
• Azure Data Engineering, Databricks, or related cloud data certifications.

Benefits and Compensation

The pay range for applicants in this position generally ranges between $95,000 and $120,000 annually. The range is an estimate based on potential employee qualification operations, needs, and other considerations permitted by law.

In addition to career advancement and growth, continuous training, and mentoring opportunities, Stonhard offers an excellent comprehensive health plan and financial benefits program including but not limited to, paid holidays, paid time off, 401(k) with company match, Company Pension Plan and Stock Purchase Plans.

Qualified Applicants Statement

Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.