About the co.– Our client is an agency of the world’s largest media investment company which is a part of WPP. It is a global digital transformation agency with 1200 employees across 21 nations. Our team of experts support clients in programmatic, social, paid search, analytics, technology, organic search, affiliate marketing, e-commerce and across traditional channels.
Job Location: Gurgaon
Reporting of the role This role reports to the Technology Architect,
Key Accountabilities: This role is for a Technical Specialist who can understand and solves complex functional, technical, and architectural practices that cover data and can understand the end-to-end data lifecycle capabilities and technologies and provide architectural guidance in the selection, articulation, and use of the chosen solutions.
The successful candidate will be expected to interact with all levels of the business and technical community, seeking strong engagement with all stakeholders. The candidate should be an expert in functional data architecture & design, including strong data modelling. A candidate who is self-disciplined, with a keenness to master, suggest, and work with different technologies & toolsets. The role would also involve intensive interaction with the business and other technology functions, so good communication skills and the ability to work under pressure is essential
What you’ll bring:
5-7 years of strong experience in working with SQL, Python, ETL development, and AWS.
Strong Experience in writing complex SQLs
Good Communication skills Work with senior staff and business leaders to identify requirements for data/information across the core business domains
Work with Project Managers Business Analysts and other subject matter experts to identify and understand requirements
Good experience working with any BI tool like Tableau, or Power BI. Familiar with various cloud technologies and their offerings within data specialization and Data Warehousing.
Snowflake is good to have.
Minimum qualifications:
B. Tech./MCA preferred
Excellent 5 years Hand on experience in Big data, ETL Development, and Data Processing
Regards
Team Merito

Similar jobs
The Search Engine Optimization (SEO) Intern will be responsible for research, implementation, monitoring, and reporting on client organic search campaigns. The ideal candidate will be a quick learner with an attention to detail, passion, and a positive attitude.
Essential Duties and Responsibilities
- Auditing existing websites
- Competitive research and benchmarking
- Keyword research and mapping
- Content writing and optimization
- On-page optimization
- Link building outreach
- Monitoring and evaluating results and building reports on those results for our clients
Qualifications
- A hunger for learning and the ability to perform independent research to solve problems
- Proficiency with Google Sheets
- Working knowledge of search engine optimization and/or digital marketing is preferred
- Ability to thrive while working on multiple projects with strict deadlines
- Ability to work well with all teams across the agency
- Commitment to completing work on time that meets or exceeds expectations of quality
Experience 5-10 yrs
Bangalore North- Western
1. **Office Management & Administration**
- Oversee daily office operations to ensure the smooth functioning of the workspace.
- Manage office supplies and equipment, ensuring all resources are available and in working order.
- Coordinate maintenance and repairs to keep the office safe and efficient.
- Handle document organization, filing, and data management for quick retrieval and better productivity.
- Schedule meetings, coordinate travel, and support event planning for team or client events.
2. **Client & Partner Communication (Mandarin-English) **
- Act as the primary liaison for Mandarin-speaking clients or partners.
- Translate documents, emails, and other communications from Mandarin to English and vice versa.
- Assist in meetings by providing translation or language support to ensure effective communication.
- Coordinate with vendors or partners in Mandarin-speaking regions, ensuring all requirements are met and deadlines respected.
3. **Financial & Resource Management**
- Assist in budgeting and expense tracking, keeping an organized record of office expenditures.
- Manage petty cash and process reimbursements or invoices for the team.
- Collaborate with finance or HR teams to process payroll, employee benefits, or expense reports.
4 **Coordination with External Stakeholders**
- Coordinate with building management, vendors, and contractors for office upkeep.
- Arrange logistics for client visits, including transportation, accommodation, and meeting schedules if needed.
- Ensure compliance with local laws, regulations, and safety protocols.
5. **Administrative Support for Senior Management**
- Provide executive assistance to senior leaders, such as managing their schedules, emails, and travel arrangements.
- Prepare presentations, reports, and correspondence as needed.
6. **IT & Communication Systems Management**
- Coordinate with IT support for the setup and maintenance of office computers, phones, and internet.
- Ensure that communication systems (like video conferencing tools) are functional for smooth client calls.
1. Develop product positioning and messaging that differentiates your products in the market
2. Be both an internal inspirational leader and a powerful external voice / ambassador for us
3. Have experience in using tools like white papers and thought pieces to build the brand image
4. Be able to optimize the balance between digital and physical marketing strategies & tactics
5. Communicate the value proposition of the products to the sales team and develop the sales tools
that support the selling process of your products
6. Develop and take-to-market compelling value propositions that reflect the buying needs of our
target segments and persona in a timely and compelling way.
7. Demand generation develop the strategy and manage the marketing programs that drive demand
for your products
8. To build a world class team and manage existing team of marketing managers, content marketers
Additional Requirements:
6+ years of software(Saas) product marketing experience with at least 3 years experience in a online digital marketing
Masters in business or marketing
Very strong written communication skills
Excellent people and management skills to interact with colleagues and cross functional
teams, and third parties.
1. A nimbleness that reflects the culture of a dynamic and high growth young company.
2. A data driven approach to problem solving and critical thinking
3. Inspirational with a bias for action
4. Driven by a buyer’s perspective
5. Constant ownership and effective accountability.
6. Able to quickly establish trust across all contributing departments
7. Demonstrably innovative and excited by ideas.
8. Articulate, structured and influential.
What is in it for you:
Opportunity to learn, grow and be a role model for young team members
One of the best ESOP programs
Group health insurance and other financial benefits
Meritocratic culture with the promise of rapid career progression.
Experience of a growing company with a focus on the personal growth of all team members
Opportunity to work with the Founding Team.
ROLE/SKILLS:
7-10 years of experience, including 3+ years of lead experience, preferably working for a startup. The Creative Lead leads the design process including initial requirements definition and conceptualization with the Business Analysis teams and the project managers. A designer contributes to the evolution and improvement of the existing design process. The Creative Lead also collaborates with the internal teams to develop creative strategy. In addition, he or she also converts complex technical and/ or business concepts into compelling visuals/ graphics.
Job Description:
- The roles and responsibilities of the Creative Lead include the following:
- Overseeing all digital projects and being responsible for the overall quality of the design deliverable.
- Directing the creative team in production of digital assets and other deliverables online and in prints.
- Communicating and creating an overall creative team vision by defining the direction and goals for the group.
- Setting and maintaining creative standards for the department
- Writing project creative briefs especially for web and mobile layouts (the train of thoughts)
- Adhering to compliance procedures and internal/ operational risk controls in accordance with all applicable regulatory standards, requirements, and policy.
Industry: Digital Marketing & Web and App Development
Functional Area: IT Software – eCommerce, Internet Technologies, Mobile Apps
About our Client :-
Our Client is a global data and measurement-driven media agency whose mission is to make brands more valuable to the world. Clients include Google, Flipkart, NBCUniversal, L'Oréal and the Financial Times. The agency is more than 2,000 people strong, manages $4.5B in annualized media spend, and deploys campaigns in 121 markets via 22 offices in APAC, EMEA and the Americas.
About the role :-
Accountable for quantifying and measuring the success of our paid media campaigns and for delivering insights that enable us to innovate the work we deliver at MFG. Leading multi-product projects, developing best practices, being the main point of contact for other teams and direct line management for multiple team members.
Some of the things we’d like you to do -
● Build a deep understanding of marketing plans and their objectives to help Account teams (Activation, Planning, etc) build comprehensive measurement, and test & learn plans
● Play an instrumental role in evolving and designing new, innovative measurement tools. Managing the process through to delivery and take ownership of global roll out
● Recruit, manage and mentor analytical resource(s), ensuring the efficient flow of work through the team, the timely delivery of high-quality outputs and their continuing development as professionals
● Lead the creation of clear, robust and thought-provoking campaign reviews and insights
● Work with Account teams (Activation, Planning, etc) to help define the correct questions to understand correct metrics for quantifying campaign performance
● To help deliver “best in class” analytical capabilities across the agency with the wider Analytics team, including the use of new methods, techniques, tools and systems
● Develop innovative marketing campaigns and assist clients to define objectives
● Develop deep understanding of marketing platform testing and targeting abilities, and act in a consultative capacity in their implementation
● Provide hands-on leadership, mentorship, and coaching in the expert delivery of data strategies, AdTech solutions, audiences solutions and data management solutions to our clients
● Leading stakeholder management on certain areas of the client portfolio
● Coordination and communication with 3rd party vendors to critically assess new/bespoke measurement solutions. Includes development and management of contracts and SOWs.
A bit about yourself -
● 8+ years of experience in a data & insight role; practical experience on how analytical techniques/models are used in marketing. Previous agency, media, or consultancy background is desirable.
● A proven track record in working with a diverse array of clients to solve complex problems and delivering demonstrable business success. Including (but not limited to) the development of compelling and sophisticated data strategies and AdTech / martech strategies to enable
marketing objectives.
● Ideally you have worked with Ad Platforms, DMPs, CDPs, Clean Rooms, Measurement Platforms, Business Intelligence Tools, Data Warehousing and Big Data Solutions to some degree
● 3+ years of management experience and ability to delegate effectively
● Proficiency with systems such as SQL, Social Analytics tools, Python, and ‘R’
● Understand measurement for both Direct Response and Brand Awareness campaigns desired
● Excellent at building and presenting data in a visually engaging and insightful manner that cuts through the noise
● Strong organizational and project management skills including team resourcing
● Strong understanding of what data points can be collected and analyzed in a digital campaign, and how each data point should be analyzed
● Established and professional communication, presentation, and motivational skills
About CITTA
The Lexicon Group, under the leadership of Pankaj Sharma has journeyed from very humble beginnings and has seen an upward growth year after year. The Lexicon Group started from education but has now diversified to other sectors like FMCG, Ed-tech, Law Aggregator Platform, Media, Fitness etc. The latest addition to the kitty of The Lexicon Group has been a newspaper (Pune Mirror and Civic Mirror), which has been taken over from the Times of India Group. The motto for The Lexicon Group is mindfully chosen ‘Believe in Yourself’, probably the three strongest words listed together which have the potential of changing lives if you believe in them and that is what Lexicon group try to ensure.
CITTA (Lexicon Lifestyle Private Limited) is a premium-quality natural baby bath and skincare brand that is safe, tested and gentle. CITTA Products are Free of Toxins, Parabens, Sulphates, Silicones, Mineral Oil, and Allergens and are Dermatologically Tested. We are a cruelty-free brand. We are expanding our core team, which is determined to achieve results.
Job Description
- Write, edit and publish content for websites, blogs, videos, social media posts/campaigns, email campaigns, podcasts, e-books, whitepapers, and more.
- Effective, consistent and reader-friendly writing style.
- Strong English writing skills and basic familiarity with the internet and search engines.
- Capable of writing an article on any subject, theme, blog or website.
- Ability to manage in a fast-paced and deadline-driven environment.
- Concise, clear and confident communication.
- Highly organized and self-motivated to establish and achieve goals.
- Create content that motivates, inspires, educates, informs, sells, and simply, provides information, across a wide variety of digital platforms.
- Work closely with content marketing and digital marketing to produce content that generates results
- A content writer should clearly understand the objectives, and target audience, and assure the content is user-friendly and keyword/SEO Optimized.
- Writing content as needed, including blogs, articles, web pages, etc.
- The content should be informative and engaging and should enable visitors to get their information promptly and efficiently.
Content and Relationship Manager Requirement
- Bachelor’s Degree in Mass Communication, English and Related field
- 1-2 years experience in writing content
- Strong communication and interpersonal skills and ability to build and maintain relationships
- Highly articulate with experience in developing content based on consumer needs or data insights
- Excellent command of written and spoken English, as well as an ability to assess visual communication, to enable evaluation of motivating, accurate and effective communications.
- Innovative, self-reliant and determined approach to duties with an ability to work and think creatively
- Attentive to detail and organized
- Must be self-motivated and flexible.
D
Hands-On Experience in the following technologies and should be immediately available :-
Core Java 8 Integrations - REST and SOAP MVC Postgres Spring, Spring Boot, Maven, Gradle AWS Docker CI CD Event driven Architecture React-jQuery, JS Splunk and Observability Tools.
Good to Have - MuleSoft or ETL Tools knowledge.
JOB RESPONSIBILITIES
# Handle the design, architecture, development, code review, and testing of key applications.
# Design client-side and server-side architecture, and write effective APIs
# Build the front-end of applications through appealing and mobile responsive visual design
# Work closely with the product management and design team to define feature requirements and deliver the product that mater ially impacts the business and improves the customer experience
# Identify performance bottlenecks and come up with novel ways to solve them.
# Develop technical documentation, work with analysts to continuously improve software.
SPECIALIZATION
Applications deploy new technologies rapidly to help grow the businesses while controlling IT costs. At Mindtree, we integrate the right tools, technologies and processes to eliminate redundancies, reduce costs and deliver a best-in-class applications portfolio using our end-to-end workflow-driven managed services platform. Our application services team acquires a deep understanding of the application portfolios and business processes to help manage the transition. Across various industry groups t hat we serve, we standardize processes and establish a baseline for continuous service improvement and implement agile, lean IT, DevOps and test automation..
Requirements :
a) CSS / Bootstrap : Flex Layout/ability to demonstrate the cascading nature of CSS clearly with example/Positioning.
b) Pure JavaScript: Prototype chain and inner workings of inheritance in JS. Understood DOM, Events, Event Bubbling, and Capturing/ ability to demonstrate it with example/ Promises and their use cases.
c) TypeScript: Basic understanding of using TS. Union Types, Index Signatures,
d) REST: Backend experience. REST principles, URL structures for APIs. integration using native JS (fetch and Promises) and in Angular. use cases of getting vs POST vs PUT vs PATCH.
e) Angular : Abstractions of Angular Component, Service, Pipe, Directive, Module, Lifecycles. Knew advanced patterns as well Dynamic Components, Content Projection, Reactive Forms, ViewChild, ContentChild. Understood Observables and various operators demonstration of Design Skills ability to create the component and module hierarchy for a moderately complex application, along with their interactions









