Cloud Data Architect

EVERSANA•Overland Park, KS

7h•$125,000 - $155,000

About The Position

The Cloud Data Architect will enhance and support EVERSANA’s Enterprise Cloud Data Warehouse on Snowflake. The role designs and delivers data models, integrations, and ETL pipelines; supports client project deliverables; and documents solutions. The architect works with cross-functional teams to translate business requirements into data architecture and leads implementation and integration of client data solutions. The position covers data replication into Snowflake, Snowflake platform capabilities and security, ETL development, data quality, workflow optimization, and ingestion across platforms. It also provides technical guidance during client onboarding, conducts data mapping, and communicates and documents solutions for technical and non-technical stakeholders. The role is based in select U.S. locations, with 0% travel and Monday-through-Friday hours of 40 or more per week.

Requirements

Bachelor’s or advanced degree in Computer Science, Information Technology, or a related field.
At least 5 years of data warehouse architecture design and solutioning experience.
At least 3 years of experience working with Snowflake cloud data warehouse.
Experience in at least 2 projects in a Lead Data Architect role.
Experience using and developing with ETL tools; DBT is required, and Qlik Replicate and Qlik Compose experience is preferred.
Experience with AWS services and Python scripting.
Strong problem-solving and analytical abilities.
Ability to design, execute, and communicate solutions to different stakeholders.
Proficiency in SQL.
Experience with Snowflake capabilities, data security, auditing, and data quality practices.
Familiarity with SDLC processes and documentation.

Nice To Haves

Experience using Qlik Replicate and Qlik Compose ETL.
Experience with CI/CD pipelines and code repositories such as Bitbucket.
Experience designing data flows and ingestion patterns across multi-cloud environments.
Python scripting skills for automation and scripting.
Knowledge of Life Sciences or Healthcare business processes.
Familiarity with Patient Services and Specialty Pharmacy systems and business processes.
Familiarity with Pharma Marketing and Campaign Management data, systems, and business processes.
Experience using work management and documentation platforms such as Jira and Confluence.
Experience with Snowflake platform architecture.
Experience with data quality monitoring frameworks, data catalogs, and data dictionaries.
Experience with Google BigQuery and Google Cloud Platform.
Experience with multi-cloud data architecture and cross-platform data integration.

Responsibilities

Design and implement end-to-end data integration solutions, including replication from internal and external sources into the Snowflake raw layer.
Collaborate with cross-functional teams to translate business requirements into effective data models.
Use Snowflake capabilities including Snowpipes, Tasks, Streams, Stored Procedures, and Data Replication.
Implement data auditing, data quality, user-access, data-security, secure-sharing, and virtual warehouse management best practices.
Work with open table formats, particularly Apache Iceberg, for cross-platform data strategies.
Design and implement ETL processes and data integration from different engagement platforms.
Optimize data workflows for performance and scalability.
Lead implementation and integration of client data solutions, provide technical guidance during onboarding, and conduct data mapping exercises.
Write and optimize SQL queries for data extraction, transformation, and loading; use Python for automation and scripting as applicable.
Document requirements and solutions, conduct peer reviews, and ensure documentation is accessible to technical and non-technical stakeholders.
Demonstrate commitment to diversity, equity, and inclusion through ongoing development, inclusive behavior, and proactive bias management.
Perform other duties as assigned.