Data Architect

Pharma Logistics; Libertyville (IL); On-site; USD 130,000 - 180,000; Full time

Job summary

Pharma Logistics seeks a Data Architect to own the data foundation, modelling data and building ETL/ELT pipelines into Snowflake to support reporting, analytics, and data science.

You will ensure data quality, security, and performance while guiding standards, lineage, and governance across the enterprise. This role partners with analysts, data scientists, and engineers.

Qualifications

• 7+ years in data engineering, DB dev, or data architecture.
• Understanding Pharma Logistics services, processes, and systems, or ability to learn them quickly.
• Proven experience designing data models (dimensional, relational, NoSQL).
• Hands-on Snowflake experience: loading, modeling, performance tuning, cost management.
• Strong MS SQL Server development/administration experience.
• Experience with NoSQL databases such as Cosmos DB and Couchbase.
• Experience building and supporting production ETL/ELT pipelines.
• Experience integrating data from cloud SaaS via APIs/connectors.
• Ability to diagnose and resolve performance issues across databases/pipelines.
• Additional technical skills: see below.

Responsibilities

• Designing and maintaining the enterprise data architecture, including data movement between systems, Snowflake, and downstream consumers.
• Designing conceptual, logical, and physical data models including dimensional models in Snowflake for reporting and analytics.
• Building, maintaining, and monitoring ETL/ELT pipelines from MS SQL Server, Cosmos DB, Couchbase, and cloud SaaS into Snowflake.
• Identifying and resolving database and pipeline performance issues through tuning, indexing, warehouse sizing, and cost optimization.
• Establishing data quality checks, monitoring, and alerting to ensure data accuracy, completeness, and timeliness.
• Defining and enforcing data standards, naming conventions, and documentation including a data dictionary and data lineage.
• Implementing data security and access controls including RBAC and data masking for sensitive data.
• Partnering with Report Writer to deliver curated datasets for Sigma reporting and self-service dashboards.
• Partnering with Data Scientist to provide clean, well-structured data for analysis and modeling.
• Working with Business Analysts and developers to define data requirements for new projects.
• Evaluating and recommending data tools, platforms, and integration approaches.
• Resolving help desk cases related to data, integrations, and pipelines.
• Other ad hoc projects & reports.

Skills

SQL/T-SQL

Snowflake

Cosmos DB

Couchbase

MS SQL Server

Fivetran

Matillion

Azure Data Factory

Airbyte

dbt

Python

REST APIs

JSON

Git CI/CD

Education

Bachelors in CS/IS/Data Eng

Tools

Snowflake

Azure Cosmos DB

Couchbase

MS SQL Server

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.

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)

Work Environment:

This role operates in an office environment with controlled temperatures. This role routinely uses standard office equipment, such as computer, scanner, printer, telephone, photocopier, and filing cabinets. The noise level in the work environment is usually moderate.