Senior Data Architect

Senior Data Architect at A. Duie Pyle, Inc. Senior Data Architect at A. Duie Pyle, Inc. in West Chester, Pennsylvania Posted in 8 days ago.

Type:

full-time

Job Description:

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: 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 To be qualified for this position, you must possess the following: 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 The following skills are preferred, but not required: 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 For a full job description associated with this posting, please contact A. Duie Pyle's Human Resources department. This job posting is intended solely for external advertising purposes and does not represent a comprehensive list of all job-related duties and qualifications. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.