Python Programming, PySpark, SQL, Apache Airflow, Databricks, Kedro, AWS, Google Cloud Platform (GCP), Azure, Scala Programming, RDBMS, PostgreSQL, Amazon RedShift, Teradata, Snowflake, NoSQL, Apache Cassandra, Neo4J, Titan, MongoDB
Who You'll Work With
You’ll join the San José hub and be part of Periscope. Periscope is part of the Marketing & Sales (M&S) Solutions team in the Marketing & Sales Practice. M&S Solutions was set up to house all the Marketing and Sales Practice’s repeatable analytics, repeatable digital, and solutions. This is part of the firm-wide effort called New Solutions to build more asset-led consulting capabilities.
The Marketing & Sales Practice strives to help clients in both consumer and business-to-business environments on a wide variety of marketing and sales topics. Our clients benefit from our experience in core areas of marketing such as branding, customer insights, marketing ROI, digital marketing, CLM, pricing, and sales and channel management. Our Practice offers an exceptional opportunity to work at the intersection of marketing, sales and consulting. Focusing on issues like redefining marketing and sales operations and commercial transformation, our people help clients build capabilities and transform how companies go to market - moving them to customer centric organizations.
Periscope has a presence in 27 locations across 16 countries with a team of 800+ IT and business professionals and a network of 300+ experts. To learn more about how Periscope’s solutions and experts are helping businesses continually drive better performance, visit www.mckinsey.com/periscope
What You'll Do
You will lead a team of data engineers to determine database structural requirements by analyzing client operations, applications, and programming, and review objectives with clients and evaluate current systems.
As a data expert, you will design and drive the ETL development. You will plan, organize and drive development work, and undertake complex analysis to accomplish the project objective. You will also develop ETL core modules and lead junior resources in the development of remaining ETL.
You will develop database solutions by designing proposed systems, defining database physical structure and functional capabilities, as well as maintain database performance by identifying and resolving production and application development problems. You will calculate optimum values for parameters by evaluating, integrating, and installing new releases, and will complete maintenance and answer questions. You will also provide database support by coding utilities, responding to user questions, and resolving problems.
You will ensure optimization and automation by working on existing sub-optimized processes to identify room for improvements. You will design and drive the work plan for the optimization/automation and standardization of the processes.
As part of your responsibilities, you will be in charge of independently designing presentations to summarize the result of analysis for results presentation purposes.
Additionally, you will have the opportunity to develop deep understanding of the domain/ across pricing, promotions, trade architecture and assortment.
You will have the responsibility to ensure teamwork by developing cross-site relationships to enhance idea generation, setting and managing partner expectations. You will coach and mentor new hires by sharing business, functional and technical expertise. Lastly, you will collaborate with the team in coding, testing and executing project requests, and you will support ongoing business processes by delivering high quality products on time and performing quality checks.
Qualifications
McKinsey & Company is a management consulting firm, founded in 1926 by University of Chicago professor James O. McKinsey, that advises on strategic management to corporations, governments, and other organizations. McKinsey is the oldest and largest of the Big Three management consultancies (MBB), the world's three largest strategy consulting firms by revenue. It has consistently been recognized by Vault as the most prestigious consulting firm.
Paris, France
2-4 year
Berlin, Germany
2-4 year
Hanoi, Hoàn Ki?m, Hanoi, Vietnam
2-4 year
Chennai, Tamil Nadu, India
2-4 year
Gurugram, Haryana, India
2-4 year
Denver, CO, USA
2-4 year
Düsseldorf, Germany
0-2 year
Abu Dhabi - United Arab Emirates
2-4 year
Atlanta, GA, USA
2-4 year
Boston, MA, USA
2-4 year
Dallas, TX, USA
2-4 year
Düsseldorf, Germany
2-4 year
Düsseldorf, Germany
2-4 year
Frankfurt, Germany
2-4 year
Hamburg, Germany
2-4 year
Johannesburg, South Africa
2-4 year
Munich, Germany
2-4 year
New Jersey, USA
2-4 year
Paris, France
2-4 year
Rio de Janeiro, State of Rio de Janeiro, Brazil
2-4 year
Riyadh Saudi Arabia
2-4 year
Waltham, MA, USA
2-4 year
Berlin, Germany
2-4 year
Berlin, Germany
2-4 year
Düsseldorf, Germany
2-4 year
Düsseldorf, Germany
2-4 year
Frankfurt, Germany
2-4 year
Hamburg, Germany
2-4 year
Munich, Germany
2-4 year
Munich, Germany
2-4 year
Atlanta, GA, USA
2-4 year
Austin, TX, USA
2-4 year
Boston, MA, USA
2-4 year
Charlotte, NC, USA
2-4 year
Chicago, IL, USA
2-4 year
Dallas, TX, USA
2-4 year
Houston, TX, USA
2-4 year
Lisbon, Portugal
2-4 year
Montreal, QC, Canada
2-4 year
New Jersey, USA
2-4 year
Philadelphia, PA, USA
2-4 year
Stamford, CT, USA
2-4 year
Toronto, ON, Canada
2-4 year
Denver, CO, USA
2-4 year
Chicago, IL, USA
2-4 year
New York, NY, USA
2-4 year
New York, NY, USA
2-4 year
Paris, France
0-2 year
Hanoi, Vietnam
2-4 year
Paris, France
4-6 year
Düsseldorf, Germany
2-4 year
Washington D.C., DC, USA
8-10 year
Toronto, ON, Canada
8-10 year
Johannesburg, South Africa
4-6 year
San José Province, San José, Costa Rica
0-2 year
Milan, Metropolitan City of Milan, Italy
0-2 year
Atlanta, GA, USA
2-4 year
Boston, MA, USA
2-4 year
Dallas, TX, USA
2-4 year
Denver, CO, USA
2-4 year
Houston, TX, USA
2-4 year
Washington D.C., DC, USA
2-4 year
Toronto, ON, Canada
2-4 year
Brussels, Belgium
2-4 year
Amsterdam, Netherlands
2-4 year
Madrid, Spain
2-4 year
Lisbon, Portugal
2-4 year
Shenzhen, Guangdong Province, China; Beijing, China; Shanghai, China
0-2 year
Berlin, Germany; Cologne, Germany; Düsseldorf, Germany; Frankfurt, Germany; Hamburg, Germany; Munich, Germany; Stuttgart, Germany
0-2 year
Calgary, AB, Canada; Montreal, QC, Canada; Toronto, ON, Canada; Vancouver, BC, Canada
0-2 year
Atlanta, GA, USA; Austin, TX, USA; Boston, MA, USA; Charlotte, NC, USA; Chicago, IL, USA; Cleveland, OH, USA; Columbus, OH, USA; Dallas, TX, USA; Denver, CO, USA; Detroit, MI, USA; Houston, TX, USA; Los Angeles, CA, USA; Miami, FL, USA; Minneapolis, MN, USA; New York, NY, USA; Philadelphia, PA, USA; Pittsburgh, PA, USA; San Francisco, CA, USA; Seattle, WA, USA; Silicon Valley, CA, USA; St. Louis, MO, USA; Stamford, CT, USA; Washington D.C., DC, USA
0-2 year
Calgary, AB, Canada; Montreal, QC, Canada; Toronto, ON, Canada; Vancouver, BC, Canada
2-4 year
São Paulo, Brazil
2-4 year
Atlanta, GA, USA; Austin, TX, USA; Boston, MA, USA; Charlotte, NC, USA; Chicago, IL, USA; Cleveland, OH, USA; Dallas, TX, USA; Detroit, MI, USA; Houston, TX, USA; Los Angeles, CA, USA; Miami, FL, USA; Minneapolis, MN, USA; New York, NY, USA; Philadelphia, PA, USA; Pittsburgh, PA, USA; San Francisco, CA, USA; Seattle, WA, USA; Silicon Valley, CA, USA; St. Louis, MO, USA; Stamford, CT, USA; Washington D.C., DC, USA
2-4 year
Calgary, AB, Canada; Montreal, QC, Canada; Toronto, ON, Canada; Vancouver, BC, Canada
6-8 year
Bogotá, Bogota, Colombia
6-8 year
Atlanta, GA, USA; Austin, TX, USA; Boston, MA, USA; Charlotte, NC, USA; Chicago, IL, USA; Cleveland, OH, USA; Dallas, TX, USA; Detroit, MI, USA; Houston, TX, USA; Los Angeles, CA, USA; Miami, FL, USA; Minneapolis, MN, USA; New Jersey, USA; New York, NY, USA; Philadelphia, PA, USA; Pittsburgh, PA, USA; San Francisco, CA, USA; Seattle, WA, USA; Silicon Valley, CA, USA; St. Louis, MO, USA; Stamford, CT, USA; Waltham, MA, USA; Washington D.C., DC, USA
6-8 year
Atlanta, GA, USA; Austin, TX, USA; Boston, MA, USA; Charlotte, NC, USA; Chicago, IL, USA; Cleveland, OH, USA; Dallas, TX, USA; Denver, CO, USA; Detroit, MI, USA; Houston, TX, USA; Los Angeles, CA, USA; Minneapolis, MN, USA; New Jersey, USA; New York, NY, USA; Philadelphia, PA, USA; Pittsburgh, PA, USA; San Francisco, CA, USA; Seattle, WA, USA; Silicon Valley, CA, USA; St. Louis, MO, USA; Stamford, CT, USA; Waltham, MA, USA; Washington D.C., DC, USA
4-6 year
Atlanta, GA, USA; Austin, TX, USA; Boston, MA, USA; Charlotte, NC, USA; Chicago, IL, USA; Cleveland, OH, USA; Dallas, TX, USA; Detroit, MI, USA; Houston, TX, USA; Los Angeles, CA, USA; Miami, FL, USA; Minneapolis, MN, USA; New Jersey, USA; New York, NY, USA; Philadelphia, PA, USA; Pittsburgh, PA, USA; San Francisco, CA, USA; Silicon Valley, CA, USA; St. Louis, MO, USA; Stamford, CT, USA; Waltham, MA, USA; Washington D.C., DC, USA
0-2 year
Toronto, ON, Canada; Montreal, QC, Canada
2-4 year
Rio de Janeiro, Brazil; São Paulo, Brazil
2-4 year
Atlanta, GA, USA; Austin, TX, USA; Boston, MA, USA; Charlotte, NC, USA; Chicago, IL, USA; Dallas, TX, USA; Houston, TX, USA; Los Angeles, CA, USA; New Jersey, USA; New York, NY, USA; Philadelphia, PA, USA; Seattle, WA, USA; Silicon Valley, CA, USA; Stamford, CT, USA; San Francisco, CA, USA; Washington D.C., DC, USA
2-4 year
Berlin, Germany; Brussels, Belgium; Frankfurt, Germany; Hamburg, Germany; Munich, Germany
2-4 year