DWH Data Engineer

Before jumping in on all the information about the role and what you can bring to the table, let us introduce ourselves real quick.
About us
We are Insider, a B2B SaaS company that drives growth for its clients around the world. How are we achieving this? We are the #1 AI-native platform for Customer Experience and Marketing—offers marketers a single platform to deliver unique experiences per person, drive profitable growth, and unleash peak productivity and efficiency. Our platform connects data across channels, predicts future behavior with AI, and individualizes experiences from a single platform. We’ve unlocked unicorn status following our Series D round We are backed by top-notch investors, including Sequoia Capital, QIA, Riverwood, and Endeavor Catalyst, and trusted by 1200+ brands from high-growth startups to the most prestigious Fortune 500 companies such as Samsung, Coca Cola, Nike, L’Oreal, Singapore Airlines, Virgin, Nestle, Nissan, Lenovo, Puma, IKEA, Allianz, Dominos, Avon, CNN, and the list goes on.Having recently unlocked unicorn status, Insider was congratulated for becoming one of the only woman-founded, women-led B2B SaaS unicorns in the world, to achieve $200M USD in CARR (Committed Annual Recurring Revenue). Insider was named a leader in the The Forrester Wave for Cross-Channel Campaign Management 2021, and Leader in the IDC MarketScape: Worldwide Omnichannel Marketing Platforms for B2C Enterprises 2023 Assessment. The company has been recognized in The Top 1% of all software companies worldwide in G2’s 2024 Software Awards, and named in The Top 10 Best Software Products with the most #1 rankings alongside other software legends like Google, Zoom, and Monday.com. According to G2’s Spring’24 reports. Insider is also the #1 G2 Leader in 6+ categories, including Customer Data Platforms (CDP), Personalization Engines, Personalization Software, Mobile Marketing, Customer Journey Analytics, and eCommerce Personalization.
When our team founded Insider, they not only sought to create a product company, but to build the most socially progressive technology community in the world. Through our corporate social responsibility initiatives like 100projects shecodes, sheleads and shemarkables, our community has committed to scaling its impact into our communities across 27+ countries, spearheading transformative projects in areas such as health, education, farming, animal rights, and increasing the proportional representation of women in STEM careers. 
Behind all these achievements, there is an exceptionally talented and passionate team across 27+ countries that moves fast and agile, creates cutting-edge products, and focuses on making an impact. If you want to join us on this journey, just keep reading.
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;

• 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!

We provide equal opportunity in a zero-discrimination workplace and not just welcome but also embrace everyone without regard to sex, race, color, nationality, religion, gender identity, sexual orientation, disability status, citizenship, or marital status.
Please follow Insider on LinkedIn, Instagram, Youtube, and Medium!