jobapplier

Data Architect

Pharma Logistics

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)

Easy Apply