Data Architect / Engineering Lead

Pharma Logistics

Libertyville (IL)

On-site

USD 140,000 - 190,000

Full time

23 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Pharma Logistics seeks a Data Architect who will own the data foundation, design data models, and build ETL/ELT pipelines to Snowflake for enterprise reporting and analytics.

You will ensure data quality, security, and availability while collaborating with data scientists, analysts, and business stakeholders on data requirements and governance across the organization.

Qualifications

  • Minimum 7 years in data eng, db dev, or data architecture.
  • Experience with pharma/logistics data and regulatory requirements is preferred.
  • Ability to design dimensional, relational, and NoSQL models.
  • Hands-on Snowflake data loading, modeling, and cost management.
  • Strong MS SQL Server development and admin skills.
  • Experience with NoSQL databases (Cosmos DB, Couchbase).
  • ETL/ELT pipeline development with cloud SaaS connecters.

Responsibilities

  • Design and maintain enterprise data architecture across Snowflake and downstream consumers.
  • Create conceptual, logical, and physical data models including dimensional models.
  • Build and monitor ETL/ELT pipelines from MS SQL Server, Cosmos DB, Couchbase to Snowflake.
  • Tune queries, size warehouses, and optimize costs.
  • Establish data quality checks, governance, and documentation.
  • Define data standards, dictionaries, and lineage.

Skills

SQL (Advanced)
T-SQL
Python
Data modeling
Data governance
Analytical thinking
Problem solving

Education

Bachelor's in CS/IS/Data Eng
Snowflake SnowPro or Azure data cert

Tools

Snowflake
MS SQL Server
Azure Cosmos DB
Couchbase/CouchDB
Fivetran
Matillion
Azure Data Factory
Airbyte
dbt
Python
REST APIs/JSON
Git/CI/CD

Job description

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.

Position Title: Data Architect

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)
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Architect
Snowflake Architect

Cognizant Technology Solutions Corporation • Missouri

On-site
USD 140,000 - 200,000
Snowflake Architect
Snowflake Architect

5 Star Recruitment • Dallas (TX)

On-site
USD 130,000 - 160,000
Snowflake Data Engineer
Snowflake Data Engineer

NewVision • United States

Remote
USD 140,000 - 200,000
Snowflake Architect
Snowflake Architect

Anblicks Inc. • Dallas (TX)

On-site
USD 130,000 - 160,000
Senior Data Engineer
Senior Data Engineer

RxSense • Boston (MA)

On-site
USD 150,000 - 190,000
Data Engineer
Data Engineer

TechDigital Group • San Francisco (CA)

On-site
USD 120,000 - 160,000
Lead / Principal Snowflake Engineer
Lead / Principal Snowflake Engineer

Anblicks Inc. • Dallas (TX)

On-site
USD 135,000 - 165,000
Snowflake Architect
Snowflake Architect

Aroha Technologies, Inc • Raritan (NJ)

Hybrid
USD 96,000 - 165,000
Data Architect – Job Description
Data Architect – Job Description

Executive Staff Recruiters / ESR Healthcare • United States

Remote
USD 140,000 - 190,000
Sr. Snowflake Data Engineer
Sr. Snowflake Data Engineer

BravoTECH • Plano (TX)

On-site
USD 120,000 - 150,000