Senior Snowflake Data Engineer

About the Position

We are seeking a highly skilled Senior Snowflake Data Engineer to join our team in Ukraine, working remotely. This role is pivotal in supporting initiatives in AWS, AI, and data engineering for one of the world's leading science and technology companies in the pharmaceutical industry. The role involves modernizing data infrastructure through the transition to Snowflake, enhancing capabilities for implementing advanced AI solutions, and unlocking numerous opportunities for innovation and growth.

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.

Requirements

Must Have

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

Nice to Have

• Experience with AWS Lambda, particularly in utilizing Python to develop data extraction functionalities.
• Ability to retrieve data from platforms like SharePoint or Salesforce and transfer it to an S3 bucket.

We Offer

• Opportunity to work with a leading science and technology company in the pharmaceutical industry.
• Remote work options.
• Professional growth and development opportunities.

About the Company

Luxoft is a global provider of digital transformation and technology services, empowering businesses to innovate and thrive in the digital age. We are committed to delivering excellence and creating value for our clients and partners.