Data Solutions Engineer
- Compensation
- Not disclosed
- Location
- Maple Shade, NJ, United States
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Solutions engineering
- Posted
Skills
Nice to have
- 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.
Full description
Company Overview
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.