Insider. is hiring a

DWH Data Engineer

İstanbul, Turkey
Our DWH Data & Analytics Team is the place where Business & Development meets to create something meaningful and beautiful. They are self-learners in a fast-paced environment always on the lookout for the newest technology. They are not just smart developers, they are also a team that helps businesses develop, help decisions to be made, sales to be done, deals to be closed & tasks to be executed all throughout the business. They are people who are armed with responsibilities and technical skills, they get to learn and experience all that Insider does as they are the data mind behind. They work with the data of Insider which works with 1100+ brands in 25+ regions. We were a company made of 6 tiny desks when we started, so we never forget how important our hard work and dedication are. Until now it has been an inspiring story on our side, so we wanted to let you in on it. The rest? The rest is just this paragraph minimized into some bullet points on what we offer & what we expect. But that’s the thing that makes the difference between storytellers & story makers; the things that grab your soul.

Insider is seeking a DWH Data Engineer who is self-motivated, directed, and solution-oriented. The DWH Data Engineer role is responsible for designing, implementing, and managing data warehousing solutions that support business intelligence and data analysis needs. They utilize technical skills in SQL, MySQL, ETL processes, Python programming, and AWS cloud services to ensure efficient data storage, processing, and retrieval. The role involves collaborating with cross-functional teams to translate business requirements into scalable data warehousing strategies, while also maintaining data integrity, performance, and security.

Must be experienced with ETL, MySQL, SQL, Python, API, AWS, and preferably other code languages.

Day in and day out a DWH Data Engineer in Insider;

  • Develop and implement robust data warehousing systems to support business analytics, intelligence, and data management needs. This includes designing data schemas, identifying key data sources, and ensuring seamless data integration.
  • Create, manage, and optimize ETL processes to load data from various sources into the data warehouse. This involves writing complex SQL queries, designing data pipelines, and ensuring data quality and consistency.
  • Administer SQL and MySQL databases to ensure high performance, availability, and security. This includes tuning database performance, executing backups, and implementing disaster recovery plans.
  • Utilize SQL and Python to analyze data within the data warehouse. Develop and maintain reports, dashboards, and data visualizations to support business decisions.
  • Design, develop, and maintain RESTful APIs to enable seamless data integration and interaction between different software applications, services, and databases. This involves understanding business requirements, defining endpoint specifications, and ensuring APIs meet functional and performance expectations.
  • Work closely with business analysts, data scientists, and other stakeholders to understand their data requirements and translate them into technical specifications. Provide expert advice on data warehousing best practices.
  • Preferably knowledge about AWS cloud services such as Amazon Redshift, AWS Glue, and others to enhance data warehousing capabilities. This includes managing cloud-based data storage, and computing resources, and implementing scalable data warehousing solutions.
  • Ensure data warehouse solutions comply with data privacy laws and company policies. Implement security measures to protect data integrity and confidentiality.
  • Stay abreast of the latest trends and technologies in data warehousing. Continuously seek to improve data warehousing processes and systems through innovation and automation.

We want you to join us while we are taking a step into the future if you;

  • 2+ years of experience in data engineering, with proficiency in SQL, Python, and ETL processes.
  • Strong expertise in designing, building, and optimizing data pipelines, warehouses, and data lakes. 
  • Bachelor's degree in Computer Science, MIS, Computer Information Systems or 2+ years of experience
  • Expert knowledge in SQL and MySQL, including complex query writing, database design, and performance tuning.
  • Extensive experience with ETL tools and processes, with a strong understanding of data extraction, transformation, and loading techniques.
  • Proficiency in Python, especially in the context of data manipulation, analysis, and ETL process automation.
  • Preferably familiarity with AWS services relevant to data warehousing, such as Amazon Redshift for data storage, AWS Glue for ETL, and AWS Lambda for serverless computing.
  • Deep understanding of data warehousing principles, including dimensional modeling, and data mart construction.
  • Skills in developing reports and dashboards using business intelligence tools. Knowledge of data visualization best practices.
  • Have an advanced command of reading, writing, listening, and speaking skills in English.
  • Ability to manage projects, coordinate with teams, and communicate effectively with stakeholders.
  • Ability to work in a fast-paced team environment
  • Attention to detail with emphasis on accuracy, timeliness, and quality
  • Ability to prioritize work to balance multiple issues, projects, and/or deadlines
  • Ability to conduct research, use and train others on tools, software, and technical procedures on a wide range of computing issues, as required
  • Excellent written and verbal communication skills with a focus on providing clear, concise, and professional documentation for areas of assigned responsibility required
  • Willingness to strive to consistently improve, both personally, and as a team, to achieve extraordinary results in customer service and technical skills

While we are conquering the world, we are offering you:

  • A chance to work in an international, diverse, and inclusive environment
  • To be a part of an industry that’s shaping the future of customer experiences
  • Opportunity to be a part of different side projects depending on your interests
  • Access to many hard and soft skill training to help you improve and challenge yourself
  • Access to 16,000+ online courses taught by real-world professionals on the LinkedIn Learning platform to satisfy your hunger for knowledge.
  • Space to share your skills through training sessions and workshops if you wish. Sharing is caring!
  • Free access to exclusive platforms such as Blinkist, Masterclass, and Spotify
  • Chance to become a Shareowner with the "Shareowner System"
  • Inclusive Private Health Insurance
  • Smart Work Model side benefits to support food and bill expenses
  • The infamous team activities are bursting with fun. Check out: https://www.instagram.com/lifeatinsider/ 
  • No Dress Code!

Apply for this job

Please mention you found this job on AI Jobs. It helps us get more startups to hire on our site. Thanks and good luck!

Get hired quicker

Be the first to apply. Receive an email whenever similar jobs are posted.

Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Data Engineer Q&A's
Report this job
Apply for this job