Pharma Logistics logo
Salary
$159K–$176K
Hiring from
United States
Work type
Hybrid
Posted

626,291 remote jobs, straight from company career pages

100% free · New jobs every minute

Show 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)
Apply for this job100% free