\n\n","datePosted":"2023-11-21T13:14:13.644Z","validThrough":"2025-03-22","employmentType":[],"hiringOrganization":{"@type":"Organization","name":"McKinsey & Company","description":"McKinsey & Company is a global management consulting firm, the trusted advisor to the world's leading businesses, governments, and institutions. McKinsey & Company provides solutions for issues of concern to senior management in large corporations and organizations. It provides advisory services to the world's leading businesses, governments, and institutions. It also provides industry practice solutions and functional practice solutions. Its industry practice solutions include advanced electronics, chemicals, metal and mining, electrical power, consumer goods, and more. Its functional practice solutions include business technology, corporate finance and sales, operations, and other related areas. McKinsey & Company was established in 1926 and is based in London, United Kingdom. It operates additional offices on each continent. When James O. McKinsey founded McKinsey in 1926, he could not have imagined the reach his small firm would eventually have. Eighty-seven years later, the firm has grown into a global partnership serving two-thirds of the Fortune 1000.","numberOfEmployees":42,"address":[{"address":{"@type":"PostalAddress","addressLocality":"San Francisco, CA, USA"}},{"address":{"@type":"PostalAddress","addressLocality":"New York, NY, USA"}}],"sameAs":"https://mckinsey.com","url":"https://mckinsey.com","logo":"https://cdn.getro.com/companies/e20b4f25-1e5b-56f8-8e43-67e685f4fec7","memberOf":{"@type":"Organization","name":"ASU+GSV Summit","description":"The ASU+GSV Summit is the Knowledge Economy's Mecca of conversation and activism devoted to accelerating learning innovation around the world. Register now for the 2015 ASU+GSV Summit, taking place April 6-8, 2015 at The Phoenician Resort in Scottsdale, AZ.","logo":"https://cdn.filestackcontent.com/UhLZ0idCRtyeZchOPpg5","url":"jobs.asugsvsummit.com"},"keywords":"Finance, Professional Services"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"San Jose, CA, USA"}}}
Analytics
Apply Now
Data Specialist - Growth, Marketing & Sales
McKinsey & Company
Marketing & Communications, IT, Sales & Business Development
San Jose, CA, USA
Posted 6+ months ago
Data Specialist - Growth, Marketing & Sales
Who You'll Work With
You will be based in Costa Rica office and will be part of our Growth, Marketing & Sales practice.
The Growth, 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 by McKinsey is the technology backbone of McKinsey’s Growth, Sales & Marketing Practice. Founded in 2007, it combines world-leading intellectual property, prescriptive analytics and cloud-based tools, with expert support and training. This unique combination drives revenue growth –now, and in the future. We enable our clients to make better commercial decisions faster by uncovering actionable insights.
Periscope’s suite of solutions helps organizations accelerate and transform their category management and revenue growth management. It combines world-class IP, enriched data, cloud-based tools, and end-to-end capability building to create actionable insights and new ways of working. This combination helps to drive lasting performance improvement, a 2-7% increase in return on sales (ROS), and margin management. With experts and analysts around the world, the portfolio of solutions is comprised of: Marketing Solutions, Customer Experience Solutions, Category Solutions, B2C Pricing Solutions, B2B Pricing Solutions and Sales Solutions. These are complemented by ongoing client service and custom capability building programs.
Periscope has a presence in 28 locations across six continents, 35+ capabilities, and a team of 800+ IT and business professionals and 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 perform data transformation, modeling and validation activities as well as configure applications to client context.
In this role, you will touch upon data extraction and data manipulation. You will take ownership in extracting data for the various projects and organizing the ETL developments. You will design and drive the ETL development as well as plan, organize and drive the development work and undertake complex analysis to accomplish the project objective. You will develop ETL core modules and lead junior resources in the development of remaining ETL.
You will work 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 incorporating best practices to achieve efficiency gains that will provide a sustainable set-up that can be supported on a long term.
You will independently design presentations to summarize the results of analysis. You will also have the opportunity to develop a deep understanding of the domain/function (across pricing, promotions, trade architecture and assortment) and manage the business process in the work area along with developing cross-site relationships to enhance idea generation. You will also define and manage partner expectations and you'll coach and mentor new hires by sharing your business, functional and technical expertise.
You will also collaborate with the team in coding, testing and executing project requests. You will support ongoing business processes by delivering high-quality end products on time and by performing quality checks wherever required.
Qualifications
- Bachelor’s degree in computer science, information systems or closely related field
- 5+ years of experience in data architecture in a professional services environment is highly preferred
- Strong data architecture knowledge including building data models, ER diagrams and data interaction pipeline
- Hands on experience in data extraction (extract, Schemas, corrupt record handling and parallelized code), transformations and loads (user - defined functions, join optimizations)
- Strong coding skills in Python, PySpark
- Good knowledge of SQL performance tuning
- Experience in developing Spark applications using Spark - SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data
- Good knowledge of Jenkins, code version control
- Ability to interact in a fluid, demanding and unstructured environment where priorities evolve constantly and methodologies are regularly challenged
- Comfortable with ambiguity; self-motivated with strong sense of ownership
- Excellent analytical and problem-solving skills, including the ability to disaggregate issues, identify root causes and recommend solutions
- Collaborative and able to motivate team members; ability to work well within teams across continents/time zones
Job Skill Group - N/A
Job Skill Code - DSS1 - Data Specialist (S1)
Function - Marketing & Sales
Industry - High Tech;Semiconductors
Post to LinkedIn - Yes
Posted to LinkedIn Date - Tue Aug 15 00:00:00 GMT 2023
LinkedIn Posting City - San Jose
LinkedIn Posting State/Province -
LinkedIn Posting Country - Costa Rica
LinkedIn Job Title - Data Specialist - Growth, Marketing & Sales
LinkedIn Function - Consulting;Information Technology
LinkedIn Industry - Computer Software;Information Technology and Services
LinkedIn Seniority Level - Mid-Senior level
Job Skill Code - DSS1 - Data Specialist (S1)
Function - Marketing & Sales
Industry - High Tech;Semiconductors
Post to LinkedIn - Yes
Posted to LinkedIn Date - Tue Aug 15 00:00:00 GMT 2023
LinkedIn Posting City - San Jose
LinkedIn Posting State/Province -
LinkedIn Posting Country - Costa Rica
LinkedIn Job Title - Data Specialist - Growth, Marketing & Sales
LinkedIn Function - Consulting;Information Technology
LinkedIn Industry - Computer Software;Information Technology and Services
LinkedIn Seniority Level - Mid-Senior level