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, 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.

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

• 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

• Relocation options
• Experience in an international environment
• Cross-cultural experience
• Feedback culture
• Regular appraisals
• Annual holiday - 20 or 26 days (depending on seniority)
• Occasional leave - 1 or 2 days (depending on 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
• Expert-led tech courses
• Internal instructor-led soft skills courses
• Comprehensive in-house self-learning resources
• 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
• 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
• 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
• Many fun social activities organized by the Luxoft team offline in your city
• Online entertainment events for the whole company and local team events
• A workplace where you’re treated with respect within a multicultural team
• Rotation between projects and accounts
• New career 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. With a strong focus on delivering cutting-edge solutions, Luxoft combines deep industry expertise with advanced technological capabilities to drive success for its clients.