Data Solutions Engineer Jobs in Philadelphia, PA

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

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 will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.