Home › Jobs › Pharma Logistics

Data Architect / Engineering Lead

Pharma Logistics · Libertyville, Illinois · Posted November 19, 2026 (today)

Apply on Pharma Logistics’s siteFill the application with AutoFillSee your fit for this role

Job description

Position Title: 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. The Data Architect delivers trusted, well-modeled data that powers reporting, self-service analytics, and data science.

Job Duties and Responsibilities (Essential Functions)

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

Beneficial Education, Skills and Experience

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

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

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)

Posting 53 on bamboohr. Source: the employer’s listing. Valid through January 3, 2027 unless closed earlier.