Data Analyst - Marketing & Sales, Periscope

Do you want to work on complex and pressing challenges—the kind that bring together curious, ambitious, and determined leaders who strive to become better every day?If this sounds like you, you’ve come to the right place. Your Impact You will work with highly skilled team members designing and executing data pipelines. In this role, you will be responsible for performing data ingestion, data transformation and data uploads into applications. This entails using application administration tools (combination of proprietary tools), validating raw data quality (develop test cases, battery of QA scripts) and taking corrective measures in case of issues. You will also code and script (SQL, Python, etc.) for automating data transformation and loading. Lastly, you will have the opportunity to enjoy the combination of McKinsey’s highly professional environment and a start-up attitude of entrepreneurship and dynamics. Your Growth Driving lasting impact and building long-term capabilities with our clients is not easy work. You are the kind of person who thrives in a high performance/high reward culture - doing hard things, picking yourself up when you stumble, and having the resilience to try another way forward. In return for your drive, determination, and curiosity, we'll provide the resources, mentorship, and opportunities you need to become a stronger leader faster than you ever thought possible. Your colleagues—at all levels—will invest deeply in your development, just as much as they invest in delivering exceptional results for clients. Every day, you'll receive apprenticeship, coaching, and exposure that will accelerate your growth in ways you won’t find anywhere else. When you join us, you will have: • Continuous learning:Our learning and apprenticeship culture, backed by structured programs, is all about helping you grow while creating an environment where feedback is clear, actionable, and focused on your development. The real magic happens when you take the input from others to heart and embrace the fast-paced learning experience, owning your journey. • A voice that matters:From day one, we value your ideas and contributions. You’ll make a tangible impact by offering innovative ideas and practical solutions. We not only encourage diverse perspectives, but they are critical in driving us toward the best possible outcomes. • Global community:With colleagues across 65+ countries and over 100 different nationalities, our firm’s diversity fuels creativity and helps us come up with the best solutions for our clients. Plus, you’ll have the opportunity to learn from exceptional colleagues with diverse backgrounds and experiences. • World-class benefits:On top of a competitive salary (based on your location, experience, and skills), we provide a comprehensive benefits package to enable holistic well-being for you and your family. Your qualifications and skills • Bachelor's degree in computer science, information technology, engineering or related degree • 1 +years of experience in the field of data management, IT (database-focused), ETL and/or data analysis domains • Experience with SQL language, Python and Excel • Ability and passion to work with big data technologies (Hadoop, Spark) • Exposure to AWS, Databricks and MS Azure is a plus • Experience working on Agile teams is a plus • Excellent time management skills • Strong interpersonal skills including assertiveness and client oriented mindset • Sound problem-solving skills and action-oriented mindset • Can do attitude for getting the task executed; creative implementation of technology • Ability to cope with pressure and demonstrate a reasonable level of flexibility/adaptability • Fluent communication and written skills in English