Data Engineer

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 Senior Snowflake Developer who will be responsible for designing, developing, and maintaining scalable data solutions that effectively meet the needs of our organisation. The role will serve as a primary point of accountability for the technical implementation of the data flows, repositories and data-centric solutions in your area, translating requirements into efficient implementations. Responsibilities: • Design and work with Snowflake databases, schemas, views, and RAW, STG, and MART data layers. • Manage access using RBAC, role hierarchies, row-level security, and column-level access policies. • Work with dynamic tables, external stages, Snowpipe, and batch data loading. • Build and support reliable, production-grade Snowflake data pipelines. • Write optimised SQL queries for data extraction, transformation, and loading. • Utilise Python for advanced data processing, automation tasks, and system integration. • Be an advisor with your In-depth knowledge of Snowflake architecture, features, and best practices. • Develop and maintain complex data pipelines and ETL processes in Snowflake. • Collaborate with data architects, analysts, and stakeholders to design optimal and scalable data solutions. • Automate DBT Jobs & build CI/CD pipelines using Azure DevOps for seamless deployment of data solutions. • Ensure data quality, integrity, and compliance throughout the data lifecycle. • Troubleshoot, optimize, and enhance existing data processes and queries for performance improvements. • Document data models, processes, and workflows clearly for future reference and knowledge sharing. • Build Data tests, Unit tests and mock data frameworks • Good to have AWS and Streamlit knowledge Mandatory Skills Description: • Master’s degree in computer science, Information Technology, or a related field. • 5+ years of overall experience in data engineering, including relevant and hands-on expertise in Snowflake and DBT. • Extensive hands-on experience in writing complex SQL queries, demonstrating proficiency in data manipulation and analysis for large data volumes. • Strong understanding of data warehousing concepts, methodologies, and technologies with in-depth experience in data modelling techniques (OLTP, OLAP, Data Vault 2.0) • Experience building data pipelines using DBT (Data Build Tool) for data transformation. • Familiarity with advanced techniques for performance tuning methodologies in Snowflake including query optimization. • Strong knowledge with CI/CD pipelines, preferably in Azure DevOps. • Excellent problem-solving, analytical, and critical thinking skills. • Strong communication, collaboration, and interpersonal skills. What do we offer our employees 👩 ⚕️ LuxMed healthcare, including dental care and life insurance 🏋🏽 ♀️ MyBenefit program (sports card, wellness program, etc. 🏠 Remote (or hybrid) work 🖋 Stable employment under an employment contract 🏦 Special banking service 💻 Equipment, such as a laptop and monitor … mais Pesquise vagas mais rápido com Premium Acesse informações sobre empresas, como prioridades estratégicas, tendências de número de funcionários e muito mais Guilherme e outros milhões de usuários têm contas Premium Reative o Premium Aproveite o suporte 24 horas e cancele quando quiser. Sobre a empresa Luxoft 3.014.372 seguidores Seguindo Atividades dos serviços de tecnologia da informação • 10001+ funcionários • 13.190 no LinkedIn Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications. DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.