LIS - Senior AWS Data Engineers CONSULTANT

Company presentation

Driven by innovation and excellence, Pictet Technologies has been shaping the future since 2016. As the technology center of the Pictet Group, we are proud to support one of Europe's leading independent wealth and asset managers by developing cutting-edge solutions for its business lines. 

Recognized as a Great Place to Work for eight years, we first established ourselves in Luxembourg before expanding to Lisbon in 2022. Today, we are entering a new phase with the kick-off of our Data Engineering team in Lisbon. Our ambition is clear: to grow a strong team of experts and build a thriving community of specialists across locations. 

We are looking for passionate individuals eager to be part of this new chapter. You will join a dynamic and collaborative environment, contribute to meaningful projects, and help shape the future of Data Engineering at Pictet Technologies, always with a long-term vision and a deep commitment to the Group's success. 

Description We are seeking a senior Data Engineer with expertise in cloud-native data pipeline development within AWS environments and Snowflake. The ideal candidate will have a strong background in data architecture, data modelling, and the ability to implement high-performance data solutions that support our business objectives. You will join the Scrum team of one of our product as part of the development team and collaborate with data analysts and internal teams to ensure the delivery and the run of the product in line with the sprint backlog.

In this context, your role will include:
Data Pipeline Development:
Implement cloud-based data pipelines to transform raw data from various sources (e.g. APIs, FTP, SFTP) into structured formats.Architect and deploy high-performance (batch and streaming) data pipelines with monitoring and alerting system implemented for data analysts and business users.Data Management:
Assemble and manage large, complex datasets that meet both functional and non-functional business requirements.Support data governance initiatives by cataloguing and describing metadata.Implement functional and non-functional tests on data.Data Modelling and Analysis:
Perform data modelling and design appropriate database objects (views, tables, procedures, scripts).Analyze and optimize queries for performance and scalability.Collaboration and Support Production:
Participate in troubleshooting, monitoring, and user support activities.Work closely with cross-functional teams to gather requirements and implement solutions.Continuous Improvement:
Code according to established architecture guidelines and focus on improving the scalability and performance of data products.Stay updated with the latest industry trends and technologies to enhance data engineering practices.Requirements Our ideal candidates should have:
Mandatory skills
University degree in Engineering or related disciplineProven experience in data pipelining and related technologies on AWS (S3, ECS, Lambda, RDS, SNS/SQS, IAM, Cloudwatch)Extensive experience with analytical database programming (SQL) and unstructured data/graph databasesGood skills in writing complex SQL queries, knowledge of DBT core is a plusProficient in Python and data-related libraries (e.g. Pandas, Boto3)Strong understanding of data platform architecture and data governance principlesReel asset
Deep knowledge of developing on Snowflake is a plusAdoption of CI/CD practicesExperience using orchestration tools (e.g. Step Function, Airflow, Prefect)Experience with version control tool such as GitHub or GitLabKnowledge of data visualization tools (e.g., Tableau) is a plusKnowledge of Infrastructure as code (e.g. CloudFormation, Terraform)AWS certification (e.g., Solution Architect or equivalent) is preferredSnowflake certification (e.g. SnowPro Core) is preferredAnd also:
An agile mind-set. It's not a buzz word: agility is about collaboration, growing together, supporting more junior team members, intellectual humility and strong desire to learnProven ability to deliver against deadlines with a strong analytical and problem-solving skillsDetail-oriented with a focus on quality and performanceAbility to work effectively in an Agile environment using tools like JiraExcellent communication skillsFluent in English, Portuguese and/or French is a plus Team player with a proactive approach to challenges and continuous improvement.In addition to solid technical knowledge and experience, we are looking for passionate individuals with a well-rounded personality and a good sense of humour: we don't compromise on these.Benefits What we offer:
An innovative and supportive working culture fostering collaboration, professional development and learning opportunitiesTop-notch technologies and premium hardwareAn opportunity to work and grow alongside inspiring individualsA room for open and meaningful discussions across the organization and locationsA safe place to share and promote your ideas and visionLifestyle in line with the tech world: flexitime, state of the art facilities, dynamic organizationNon-negotiable values: excellence, integrity, respect, funLimited travel required. Please note that a Portuguese valid work permit is required. Thank you.
Please note that only applications meeting the key requirements will be considered.

If you are passionate about software technologies, get in touch and contact us at -
Follow us on LinkedIn, Medium, Instagram, Facebook

---