Job Description
To ensure business and technical needs are met, assist in selecting the best strategy and translate it 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 leads to develop and maintain a right-size data catalog of and data lineage for commercial and medical affairs applications.
Responsibilities
• 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.
Requirements
• 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.
• * 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.
