Senior Snowflake Data Engineer

About the Position

We are seeking a highly skilled Senior 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, Streamlit application development, 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.

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

• Remote work from Ukraine
• Competitive salary
• Opportunity to work with one of the world's famous science and technology companies in the pharmaceutical industry
• Modernizing the data infrastructure through the transition to Snowflake

About the Company

Luxoft is a global provider of digital transformation and technology services, empowering businesses to innovate and thrive in the digital age. With a strong focus on delivering cutting-edge solutions, Luxoft partners with leading organizations to drive growth and success.