Data Engineer (Snowflake-dbt)

We are looking for Data Engineer join our fast-paced and self-accountable team that delivers enterprise-level products for local and global markets. You will work with IT consultants, delivery managers, DevOps engineers, QA teams, BE, FE, and mobile developers to deliver best-in-class digital products.

where you can code, grow, and inspire others.

What will you do?

• In this role, you will be at the forefront of our data migration initiatives, playing a critical part in transforming and modernizing data infrastructure. Your primary responsibility will be migrating on-premises solutions to cloud-based solutions. This role demands a blend of technical expertise, effective communication, and meticulous data validation to ensure seamless and successful migrations.
• As a Data Engineer, you will collaborate closely with business owners, understanding their requirements and keeping them informed about the migration progress. You will also be responsible for validating the migrated data, ensuring that it meets our high standards of accuracy and completeness. This involves performing data quality checks and resolving any issues that emerge during the migration process. Your analytical skills and attention to detail will be essential in maintaining the integrity of our data.
• This role offers an exciting opportunity to work on cutting-edge data migration projects within a dynamic and collaborative environment.

What are we looking for?

• 3 years relevant experience working with data warehousing and/or working with large data sets
• Should have a minimum 3+ years of relevant experience as a developer in implementation DWH & Data Integration projects on AWS and Snowflake.
• Must have excellent hands-on experience with DBT/Talend
• Must have excellent hands-on experience with Snowflake utilities, SnowSQL, SnowPipe and basic scripting using Python.
• Should have excellent hands-on experience with Oracle PL/SQL,
• Should be able to understand the Db concepts and difference between MPP and SMP system.
• Should be able to create tables, roles, Virtual Warehouse, Data sharing, clones etc.
• Should be able to write complex sql and stored procedure, design and implement snowflake roles and optimize SQL statement.
• Understanding and experience in ETL Tools will be a big plus
• Experience with relational databases and any flavour of SQL/PySpark in an analytical context
• Experience with data exploration/visualisation and data story telling
• Experience using Python for web apps (Flask, Streamlit, Dash)
• Experience with BI development (PowerBI, SAP BO, Tableau, etc.)
• Able to think analytically, use a systematic and logical approach to analyze data, problems, and situations.
• Should be able to drive the day-to-day tasks in alignment with the project plan and collaborate with client to accomplish milestones as per plan.
• Proficient in spoken and written English

Must have technologies:

• DBT/Talend
• Snowflake
• SQL/HQL
• Python
• GIT

Nice to have technologies:

• AWS Glue, Terraform
• PySpark/Hadoop
• Oracle PL/SQL
• Matillion
• Jenkins
• Scrum/Agile

Our commitment to you

• A well-established, next-generation organization
• Working hubs spread out in different locations in Turkey
• An agile & lean organization and optimized work processes
• Living locally (100% digital) and working globally in international projects
• Competitive salary, private health insurance, and comprehensive benefits
• A bonus system based on company performance and individual contributions
• Graduate school tuition support at the master's or doctorate level (please ask for details)
• Supported personal development and a diverse culture where you can thrive, learn, and contribute to your fullest potential
• Life-long learning with unlimited Udemy access
• Social clubs, team activities, and regular company-wide events
• Volunteering opportunities (when you join the adesso "Good 4 Future" community)

adesso Turkey empowers enterprises through custom software development and IT consultancy. We deliver the finest-caliber digital solutions - transforming businesses, people, and technology.

Our group headquarters is based in Dortmund, Germany, and we have over 11.100 colleagues working at 65 different sites around the globe. Check out www.adesso.com.tr to find out more.