Senior Snowflake Data Engineer

Description

The project is for one of the world's famous science and technology companies in pharmaceutical industry, supporting initiatives in AWS, AI and data engineering, with plans to launch over 20 additional initiatives in the future. Modernizing the data infrastructure through the transition to Snowflake as a priority, as it will enhance capabilities for implementing advanced AI solutions and unlock numerous opportunities for innovation and growth. We are seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud-based solutions across AWS, Azure, and GCP. The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC). Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Stream lit application development and SAP integration and infrastructure-as-code with Terraform is essential. Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.

What we offer

• Global Relocation - (Relocation options; Experience in an international environment; Cross-cultural experience)

• Recognition and Evaluation - (Feedback culture; Regular appraisals)

• Time Off - (Annual holiday - 20 or 26 days. The duration of the leave depends on the overall seniority; Occasional leave - 1 or 2 days/ depending on the circumstances; Child care leave - 2 days or 16 hours per year; Absence due to force majeure - 2 days or 16 hours per year; Maternity Leave - 20 weeks; Parental Leave - 41 weeks; Paternity Leave - 14 days)

• Luxoft Training Center - (Expert-led tech courses covering basic to advanced topics; Internal instructor-led soft skills courses; Comprehensive in-house self-learning resources for both soft and hard skills; Access to external self-learning libraries like ProQuest eBook and Udemy for Business; Cloud Programs: MS Cloud Academy, AWS Partner Academy, Google Cloud Academy; Custom Learning Programs: upskilling, reskilling, technical mentorship; Leadership Programs for Managers)

• Well-being and Work-life Balance - (Multisport card; Possibility to order Multisport card at the corporate rate for family members; LuxGood Program: wellbeing seminars, contests, relaxation sessions, yoga sessions, etc.; One Team Program: Buddy for each New Joiner; seminars, meeting and workplace space to support integration with local community and culture; “Hire me” workshops for partners; Preferential banking offer; Preferential car leasing offer; Cafeteria program discounts for shops, cinema tickets, holiday offers; Luxoft Social Benefit Fund: sport and recreation benefits, the possibility to receive financial support)

• Health Care - (Private Healthcare Insurance with unlimited access to specialists; Full dental support; Travel Insurance; Possibility to add private healthcare coverage for family members at the corporate rate; Life insurance at the corporate rate for employees and family members, including payment of the basic package for the employee by the employer; Reimbursement for corrective glasses)

• Company Events and Friendly Environment - (Many fun social activities organized by the Luxoft team offline in your city; Online entertainment events for whole company and local team events; A workplace where you’re treated with respect within a multicultural team)

• Internal Mobility - (Rotation between projects and accounts; New career opportunities)

• Self-Learning Library

• CSR Projects

Other

• Languages: English: B2 Upper Intermediate

• Seniority: Senior

Requirements

• 5+ years of experience

• Strong proficiency in Snowflake (Snowpipe, RBAC, performance tuning).

• Ability to write complex SQL queries, stored procedures, and user-defined functions.

• Skills in optimizing SQL queries for performance and efficiency.

• Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, openflow, fivetran

• r similar tools for real-time and periodic data processing.

• Proficiency in transforming data within Snowflake using SQL, with Python being a plus.

• Strong understanding of data security, compliance and governance.

• Experience with DBT for database object modeling and provisioning.

• Experience in version control tools, particularly Azure DevOps.

• Good documentation and coaching practice.

• experience with AWS Lambda, particularly in utilising Python to develop data extraction functionalities.

• ability to retrieve data from platforms like SharePoint or Salesforce and transfer it to an S3 bucket

Responsibilities

• In-depth knowledge of Snowflake's data warehousing capabilities.

• Understanding of Snowflake's virtual warehouse architecture and how to optimize performance

• and cost.

• Proficiency in using Snowflake's data sharing and integration features for seamless collaboration.

• Develop and optimize complex SQL scripts, stored procedures, and data transformations.

• Work closely with data analysts, architects, and business teams to understand requirements and

• deliver reliable data solutions.

• Implement and maintain data models, dimensional modeling for data warehousing, data marts,

• and star/snowflake schemas to support reporting and analytics.

• Integrate data from various sources including APIs, flat files, relational databases, and cloud

• services.

• Ensure data quality, data governance, and compliance standards are met.

• Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and

• associated tools.

• Participate in code reviews, testing, and deployment of data solutions in development and production environments.