Data Specialist - Orpheus

Mckinsey Dallas , TX 75201

Posted 2 days ago

You'll be working with our Orpheus team based in our Waltham or Dallas office.

This group is part of our Product Development and Procurement (PDP) service line within the Operations practice. You will be joining McKinsey's fastest growing team in the procurement arena and taking cutting edge technology solutions to clients.

Orpheus infuses best-in-class technology and AI-based analytics with deep supply-market and category-sourcing expertise. You'll be part of a team that is a core element of the digitally-enabled procurement function of the future. This will involve all business value chain activities from product development to distribution and playing a strategic role in managing budgets and costs, anticipating and mitigating supply risk, driving compliance, and generating transparency to external spend in an organization.

You will deliver and implement Orpheus together with our strong delivery teams with close collaboration with our consulting teams as well as directly with clients.

A typical project involves the following steps: project scoping, data identification and extraction, data processing, engineering and enrichment, data cleansing and categorization, spend analysis and opportunity identification, handover, insights presentation and capability building.

Your main expertise and responsibility will be data identification and extraction. Leveraging proprietary and third-party data-extraction tools (e.g. Snaplogic), you will identify spend relevant data from general ledger, purchase order, material & supplier master and other relevant tables within ERP or data/business warehouse applications.

You will conduct data assessment, perform data quality checks, transform and load raw data using SQL and ETL tools. With your experience in data engineering and data models, you will build sustainable data pipelines and adjust them for special needs.

In addition to project delivery, you will contribute and sometimes lead operational improvements in exiting solutions. You'll contribute in building out further proprietary solutions or data assets, identifying new technologies, trends, or alternative vendors for us to work with. You will ensure digital procurement assets, vendors, and processes adhere to our standards and that client information and data is safeguarded to the utmost level.

  • Undergraduate degree; business or STEM related field a plus

  • 5+ years of relevant professional work experience with a reputed procurement consultancy, spend analytics solution or ERP implementer

  • Deep understanding of ERP data models (e.g. SAP, Oracle, Infor, Axapta), especially in the financial "FI" and material master "MM" modules

  • Strong coding knowledge/ abilities in the field of large data handling through Microsoft SQL (T-SQL), Microsoft SQL Server Management Studio, data manipulation and ETL tools using Alteryx; alongside knowledge of VBA/Macros

  • Java development skills, PowerShell or other scripting experience will be added advantage

  • Understanding of data warehousing, data lake concepts and Tableau dashboards, visualizations, etc.

  • Basic understanding of purchasing, procurement processes, sourcing and saving opportunity identification is an advantage

  • Solid problem-solving capabilities including the ability to disaggregate issues, identify root causes and recommend solutions

  • Strong interpersonal, written/verbal communications skills

  • Willingness to travel (30-50% of time)

  • Ability to obtain security clearance which US Government regulations restrict to US citizens only

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Input And Customer Service Specialist (Dallas TX)

National Automotive Experts

Posted 7 days ago

VIEW JOBS 5/7/2021 12:00:00 AM 2021-08-05T00:00 Because this position is based in our Dallas, Texas office, an application at this time is not required. Please send your resume directly to Hiring Specialist @ At this time a Contract Receipt Specialist is needed to receive, sort, scan and distribute all incoming documents in a timely manner. Works under immediate supervision, relying on instructions and pre-established guidelines to perform job functions. $16.50 per hour/Exceptional Benefits Essential Functions: * Sort all incoming documents to be distributed to other departments. * Scan all incoming documents and confirm they are being organized accurately. * Find and retrieve all documents requested by processing and accounting. * Process incoming mailed cancellation requests. * Pull checks out of scanned batches for coding and loading into the system. * Contact appropriate parties to get missing information for checks. * Back-up processing team by entering contracts or invoices/memos. * Support contract requests. * Other duties as assigned. Work Environment and Physical Requirements: * Normal office environment. * Ability to sit or stand for prolonged periods of time. * Ability to hear and talk, both in person and by phone. * Ability to use a computer, calculator, and standard office equipment. * Vision acuity required to include close vision, color vision, distant vision, and the ability to adjust focus. * Ability to walk, stand, reach with hands and arms, stoop, kneel, crouch, and lift up to 25 pounds. Required Knowledge, Skills and Abilities: * Proficient in Microsoft Office programs such as Outlook, Excel, and Word. * Detail oriented, accurate and highly organized. * Excellent written and verbal communication skill. * Reliable and punctual. * Ability to plan, organize, prioritize, and complete assignments in a timely manner. * Ability to work both collaboratively and independently. * Ability to manage environmental and process change in a positive manner. * Ability to perform basic math functions, such as addition, subtraction, multiplication, and division. Required Education and Experience: * High school diploma or equivalent. * Minimum 2 year of basic administrative experience; preferably in an accounting-like role. * Ability to type 10,000 keystrokes alphanumeric with a minimum 90% accuracy. Preferred Skills: * Ability to work in a fast-paced environment. * Ability to communicate and work with a diverse team. National Automotive Experts Dallas TX

Data Specialist - Orpheus