DWH Data Engineer

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;

• New graduate or 1+ year of experience in data engineering, with proficiency in SQL, Python, and ETL processes.
• Expertise in designing, building, and optimizing data pipelines, warehouses, and datalakes. 
• Bachelor's degree in Computer Science, MIS, Computer Information Systems or new graduate or 1+ year of experience
• Excellent knowledge of SQL and MySQL, including complex query writing, database design, and performance tuning.
• Knowledge of 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!