Snowflake Data Engineer

Job summary

Partner with business and technical stakeholders to design, implement, and govern secure, compliant, high-performing data solutions using Snowflake, Matillion, and dbt. Maintain data catalogs and lineage, establish quality and testing practices, automate workflows, support root-cause analysis, and ensure architectural and implementation standards are followed.

Job details

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

What you’ll do

Partner with business and technical stakeholders to design, implement, and govern secure, compliant, high-performing data solutions using Snowflake, Matillion, and dbt. Maintain data catalogs and lineage, establish quality and testing practices, automate workflows, support root-cause analysis, and ensure architectural and implementation standards are followed.

Requirements

Requires 3–5 years of data engineering experience, advanced SQL, Matillion, and dbt skills, and hands-on experience building and optimizing Snowflake data warehouse solutions. Candidates should have experience with diverse data sources, pharmaceutical or commercial data, AWS and Python, agile delivery, and end-to-end ETL integrations; SnowPro certification and experience with specified CRM and channel-sales data are advantages.

Listed skills

• SQL · Preferred
• Amazon Web Services · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Snowflake
• Matillion
• Dbt
• SQL
• ETL/ELT
• Data Modeling
• Data Warehouse Design
• Python
• AWS
• Data Quality
• Data Cataloging
• Data Lineage
• Agile Methodologies
• Pharmaceutical Data
• Performance Optimization
• Data Governance

Job areas

• Data & Analytics
• Technology
• Software
• Healthcare

More jobs from Akkodis