Eversana - Cloud Data Architect - Snowflake DB

2 months ago


Pune, India Eversana Full time

As a Cloud Data Architect, you will play a key role in enhancing and supporting the Enterprise Cloud Data Warehouse on Snowflake.

You will be responsible for designing data models, developing data integrations, and managing ETL data pipelines.

This position requires a deep understanding of data architecture, Snowflake Cloud Data Warehouse, and proficiency in ETL processes.

You will collaborate with cross-functional teams, support client deliverables, and ensure comprehensive documentation of solutions.

Roles and Responsibilities :

Data Architecture & Integration :

- Design and implement end-to-end data integration solutions using Enterprise Cloud Data Warehouse.

- Manage data replication from a variety of internal and external data sources into the Snowflake Data Warehouse Raw layer.

- Collaborate with cross-functional teams to understand business requirements and translate them into effective data models.

Snowflake Expertise :

- Utilize Snowflake platform capabilities, including Snowpipes, Tasks, Streams, Stored Procedures, and Data Replication.

- Implement best practices for data auditing, data quality, and secure data sharing.

- Ensure the adoption of industry best practices for user access, data security, and virtual warehouse management.

ETL Development :

- Design and implement efficient ETL processes using DBT.

- Experience with Qlik Replicate and Qlik Compose ETL tools is preferred.

- Use CI/CD pipelines and code repositories such as Bitbucket to optimize data workflows for performance and scalability.

Client Project Support :

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

- Provide technical guidance during client onboarding and data integration processes.

- Conduct data mapping exercises to align client business requirements with data architecture.

Technical Proficiency :

- Write and optimize SQL queries for data extraction, transformation, and loading (ETL).

- Proficiency in Python scripting is desirable for automation and optimization.

Process & Documentation :

- Demonstrate strong documentation abilities, including peer reviews and SDLC process adherence.

- Use work management and documentation platforms such as Jira and Confluence to ensure accessible and understandable documentation for both technical and non-technical stakeholders.

Additional Responsibilities :

- Stay current with technological advancements and best practices in data architecture.

- Optimize data workflows for scalability and performance.

- Contribute to continuous improvement of processes and documentation.

Qualifications & Skills :

Experience :

- Minimum of 7+ years in Data Warehouse architecture design and solutions.

- 3+ years of hands-on experience with Snowflake Cloud Data Warehouse.

- 2+ projects operating in a Lead Data Architect role.

- Experience with ETL tools, preferably DBT, Qlik Replicate, and Qlik Compose.

Technical Skills :

- In-depth knowledge of Snowflake platform capabilities such as Snowpipes, Streams, Tasks, and Stored Procedures.

- Proficient in SQL and Python scripting for data transformation and automation.

- Experience with AWS services such as S3, Event Bridge, and Cloudwatch.

- Familiarity with data security, user access control, and virtual warehouse management best practices.

Soft Skills :

- Strong problem-solving and analytical abilities.

- Excellent communication skills for cross-functional team collaboration.

- Ability to document solutions clearly and conduct peer reviews.

Preferred Knowledge :

- Familiarity with Life Sciences or Healthcare business processes.

- Experience with Patient Services and Specialty Pharmacy systems is a plus.

Education :

- Bachelor's or advanced degree in Computer Science, Information Technology, or a related field.

Additional Information :

- This position may require occasional travel for client meetings and project discussions.

- Competitive salary package based on experience and qualifications

(ref:hirist.tech)

  • Pune, Maharashtra, India EVERSANA Full time

    About the Role:Eversana is seeking a highly experienced Data Architecture Visionary to lead the development and delivery of our cloud data strategy. As a pivotal member of our team, you will play a key role in shaping the future of our data architecture, designing and implementing large-scale data solutions in public cloud...


  • Pune, Maharashtra, India Eversana Full time

    About the RoleWe are seeking a seasoned Cloud Data Solutions Architect to join our team at Eversana. In this key role, you will play a pivotal part in enhancing and supporting our Enterprise Cloud Data Warehouse on Snowflake.This position requires a deep understanding of data architecture, Snowflake Cloud Data Warehouse, and proficiency in ETL processes. You...


  • Pune, India Eversana Full time

    Position Overview : The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud based data solutions. The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, Maharashtra, India EVERSANA Full time

    About the Role:Eversana is seeking an experienced Senior Cloud Data Architect to play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions.Key Responsibilities:Design a scalable cloud data architecture to support...


  • pune, India EVERSANA Full time

    Position Overview: The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions. The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    At EVERSANA, we are proud to be certified as a Great Place to Work across the globe. We’re fueled by our vision to create a healthier world. How? Our global team of more than 7,000 employees is committed to creating and delivering next-generation commercialization services to the life sciences industry. We are grounded in our cultural beliefs and serve...


  • pune, India EVERSANA Full time

    Position Overview: The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview: The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering...


  • pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience inarchitecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience inarchitecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • pune, India EVERSANA Full time

    Position Overview: We are seeking a dedicated Data Platform Support Specialist with expertise in Qlik Replicate, Power BI, Tableau, DBT, Snowflake and AWS admin to join our team and ensure the smooth operation and maintenance of our data platforms. Job Description: Responsibilities: Platform Maintenance and Monitoring: Oversee the daily operations of data...


  • pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions. The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview: The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview: The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions . The ideal candidate will possess a deep understanding of cloud data platforms, data engineering...


  • Pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions. The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions. The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...


  • Pune, India EVERSANA Full time

    Position Overview:The Senior Cloud Data Architecture will play a pivotal role in shaping and executing our cloud data strategy. This position requires a visionary leader with extensive experience in architecting and implementing cloud-based data solutions. The ideal candidate will possess a deep understanding of cloud data platforms, data engineering best...