Data Architect
- 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 descriptionHide 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)