Senior Data Architect

A. Duie Pyle • West Chester, PA

1d

About The Position

A family-owned business since 1924, A. Duie Pyle provides a range of integrated transportation and distribution solutions throughout the Northeast and Mid-Atlantic. Supported by our vast network of Less-Than-Truckload (LTL) service centers, warehouse facilities, and dedicated locations, we have the ability to offer flexible and seamless integrated solutions tailored to our customer’s needs. Simply put, when it comes to integrated supply chain solutions, Pyle People Deliver. Our promise is to provide outstanding service as it remains to be our first and foremost mission. Position Summary: We are seeking a Senior Data Architect to lead the design, modernization, and operational excellence of our enterprise data platform. This role blends hands on data architecture with cloud and on prem platform engineering, reliability, and DevOps practices. The ideal candidate brings deep experience designing scalable data solutions, modernizing database environments, implementing automation and CI/CD pipelines, and driving platform reliability across mission critical systems.This role requires both strategic architectural thinking and hands on implementation across cloud services, relational databases, automation tooling, and enterprise system integrations. The responsibilities of the position include, but are not limited to:

Requirements

• 8+ years of experience in data architecture, cloud engineering, or platform focused roles
• Strong experience with designing, implementing, and maintenance of data solutions across on-premises and cloud platforms (Snowflake/Databricks/MS Fabric, and SQL Server)
• Advanced SQL proficiency and strong Python coding skills
• Proven experience modernizing enterprise database environments
• Experience implementing CI/CD pipelines for data platforms, preferably Azure DevOps
• Strong understanding of database performance tuning and availability design
• Experience designing systems for high availability and operational reliability

Nice To Haves

• Experience with CDC, streaming, or event-driven ingestion architectures is a plus
• Familiarity with enterprise CRM (Salesforce, home grown) or billing platforms (Great Plains, Dynamics) and data integration across these as data sources into a cloud DWH
• Experience with Elasticsearch or similar search/indexing platforms
• Knowledge of cost optimization in data cloud environments – across storage, usage and data accessibility
• Experience working in highly regulated or operationally critical industries, influencing data governance principles and industry best practices

Responsibilities

• Data Platform Architecture & Modernization Architect scalable, secure, and high availability data platforms across cloud/hybrid environments
• Designing and overseeing database modernization initiatives (e.g., On-prem SQL server to managed services such as RDS or equivalent)
• Defining data storage strategies across relational and operational systems
• Establishing standards for availability, resilience, performance optimization, and cost efficiency
• Producing architectural diagrams and documentation to guide implementation and long-term platform strategy
• Data Ingestion & Integration Designing and implementing scalable ingestion pipelines across enterprise systems
• Developing ingestion and transformation logic using SQL and Python
• Supporting integration patterns across APIs, batch systems, and event-driven architectures
• Designing monitoring and alerting mechanisms to ensure ingestion reliability and observability
• Enabling data availability for analytics and operational reporting without compromising system performance
• Cloud & Infrastructure Engineering Architecting and managing cloud-based data services
• Designing monitoring frameworks using tools such as CloudWatch, New Relic, or equivalent
• Optimizing cloud infrastructure costs while maintaining performance and reliability
• Supporting secure access patterns, identity management, and operational governance
• DevOps & Platform Reliability Implementing CI/CD pipelines for data and database deployments (Azure DevOps or similar)
• Establishing version control and automated deployment standards for data environments
• Improving SDLC processes for database and data platform releases
• Ensuring high system availability (99.9%+ targets) and proactive incident management
• Supporting incident response processes and RCA for data related systems and/or outages
• Database Architecture & Performance Optimization Designing relational database schemas for scalability and performance
• Clearly define and implement indexing, partitioning, and query optimization standards
• Implementing backup, disaster recovery, business continuity and high availability strategies
• Guiding database tuning and performance monitoring practices
• Governance & Technical Leadership Establishing data architecture standards and naming conventions
• Driving platform documentation and operational best practices
• Partnering with application, infrastructure, and analytics teams
• Serving as technical authority across data centric initiatives
• Mentoring engineers through design reviews and architecture governance

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed