Marsh McLennan
Marsh McLennan
Marsh McLennan ir globāls profesionālo pakalpojumu uzņēmums, kas sniedz konsultācijas riska pārvaldības, stratēģijas un ar cilvēkiem saistītās jomās. Tā uzņēmumu vidū ir Marsh, kas nodrošina apdrošināšanas brokeru pakalpojumus un riska pārvaldību, Guy Carpenter, kas koncentrējas uz pārapdrošināšanu un kapitāla stratēģijām, Mercer, kas sniedz konsultācijas veselības, labklājības un karjeras jomā, kā arī Oliver Wyman, kas specializējas stratēģijas, ekonomikas un zīmola konsultācijās. Marsh McLennan visā pasaulē strādā vairāk nekā 85 000 darbinieku, un uzņēmums apvieno zināšanas finansēs, konsultācijās, mārketingā un citos saistītos profesionālo pakalpojumu veidos. Uzņēmuma personāla atlase aptver amatus, kas atbalsta klientu konsultēšanu, riska analīzi, biznesa stratēģiju, konsultāciju un operatīvās komandas visos četros uzņēmumos.

Senior Business Analyst, SQL and Excel

Lead SQL and Excel analytics for Oliver Wyman consulting projects, guiding teams and interpreting financial statements. Deliver commercial insights for clients and senior stakeholders.

Apraksts

  • Manage analytical delivery across multiple project workstreams from start to finish
  • Lead workstream planning and execution, delivering timely, high-quality results
  • Coach Analysts and Senior Analysts on requirements, task planning, execution reviews, and skill development
  • Set task priorities across competing deadlines
  • Check SQL pipelines, Excel models, and analytical frameworks for accuracy and sound practices
  • Maintain governance, documentation, and clear information flow across deliverables
  • Analyze financial statements to surface revenue, cost, margin, and cash flow insights
  • Find cost leakage, working capital inefficiencies, and opportunities to improve commercial performance
  • Estimate workstream effort, set analytical approaches, and connect outputs to measurable business value
  • Create analytical frameworks, templates, and reusable materials
  • Turn unclear business questions into structured analytical plans
  • Act as the main contact for global or senior-level clients and internal stakeholders
  • Lead requirements discussions and align stakeholders on business outcomes
  • Present practical insights to inform leadership decisions
  • Spot analytical risks, dependencies, data gaps, and bottlenecks, then plan ways to address them
  • Improve analytical processes, reporting standards, and project efficiency
  • Contribute knowledge materials, documentation, and standardized KPI frameworks

Prasības

  • At least 6 years of hands-on SQL and Excel experience, including advanced query optimization, data modeling logic, and complex calculations
  • Ability to lead teams through structured problem-solving and deliver high-quality project work
  • Strong business understanding and skill in turning data into useful financial, commercial, and operational insights
  • Advanced ability to read and analyze complete financial statements, including profit and loss, balance sheet, and cash flow statements
  • Excellent communication and stakeholder management skills with senior and global clients
  • Strong experience in commercial analytics, pricing, supply chain, or operations analytics; manufacturing experience is preferred
  • Ability to lead teams, assign tasks, manage workloads, and deliver on time
  • Proactive, entrepreneurial approach to improvements, risks, and finding solutions
  • Strong ownership, discipline, and ability to work independently
  • Expert-level SQL and Excel skills
  • Availability to work from a local office or client site at least three days per week

Priekšrocības

  • Hybrid arrangement with flexibility to work remotely
  • Opportunities for collaboration, connection, and professional development through office work
  • Flexible work environment
  • Commitment to diversity and inclusion

Saistītās vakances