Piper Companies · 14 hours ago
IT Developer – Data Management
Piper Companies is seeking an IT Developer - Data Management to join a team in Wayne, PA. This role is responsible for supporting enterprise data initiatives by designing, developing, and maintaining data integration processes and data warehouse solutions.
Management Consulting
Responsibilities
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
Qualification
Required
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
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
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
Preferred
Strong experience working with SQL-based databases (Snowflake a plus)
Familiarity with .NET/C#, XML/XSLT, or cloud platforms (AWS/Azure) is a plus
Benefits
Medical
Dental
Vision
401(k)
Paid Time Off
Company
Piper Companies
At Piper, we obsess about the success of our customers and consultants.
H1B Sponsorship
Piper Companies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (1)
2023 (2)
2022 (2)
2021 (1)
Funding
Current Stage
Late StageCompany data provided by crunchbase