IT Developer – Data Management
Wayne, Pennsylvania
Job Id:
159735
Job Category:
Job Location:
Wayne, Pennsylvania
Security Clearance:
No Clearance
Business Unit:
Piper Companies
Division:
Piper Enterprise Solutions
Position Owner:
Kara Grebe
Piper Companies is seeking a IT Developer- Data Management to join a team in Wayne, PA. This role is 4 days ONSITE. The IT Developer is esponsible for supporting enterprise data initiatives by designing, developing, and maintaining data integration processes and data warehouse solutions. This role requires strong Python and SQL skills, experience with low-code ETL tools, and the ability to work across technical and business teams to enable accurate, timely, and efficient data delivery.
Responsibilities of the IT Developer – Data Management:
- Perform data profiling, source-to-target mapping, and development of ETL/ELT processes using low-code tools and/or Python.
- Develop, optimize, and troubleshoot complex SQL queries, stored procedures, and data transformations.
- Support data ingestion, integration, and movement across multiple systems and platforms.
- Contribute to data warehouse design decisions and recommend optimal data structures for analytics and reporting.
- Collaborate with Business Analysts, Project Managers, Data Warehouse Architects, and BI Developers to deliver scalable data solutions.
- Create and maintain technical documentation, including specifications, mappings, and ETL workflow details.
- Debug and resolve data issues with appropriate urgency; perform root cause analysis on complex code.
- Apply best practices in data modeling (ER diagrams, normalization, dimensional modeling, etc.).
- Work within fast-paced environments and adapt quickly to changing business needs.
Qualifications for the IT Developer – Data Management:
- 3+ years of experience developing data-centric solutions with a focus on data movement and integration.
- Advanced Python skills (required).
- Expert-level SQL experience, including performance tuning and optimization.
- Strong experience working with SQL-based databases (Snowflake a plus).
- Experience with low-code ETL tools (Talend or similar platforms).
- Understanding of data modeling concepts and data warehousing techniques (dimensional modeling, star schema).
- Experience working with integration patterns such as flat files, APIs, and web services.
- Ability to write clear, detailed technical documentation.
- Familiarity with .NET/C#, XML/XSLT, or cloud platforms (AWS/Azure) is a plus.
- Strong analytical and problem-solving skills with the ability to diagnose complex code and data issues.
- Bachelor’s degree in Computer Science, Information Technology, or related field.
Compensation for IT Developer – Data Management:
- $85,000 – $110,000 annual base salary
- Work environment: 4 dyas ONSITE
- Comprehensive Benefits: Medical, Dental, Vision, 401(k), Paid Time Off
This job opens for applications on 2/12/2026. Applications for this job will be accepted for at least 30 days from the posting date
Keywords:
Developer, Data Developer, ETL Developer, Data Engineer, Python Developer, SQL Developer, Data Integration, ETL, ELT, Talend, Informatica, Matillion, Alteryx, dbt, SSIS, Data Pipelines, Data Warehousing, Star Schema, Dimensional Modeling, ER Modeling, Data Architecture, Data Mapping, Source-to-Target Mapping, SQL Tuning, SQL Optimization, Stored Procedures, Views, Functions, Data Lake, Data Warehouse, Snowflake, Redshift, BigQuery, Azure Data Factory, AWS Glue, Azure, AWS, GCP, Cloud Data Engineering, API Integration, Flat File Integration, Web Services, XML, XSLT, JSON, REST APIs, Batch Processing, Data Ingestion, Data Transformation, Business Intelligence, BI Developer, Data Quality, Data Governance, Data Modeling, Linux, Microsoft SQL Server, Oracle, Postgres, Debugging, Root Cause Analysis, Technical Documentation, ETL Documentation, Pipeline Monitoring, Version Control, Git, Agile, SDLC, Onsite, Hybrid, Wayne PA, Pennsylvania Jobs, Data Analytics, Enterprise Data, Data Solutions, Analytics Engineering, Pipelines, Data Validation, Data Profiling, Data Automation, Fast-Paced Environment.