Cloud Data Architect
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 maintains thorough documentation. The architect collaborates with cross-functional teams to translate business requirements into data solutions, leads client implementations and integrations, and provides technical guidance during client onboarding. The position works with Snowflake capabilities and AWS services to implement secure, high-quality, scalable data solutions. It includes developing ETL processes, optimizing data workflows, conducting data mapping, and documenting requirements and solutions for technical and non-technical audiences. The role also calls for a commitment to diversity, equity, and inclusion, and may include other duties as assigned. The stated schedule is Monday through Friday, 40+ hours per week, with 0% travel. The listed work environment is an office, where employees may sit or stand for long periods, walk, talk, hear, and occasionally lift or move up to 25 pounds.
Requirements
- Bachelor’s or advanced degree in Computer Science, Information Technology, or a related field.
- At least 5 years of experience in data warehouse architecture design and solutioning.
- At least 3 years of experience working with Snowflake cloud data warehouse.
- At least 2 projects in a Lead Data Architect role.
- Experience using and developing with ETL tools; DBT is required.
- Experience with AWS services, including S3, Event Bridge, and CloudWatch.
- Experience with Python scripting.
- Strong problem-solving and analytical abilities.
- Ability to design, execute, and communicate solutions to different stakeholders.
- Proficiency in SQL.
- Familiarity with SDLC processes and documentation.
- Ability to meet the physical and mental demands of the office environment, including frequently reaching, grasping, standing and/or sitting for long periods, walking, talking, and hearing, and occasionally lifting or moving up to 25 pounds.
Nice To Haves
- Experience with 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.
- 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.
- Familiarity with 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 for the Enterprise Cloud Data Warehouse, including replication of data from internal and external sources into Snowflake’s raw layer.
- Collaborate with cross-functional teams to understand business requirements and translate them into effective data models.
- Use Snowflake capabilities such as Snowpipes, Tasks, Streams, Stored Procedures, and Data Replication.
- Implement data auditing, data quality, user access, and data security best practices, as well as secure data sharing and virtual warehouse management practices.
- Design and implement ETL processes, including developing with DBT, and support integration from different engagement platforms.
- Optimize data workflows for performance and scalability.
- Lead implementation and integration of data solutions for clients and provide technical guidance during client onboarding.
- Conduct data mapping exercises to align business requirements with data architecture.
- Write and optimize SQL queries for data extraction, transformation, and loading; use Python for automation and scripting where 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 continuous development, inclusive behaviors, and proactive bias management.
- Perform other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
