8+ Data cleansing Jobs in India

About client:

Our client is the world’s largest media investment company. In fact, they are responsible for one in every three ads you see globally. In this role, you will be leading the advocacy narrative for a large cluster of brands for the largest FMCG organization in India.

BEST THINGS ABOUT THE JOB

1. Strategic Leadership Opportunities: As the Director of Product Marketing, you will play a pivotal role in shaping and driving the product marketing landscape for a leading consumer goods company. Your strategic insights and hands-on expertise will directly impact product marketing campaigns, contributing to the organization's growth and market dominance.

2. Transformational Role: In just three months, you'll immerse yourself in the product marketing landscape, and within a year, you'll lead process excellence, innovation, and collaboration. This dynamic progression will challenge you and provide a platform to showcase your capabilities in product marketing strategy.

3. Global Exposure and Collaboration: Working closely with global and APAC teams will allow you to collaborate across diverse markets, cultures, and strategies. Your insights will contribute to a cohesive global product marketing strategy, expanding your professional horizons.

4. Innovation and Creativity: The role offers the chance to introduce innovative product marketing strategies, technologies, and creative campaign approaches. Your ideas will drive exceptional results, ensuring that your creativity is recognized and celebrated.

5. Established Industry Leader: The FMCG brand is a market leader in the fast-moving consumer goods sector. Working with them means being a part of a company that values excellence, growth, and innovation. Your efforts will be instrumental in shaping the product marketing landscape for this industry giant.

REQUIRED EXPERIENCE

• You bring a proven track record of at least 8 years in product marketing, with progressively increasing responsibilities.

• Extensive hands-on experience with Google, Meta (Facebook, Instagram), Google Ads Data Hub, Snapchat, Spotify, and Programmatic Advertising platforms like The Trade Desk and DV 360.

• Working knowledge of Customer Data Platforms (CDP), Data Clean Rooms, First Party Data enhancement tools, and techniques.

REQUIRED COMPETENCIES

• Digital Marketing Expertise: Demonstrated expertise in digital marketing strategies, including SEO, SEM, social media, email marketing, content marketing, and more.

• Data Analysis: Proficiency in analysing data to derive actionable insights, track KPIs, and measure the effectiveness of campaigns. Experience with tools like Google Analytics, marketing 

automation platforms, and CRM systems.

• Process Optimization: Proven ability to design, implement, and optimize processes to improve efficiency and effectiveness. Knowledge of methodologies such as Lean, Six Sigma, or Agile is a plus.

• Project Management: Strong project management skills, including the ability to prioritize tasks, manage timelines, and ensure successful campaign execution within deadlines.

• Collaboration: Excellent communication and collaboration skills to work effectively with crossfunctional teams. Ability to lead, inspire, and influence team members to achieve common goals.

• Technical Proficiency: Familiarity with various digital marketing tools, software, and platforms, including advertising platforms, marketing automation software, and CMS systems.

• Effective Communication: Strong written and oral communication skills in English, with the ability to articulate ideas clearly and persuasively. You can communicate complex concepts to 

both technical and non-technical stakeholders.

• Extreme Ownership: You take full ownership of your projects, campaigns, and decisions, embracing accountability and driving results. Your proactive attitude ensures that challenges are 

met head-on.

• Strategic Thinking: You possess a strategic mindset, able to analyze the bigger picture and translate it into actionable digital marketing strategies that align with business goals.

• Innovative Mindset: Your creative thinking and willingness to explore new ideas contribute to the constant evolution of our digital marketing efforts.

Job Overview:

We are seeking experienced dynamic consulting professionals/ strategic thinkers who have worked in the corporate and social sector. As an Engagement Manager at Dhwani Rural Information Systems, you will be responsible for the successful implementation of large-scale programs and will be tasked with setting up and end-to-end management of program PMU from Dhwani’s side. You will work closely with the program owners to ensure that all stakeholders are aligned, and updates are communicated effectively. You will act as a point of contact between the program owners and the internal tech team at Dhwani and be accountable for ensuring the overall delivery of scope and SLAs. Key

Responsibilities:

• Manage and support the implementation and delivery of large-scale and technology-supported multi-stakeholder programs.

• Maintain strong relationships with key clients and stakeholders to ensure customer satisfaction and retention.

• Ensure project objectives align with the client's business goals and objectives.

• Oversee project budget, resources, and timeline to ensure on-time and on-budget delivery.

• Conduct regular project status reviews, and mitigate project risks and issues.

• Facilitate cross-functional collaboration and communication for seamless project execution.

• Develop and implement performance metrics to measure project outcomes and impact.

• Foster a continuous improvement mindset and culture, promoting best practices and innovation in project delivery.

• Report project progress, status, and results to stakeholders and senior management.

• Identify opportunities for improvement in project delivery processes and methodologies and collaborate with internal teams.

• Represent the organization in industry events and forums to build the brand and establish thought leadership.

• Manage business requirement discussions with program owners and report on projects.

• Ensure overall delivery of scope and SLAs and provide monthly updates to program owners.

• Facilitate monthly meetings with program owners and project managers on updates, highlights, challenges, and future plans.

• Own discussions with program owners on tool integration, new features, best practices for data storage, and quality checks. (For Example, mGrant, Power BI, OneDrive, etc)

Essential Technical Requirements:

• Strong research skills (qualitative and quantitative, impact assessments, report writing, log frame design)

• Experience with BI tools like Power BI

• Experience in project management tools and techniques, including project planning, resource allocation, risk management, and stakeholder communication

• Ability to work with cross-functional teams and manage external partners

Essential Non-Technical Requirements:

• Strong communication and interpersonal skills, with the ability to build and maintain relationships with program owners and team members

• Strong analytical and problem-solving skills

• Ability to think strategically and identify opportunities for process improvements

• Excellent organizational and leadership abilities

• High level of motivation and dedication to delivering high-quality work

• Commitment to continuous learning and professional development

• Ability to communicate complex ideas effectively.

• Strong client engagement skills.

• Humility, willingness to listen and learn.

Education:

• MBA or Master's degree in a relevant field such as Management, Development Studies, Economics, or Computer Science, with a minimum of 8-10 years of relevant experience in program management and technology-based projects in the social sector.

• Preference given to candidates with a degree from a reputable institution such as IRMA, APU, IIFM, XIMB, TISS, IIHMR or fellowship from YIF, Anubhav Lecture Series, India Fellow, Indian School of Public Policy, Gandhi, Teach for India, Genpact Fellowship

• Experience working with IT platforms and software solutions is a plus

Keywords:

• Project Delivery

• Engagement Management

• Customer Relationships

• Stakeholder Management

• Risk Assessment

• Resource Allocation

• Schedule Management

• Budgeting and Financial Tracking

• Process Improvement

• Status Reporting

• Communication and Collaboration

• Problem-Solving

• Cross-functional Team Management

• Time Management

• Strategic Planning

• Vendor Management

• Negotiation Skills

• Customer Satisfaction

• Performance Metrics

• Project Management Methodologies

• Data cleaning

• Report writing

• Impact assessments

• Training and training manual development

• Requirements gathering

• Multiple project management

• Fast-paced work environment

• Logical aptitude

• Ownership-taking attitude

• Action/task oriented

• Strong sense of purpose

• Written and presentation skills

We are looking for a passionate and experienced Data Analyst to join our team! As a Data Analyst at Oneistox, you will play an extremely important role as your insights and findings will be crucial for our growth and success.

Job Responsibilities

• Execution of data validation, profiling, auditing and data cleansing activities
• Collaboration with internal and external stakeholders
• Development, production and management of data quality reports
• Development of key metrics, rules and notifications to identify critical gaps
• Identify opportunities for business process improvements
• Develop and maintain KPIs Dashboards
• Support all Marketing and Sales data requests
• Standardization and automation of data collection and processing
  
  

Job Requirements

• BS in Computer Science, Mathematics or a similar field
• 2-3 years of experience as a Data Analyst or a similar role
• Experience with analytics platforms like Google Analytics, Hubspot and Amplitude is a must
• Familiarity with Javascript is preferred
• Advanced excel a must; Pivot Tables, Macros preferred
• Experience with using a range of data analysis tools
• Advanced analytics capability is a preferred skill
• Understanding of multiple regression analyses
• Experience with performing analysis in a database environment is preferred

• Minimum 4 yrs. of experience in Requirement Elicitation, Data Management and Data cleansing experience.
• Experience in analyzing data to draw business-relevant conclusions and in data visualization techniques and tools
• Ability to communicate clearly and effectively with both technology/development
• Must be proficient in MS office (Word, Excel, Visio, and PowerPoint)
• Ability to create and present executive level dashboards and status reports to Senior Leadership and cross-functional stakeholders

• Understand customers’ business needs and devise appropriate solutions using Sainapse.
• Document the requirements along with DFD and Swimlane diagrams.
• In depth analysis of the Past Data and perform Data Labeling.
• Finding out the Outliers in the data and extreme cases.
• Prepare the data for training of the Machine Learning model.

Technologies & Languages

• Azure
  • Databricks
  • SQL Sever
  • ADF
• Snowflake
  • Data Cleaning
  • ETL
• Azure Devops
• Intermediate Python/Pyspark
• Intermediate SQL
• Beginners' knowledge/willingness to learn Spotfire
• Data Ingestion
• Familiarity with CI/CD or Agile

Must have:

• Azure – VM, Data Lake, Data Bricks, Data Factory, Azure DevOps
• Python/Spark (PySpark) 
• SQL

Good to have:

• Docker
• Kubernetes
• Scala

He/she should have a good understanding in:

• How to build pipelines – ETL and Injection
• Data Warehousing
• Monitoring

Responsibilities:

Must be able to write quality code and build secure, highly available systems.

Assemble large, complex data sets that meet functional / non-functional business requirements.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc with the guidance.

Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

Monitoring performance and advising any necessary infrastructure changes.

Defining data retention policies.

Implementing the ETL process and optimal data pipeline architecture

Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.

Create design documents that describe the functionality, capacity, architecture, and process.

Develop, test, and implement data solutions based on finalized design documents.

Work with data and analytics experts to strive for greater functionality in our data systems.

Proactively identify potential production issues and recommend and implement solutions

We are looking for a Senior Data Analyst who will support our product, sales, leadership, and marketing teams with data collection and organization of data in order to draw conclusions, make predictions, and drive informed decision making.

• The ideal candidate is adept at using large data sets to find opportunities for product and marketing optimization and using data models to test the effectiveness of different courses of action.
• Not just that, you also understand how to clean and organize data for complete analysis and calculations using spreadsheets, SQL Python, and R programming.
• Visualizing and presenting data findings in dashboards, presentations and commonly used visualization platforms must be your strength.

SKILLS YOU MUST HAVE:

• Data Cleansing, Data Analysis, Data Visualization (DataViz), SQL Questioning, Decision-Making, Problem Solving, Data Collection, Data Ethics, Sample Size Determination, Spreadsheet,

RESPONSIBILITIES:

• Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
• Mine and analyze data from company databases (GOOGLE ANALYTICS, User DB, and 3rd party Marketing Analytics tools) to drive optimization and improvement of product development, marketing techniques, and business strategies.
• Assess the effectiveness and accuracy of new data sources and data gathering techniques.
• Strong understanding of Google Analytics (GA) fundamentals and how to work with raw GA data
• Automate custom data fetching from Google Analytics dashboard to excel sheet and other primary and secondary sources
• Work with complex SQL queries
• Work with Big Query with GA integration to extract data
• Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.
• Filter Data by reviewing reports and performance indicators to identify and correct code problems
• Developing and maintaining databases, data systems reorganizing data in a readable format
• Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets could be helpful for the diagnosis and prediction
• Assign a numerical value to essential business functions so that business performance can be assessed and compared over periods of time.
• Use predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
• Develop company A/B testing framework and test model quality.
• Coordinate with different functional teams to implement models and monitor outcomes.
• Develop processes and tools to monitor and analyze model performance and data accuracy.
• Understanding of statistical concepts like Statistical significance, t-test, and z-test for AB testing
• Performing analysis to assess quality and meaning of data
• Preparing reports for the management stating trends, patterns, and predictions using relevant data
• Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
• Robust understanding of Mix panel and Amplitude

Skill requirement:

• 6-8 years of experience in database management and a strong understanding of Google Analytics
• Strong mathematical skills to help collect, measure, organize, and analyze data
• Experience using statistical computer languages (R, Python, MATLAB, SQL, etc.) to manipulate data and draw insights from large data sets.
• Experience analyzing data from 3rd party providers: Google Analytics, Site Catalyst, Coremetrics, Adwords, Crimson Hexagon, Facebook Insights, etc.
• Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
• Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks.
• Knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests, and proper usage, etc.) and experience with applications.
• Knowledge of data visualization software like Tableau
• Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions
• Accuracy and attention to detail
• Adept at queries, advanced excel management, writing reports, and making presentations
• Team-working skills
• Verbal and Written communication skills
• Proven working experience in data analysis

• Partnering with internal business owners (product, marketing, edit, etc.) to understand needs and develop custom analysis to optimize for user engagement and retention
• Good understanding of the underlying business and workings of cross functional teams for successful execution
• Design and develop analyses based on business requirement needs and challenges.
• Leveraging statistical analysis on consumer research and data mining projects, including segmentation, clustering, factor analysis, multivariate regression, predictive modeling, etc.
• Providing statistical analysis on custom research projects and consult on A/B testing and other statistical analysis as needed. Other reports and custom analysis as required.
• Identify and use appropriate investigative and analytical technologies to interpret and verify results.
• Apply and learn a wide variety of tools and languages to achieve results
• Use best practices to develop statistical and/ or machine learning techniques to build models that address business needs.

• 2 - 4 years  of relevant experience in Data science.
• Preferred education: Bachelor's degree in a technical field or equivalent experience.
• Experience in advanced analytics, model building, statistical modeling, optimization, and machine learning algorithms.
• Machine Learning Algorithms: Crystal clear understanding, coding, implementation, error analysis, model tuning knowledge on Linear Regression, Logistic Regression, SVM, shallow Neural Networks, clustering, Decision Trees, Random forest, XGBoost, Recommender Systems, ARIMA and Anomaly Detection. Feature selection, hyper parameters tuning, model selection and error analysis, boosting and ensemble methods.
• Strong with programming languages like Python and data processing using SQL or equivalent and ability to experiment with newer open source tools.
• Experience in normalizing data to ensure it is homogeneous and consistently formatted to enable sorting, query and analysis.
• Experience designing, developing, implementing and maintaining a database and programs to manage data analysis efforts.
• Experience with big data and cloud computing viz. Spark, Hadoop (MapReduce, PIG, HIVE).
• Experience in risk and credit score domains preferred.