Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field
Minimum of 7 years in data engineering, database development, or data architecture
Proven experience designing dimensional, relational, and NoSQL data models
Hands-on experience with Snowflake, including performance tuning and cost management
Strong experience with MS SQL Server development and administration
Experience with NoSQL databases like Azure Cosmos DB and Couchbase/CouchDB
Knowledge of pharmaceutical logistics data and regulatory requirements
Responsibilities
Design and maintain the enterprise data architecture for data movement
Create conceptual, logical, and physical data models for reporting and analytics
Build and monitor ETL/ELT pipelines integrating data into Snowflake
Identify and resolve database and pipeline performance issues
Establish data quality checks and monitoring for accuracy and completeness
Define and enforce data standards and documentation
Implement data security and access controls for sensitive data
Collaborate with Report Writers and Data Scientists for curated datasets
Work with Business Analysts and developers to define data requirements
Evaluate and recommend data tools and integration approaches
Benefits
Flexible work environment
Opportunities for professional development
Collaborative team culture
Access to cutting-edge data technologies
Health and wellness programs
Full 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