Snowflake Data Engineer

Primary Responsibilities

• 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.
• 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.

Qualifications

• 3-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.
• 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.
• 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.
• Experience in data aggregation of channel sales (SP/SD) data, 3PL data etc. is a plus
• Experience in working with data from Veeva CRM, Marketing CRM, Salesforce ServiceCloud and HealthCloud is a plus