Senior Data Architect

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 & ModernizationArchitect scalable, secure, and high availability data platforms across cloud/hybrid environmentsDesigning 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 systemsEstablishing standards for availability, resilience, performance optimization, and cost efficiencyProducing architectural diagrams and documentation to guide implementation and long-term platform strategyData Ingestion & IntegrationDesigning and implementing scalable ingestion pipelines across enterprise systemsDeveloping ingestion and transformation logic using SQL and PythonSupporting integration patterns across APIs, batch systems, and event-driven architecturesDesigning monitoring and alerting mechanisms to ensure ingestion reliability and observabilityEnabling data availability for analytics and operational reporting without compromising system performanceCloud & Infrastructure EngineeringArchitecting and managing cloud-based data servicesDesigning monitoring frameworks using tools such as CloudWatch, New Relic, or equivalentOptimizing cloud infrastructure costs while maintaining performance and reliabilitySupporting secure access patterns, identity management, and operational governanceDevOps & Platform ReliabilityImplementing CI/CD pipelines for data and database deployments (Azure DevOps or similar)Establishing version control and automated deployment standards for data environmentsImproving SDLC processes for database and data platform releasesEnsuring high system availability (99.9%+ targets) and proactive incident managementSupporting incident response processes and RCA for data related systems and/or outagesDatabase Architecture & Performance OptimizationDesigning relational database schemas for scalability and performanceClearly define and implement indexing, partitioning, and query optimization standardsImplementing backup, disaster recovery, business continuity and high availability strategiesGuiding database tuning and performance monitoring practicesGovernance & Technical LeadershipEstablishing data architecture standards and naming conventionsDriving platform documentation and operational best practicesPartnering with application, infrastructure, and analytics teamsServing as technical authority across data centric initiativesMentoring engineers through design reviews and architecture governanceTo be qualified for this position, you must possess the following: 8+ years of experience in data architecture, cloud engineering, or platform focused rolesStrong 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 skillsProven experience modernizing enterprise database environmentsExperience implementing CI/CD pipelines for data platforms, preferably Azure DevOpsStrong understanding of database performance tuning and availability designExperience designing systems for high availability and operational reliabilityThe following skills are preferred, but not required: Experience with CDC, streaming, or event-driven ingestion architectures is a plusFamiliarity with enterprise CRM (Salesforce, home grown) or billing platforms (Great Plains, Dynamics) and data integration across these as data sources into a cloud DWHExperience with Elasticsearch or similar search/indexing platformsKnowledge of cost optimization in data cloud environments – across storage, usage and data accessibilityExperience working in highly regulated or operationally critical industries, influencing data governance principles and industry best practicesFor 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.