Snowflake Data Engineer

ZS is a place where passion changes lives. As a management consulting and technology firm focused on transforming global healthcare and beyond, our most valuable asset is our people.

Here you’ll work side-by-side with a powerful collective of thinkers and experts shaping solutions from start to finish.

At ZS, we believe that making an impact demands a different approach; and that’s why here your ideas elevate actions, and here you’ll have the freedom to define your own path and pursue cutting-edge work.

We partner collaboratively with our clients to develop products that create value and deliver company results across critical areas of their business including portfolio strategy, customer insights, research and development, operational and technology transformation, marketing strategy and many more.

If you dare to think differently, join us, and find a path where your passion can change lives.

Our most valuable asset is our people .

At ZS we honor the visible and invisible elements of our identities, personal experiences and belief systems the ones that comprise us as individuals, shape who we are and

make us unique. We believe your personal interests, identities, and desire to learn are part of your success here. about our diversity, equity, and inclusion efforts and the networks ZS supports to assist our ZSers in cultivating community spaces, obtaining the resources they need to thrive, and sharing the messages they are passionate about.

Role : Snowflake Data Engineer

What You’ll Do?

Partner closely with leads (development / product owner / stakeholders / etc.) to ensure a clear understanding of business and technical needs;

assisting in selecting the best strategy and translate them into effective data solutions daily during US hours.

• Design and implement solutions in Snowflake / Matillion / DBT using industry-leading best practices for life sciences data while ensuring optimal performance, efficient operations, security, and compliance with regulatory standards.
• Work closely with the leads to develop and maintain a right size data catalog of and data lineage for commercial and medical affairs applications.
• Identify, test prototype solution and proof of concepts. Supporting testing team with identifying the optimal test strategy.
• Get reviews on designs to ensure consistency with architectural best practices; participate in regular implementation reviews to ensure consistent quality and adherence with standards.
• Work in an agile team to implement data quality checks, setup process orchestrations, mitigate vulnerabilities, devise testing strategies, and automate repeatable tasks along with participating and assisting in root cause analysis activities.
• Ensure technical standards and architectural best practices are consistently followed. Govern complete architecture and implementation of the project module.

What You’ll bring?

• 2-5 years’ of data engineering experience with proven track record in ETL, data modeling, data warehouse design, development, and ingesting data from diverse data sources (databases or APIs) using Matillion and Snowflake technologies.
• Hands-on experience developing and optimizing within the Snowflake cloud data warehouse environment. Snowpro certification is a plus.
• Advanced-level SQL / Matillion / DBT programming skills with ability to perform ELT optimization for performance. Knowledge / experience with cloud technologies (Lambda, S3, AWS policies etc.

and Python programming.

• Ability to handle end-to-end Matillion / Snowflake ETL process integrations, customization, and deployment of solutions that serve as the source of truth for reports, dashboards, and data visualizations.
• Experience in defining and implementing quality standards for ELT, SQL, Snowflake, and DBT as well as documenting and training other teammates on these standards.
• Experience working in agile teams with short release cycles and possess strong verbal, written and team presentation communication skills.
• Data-driven mindset with high analytical capability with history of leveraging data and analytical techniques to optimize business decisions.

Additional Skills :

• Understanding of the pharmaceutical domain, with experience in analyzing and working with patient data, call activity data from CRM systems, and marketing data such as web traffic, email campaign metrics, and consent management.
• Experience in data aggregation of channel sales (SP / SD) data, 3PL data etc.
• Experience in working with data from Veeva CRM, Marketing CRM, Salesforce ServiceCloud and HealthCloud.

Perks & Benefits :

ZS offers a comprehensive total rewards package including health and well-being, financial planning, annual leave, personal growth and professional development.

Our robust skills development programs, multiple career progression options and internal mobility paths and collaborative culture empowers you to thrive as an individual and global team member.

We are committed to giving our employees a flexible and connected way of working. A flexible and connected ZS allows us to combine work from home and on-site presence at clients / ZS offices for the majority of our week.

The magic of ZS culture and innovation thrives in both planned and spontaneous face-to-face connections.