Data Specialist - Periscope, New Ventures
McKinsey & Company
hace 5 días


  • At least 5-8 years of experience in the field of business intelligence and ETL, working with tools such as SQL Server, Alteryx, Report Builder and / or Tableau
  • Bachelor’s or master’s degree in Business Intelligence or related technical field
  • Strong coding and development abilities in SQL, SSIS and other ETL tools
  • Data Visualization experience working with Exasol, ANSI SQL, Python, GIT, Jenkins, Splunk, Lua, and / or SAP is strongly preferred
  • Knowledge of data mining, machine learning and statistical modelling is preferred
  • Preferred experience in consumer products, retail or banking
  • Excellent time management skills
  • Ability to act autonomously, bringing structure and organization to work
  • Sound problem-solving skills
  • Understanding of basic financial and business terminology
  • Creative and action-oriented mindset
  • Strong communication skills in English; communication skills in other languages is advantageous
  • Ability to travel abroad, typically on same continent, for working sessions and meetings

    You will work with our Periscope team in Mexico City, Mexico. Periscope is part of McKinsey New Ventures.

    Periscope leverages decades of McKinsey’s marketing and sales experience helping leading companies improve pricing, promotion, assortments, and performance management.

    Periscope’s combination of software, tailored services, and expertise provides our clients with a granular view of their commercial and financial performance by gathering and integrating their landscape of data and information into a central data warehouse.

    Clients can use our intuitive interface to make decisions based on advanced analytics and can embed new pricing, commercial, and performance management capabilities throughout their organization.

    New Ventures fosters innovation driven by analytics, design thinking, mobile and social by developing new products / services and integrating them into our client work.

    It is helping to shift our model toward asset-based consulting and is a foundation for and expands our investment in - our entrepreneurial culture.

    Through innovative software as a service solutions, strategic acquisitions, and a vibrant ecosystem of alliances, we are redefining what it means to work with McKinsey.

    As one of the fastest-growing parts of our firm, New Ventures has more than 1,000 dedicated professionals (including more than 800 analysts and data scientists) and we’re hiring more mathematicians, data scientists, designers, software engineers, product managers, client development managers and general managers.


    You will own the data extraction for various projects and manage ETL (extract, transform, and load) development.

    This requires an understanding of the business requirements and the ability to transform the requirements into technical specifications.

    You'll also design and drive the ETL development which includes planning, organizing and driving development work by undertaking complex analysis to accomplish the project objective.

    You'll develop ETL core modules and lead junior resources in the development of remaining ETL. You'll also lead the presentation of results and would be expected to independently design presentations to summarize the results of the analysis.

    You'll have the opportunity to expand your business knowledge by developing a deep understanding of the domain and function across pricing, promotions, trade architecture, etc.

    You'll also develop cross-site relationships to enhance idea generation, you'll set and manage partner expectations and you'll coach and mentor new hires by sharing your expertise.

    Añadir a los favoritos
    Eliminar de mis favoritos
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", acepto que neuvoo recolecte y procese mis datos de conformidad con lo establecido en su Política de privacidad . Tengo derecho a darme de baja o retirar mi autorización en cualquier momento.
    Formulario de postulación