Data Architect
Pharma Logistics
- Libertyville, United States
- Hybrid
- Lead/Staff
- 7+ years
- Bachelor's degree
- Posted
Skills
Required
- data engineering / database development / data architecture
- Logistics
- data models
- dimensional
- relational
- NoSQL document models
- Snowflake
- modeling
- performance tuning
- Azure
- Couchbase / CouchDB
Preferred
- SnowPro / Microsoft Azure
- data certification
- reporting
- cloud data warehouse
- data governance frameworks
- master data management
- pharmaceutical / reverse distribution / logistics industry
- MS SQL Server
Data Architect / Engineering Lead Update: 2026 Job Summary: The Data Architect owns the organization's data foundation. This role is responsible for designing data models, building and maintaining the ETL/ELT pipelines that integrate data from operational systems into Snowflake, and ensuring the performance, quality, and security of data across the enterprise.
Responsibilities
- The Data Architect delivers trusted, well-modeled data that powers reporting, self-service analytics, and data science.
- Designing and maintaining the enterprise data architecture, including how data moves between operational systems, Snowflake, and downstream consumers
- Designing conceptual, logical, and physical data models, including dimensional models in Snowflake that support reporting and analytics
- Building, maintaining, and monitoring ETL/ELT pipelines that integrate data from MS SQL Server, Azure Cosmos DB, Couchbase/CouchDB, and cloud SaaS applications into Snowflake Identifying and resolving database and pipeline performance issues, including query tuning, indexing, Snowflake warehouse sizing, and cost optimization
- Establishing data quality checks, monitoring, and alerting to ensure data is accurate, complete, and timely
- Defining and enforcing data standards, naming conventions, and documentation, including a data dictionary and data lineage
- Implementing data security and access controls, including role-based access, data masking, and protection of sensitive and regulated data
- Partnering with the Report Writer to deliver curated, certified datasets for Sigma reporting and self-service dashboards
- Partnering with the Data Scientist to provide clean, well-structured data for analysis and modeling
- Working with Business Analysts, architects, and developers to define data requirements for new projects and system changes
- Evaluating and recommending data tools, platforms, and integration approaches
- Resolving help desk cases related to data, integrations, and pipelines
- Other ad hoc projects & reports
Requirements
Ability to prioritize multiple projects within varying deadlines
- Ability to work independently as well as in a team Self-starter and able to work in a fast-paced environment
- Accuracy and attention to detail Required Education, Skills and Experience: Minimum of 7 years of experience in data engineering, database development, or data architecture
- Understanding of Pharma Logistics services, processes, and systems, or ability to quickly learn them Proven experience designing data models (dimensional, relational, and NoSQL document models) Hands-on experience with Snowflake, including data loading, modeling, performance tuning, and cost management
- Strong experience with MS SQL Server development and administration Experience working with NoSQL document databases such as Azure Cosmos DB and Couchbase/CouchDB Demonstrated experience building and supporting production ETL/ELT pipelines Experience integrating data from cloud SaaS applications through APIs and connectors
- Strong ability to diagnose and resolve performance issues across databases and pipelines
Preferred
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field Snowflake SnowPro or Microsoft Azure data certification Experience leading a migration from legacy reporting databases to a cloud data warehouse Experience with data governance frameworks and master data management
- Knowledge of pharmaceutical, reverse distribution, or logistics industry data and regulatory requirements
Additional technical skills to include
Advanced SQL / T-SQL Snowflake (Snowpipe, streams, tasks, roles, warehouses) Azure Cosmos DB and Couchbase / CouchDB MS SQL Server (SSIS, query optimization) ELT/ETL tools such as Fivetran, Matillion, Azure Data Factory, or Airbyte dbt and Python REST APIs and JSON Git / version control and CI/CD for data pipelines (Optional)
