EY - GDS Consulting - AI and DATA -Mongo DB - Manager

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

EY GDS – Data and Analytics - D and A –Manager- Mongo DB

Knowledge of MongoDB and NoSQL Concepts

• Understanding of MongoDB: Familiarity with MongoDB's data model, document structure, and BSON (Binary JSON) format. Knowing how MongoDB stores and retrieves data is crucial.
• NoSQL Concepts: Understanding how NoSQL databases differ from relational databases, especially regarding schema flexibility, indexing, and querying.

Proficiency in Aggregation Framework

• Aggregation Operators: Knowledge of various operators such as $match, $group, $sort, $project, $lookup, $unwind, $addFields, $count, and $merge. Each of these operators serves a specific purpose in manipulating and transforming data.
• Pipeline Stages: Understanding how to use and chain different stages in a pipeline to achieve the desired results, such as filtering, grouping, sorting, reshaping documents, and performing calculations.
• Expression Syntax: Familiarity with MongoDB's expression syntax (e.g., $cond, $ifNull, $add, $subtract, etc.) used within various stages to perform computations or transformations on data.
   

Data Analysis Skills

• Analytical Thinking: Ability to break down complex requirements into smaller, manageable steps in the aggregation pipeline. This involves understanding the flow of data and transformations at each stage.
• Data Wrangling: Experience in data cleaning, normalization, and transformation, which is critical when preparing data for analysis or reporting.
   

Programming and Scripting Skills

• JavaScript: Basic knowledge of JavaScript, as MongoDB uses a JavaScript-like syntax in its queries and pipelines. Understanding JavaScript expressions can help in writing complex aggregation expressions.
• Experience with Scripting Languages: Experience in Python, Node.js, or other programming languages often used to interact with MongoDB. Knowledge of libraries or drivers that facilitate MongoDB operations is helpful.
   

Query Optimization and Performance Tuning

• Indexing: Understanding how to use indexes effectively in MongoDB to optimize aggregation performance. Knowing which fields to index and when to use compound indexes is important.
• Profiling and Debugging: Ability to use MongoDB’s tools like the query profiler and explain plans (db.collection.explain()) to debug and optimize aggregation pipelines.
   

Experience with Data Modeling

• Schema Design: Familiarity with designing schemas that take advantage of MongoDB's strengths, such as embedding documents vs. referencing, which affects how aggregation pipelines are structured.
• Normalization vs. Denormalization: Knowledge of when to normalize or denormalize data in MongoDB, as this impacts performance and the complexity of aggregation queries.
   

Understanding of Business Requirements

• Requirement Gathering: Ability to translate business requirements into technical requirements, understanding what kind of data manipulation or transformation is needed.
• Communication Skills: Interpreting requirements from non-technical stakeholders and explaining technical concepts in simple terms.

Experience with Real-world Use Cases

• Practical Experience: Hands-on experience working with MongoDB in real projects, such as building reports, dashboards, or data analytics solutions using aggregation pipelines.
• Domain Knowledge: Understanding the specific data and business domain you are working with, such as e-commerce, finance, healthcare, etc., to write more effective and relevant pipelines.

Familiarity with MongoDB Tools and Ecosystem

• MongoDB Compass: Experience using MongoDB Compass or other GUI tools to visualize and build aggregation pipelines interactively.
• MongoDB Shell: Proficiency with MongoDB Shell (mongosh) for writing, testing, and debugging aggregation queries.
• MongoDB Atlas and Cloud Tools: Knowledge of MongoDB Atlas features, such as monitoring, performance optimization, and automated backups, can be useful.

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.