Cloud Data Architect

This is a fully remote position, open to applicants in Kansas.

📋 Description

• Enhance and provide support for EVERSANA’s Enterprise Cloud Data Warehouse utilizing Snowflake.

• Design, develop, and deliver data models, data integrations, and ETL data pipelines.

• Replicate data from both internal and external sources into the Snowflake raw layer.

• Work collaboratively with cross-functional teams to convert business requirements into data models.

• Implement various Snowflake features such as Snowpipes, Tasks, Streams, Stored Procedures, and Data Replication.

• Establish best practices for data auditing, data quality, user access, and data security.

• Implement secure data sharing and cross-platform data strategies using Apache Iceberg.

• Design and execute ETL processes with DBT while supporting data integration across engagement platforms.

• Optimize data workflows to enhance performance and scalability.

• Lead the implementation and integration of data solutions for clients.

• Provide technical guidance throughout the client onboarding process.

• Conduct data mapping exercises as needed.

• Write and refine SQL queries for data extraction, transformation, and loading.

• Utilize Python for automation and scripting tasks.

• Document requirements, solutions, and peer review feedback.

• Ensure that documentation is accessible to both technical and non-technical stakeholders.

• Exhibit a commitment to diversity, equity, and inclusion in all efforts.

• Perform additional duties as assigned.

⛳️ Requirements

• A Bachelor's or advanced degree in Computer Science, Information Technology, or a related discipline.

• A minimum of 5+ years of experience in Data Warehouse architecture design and solutions.

• At least 3+ years of experience with Snowflake cloud data warehouse.

• Experience in at least 2+ projects serving as a Lead Data Architect.

• Proficiency in using and developing with ETL tools, with a preference for DBT and Qlik Replicate and Compose.

• Familiarity with AWS and Python scripting.

• Strong analytical and problem-solving skills.

• Ability to design, implement, and communicate solutions to various stakeholders.

• Experience with Snowflake Cloud Data Warehouse capabilities, such as Snowpipes, Tasks, Streams, Stored Procedures, and Data Replication.

• Proven experience in implementing best practices for data auditing, data quality, user access, and data security.

• Knowledge of Secure Data Sharing practices.

• Experience with open table formats, particularly Apache Iceberg.

• Familiarity with virtual warehouse management best practices.

• Experience with CI/CD pipelines and code repositories like Bitbucket is preferred.

• Experience in designing data flows and ingestion patterns in multi-cloud environments is preferred.

• Proficiency in SQL.

• Desirable skills in Python scripting.

• Knowledge of Life Sciences or Healthcare business processes is advantageous.

• Familiarity with Patient Services and Specialty Pharmacy systems and processes is a plus.

• Understanding of SDLC processes and documentation.

• Familiarity with Jira and Confluence is a plus.

• Understanding of Pharma Marketing and Campaign Management data, systems, and processes is preferred.

• Monday through Friday, 40+ hours per week.

• Travel: 0%.

🏝️ Benefits

• Competitive salaries and benefits package.

• Reasonable accommodations available for employees and applicants with disabilities.

• Equal opportunity employer.

• Confidential handling of candidate information in accordance with EEO guidelines.