Principal Data Operations Analyst at NielsenIQ

Shanghai, Shanghai, China -

Full Time

Start Date

Immediate

Expiry Date

12 Jan, 26

Salary

0.0

Posted On

14 Oct, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Governance, Data Cleansing, Data Standardization, Data Quality Control, Process Optimization, Cross-Team Collaboration, Geocoding, Spatialization, Python, Pandas, NumPy, Database Tools, GIS, GeoPandas, Map APIs, Address Models

Industry

Software Development

Description

Company Description ABOUT NIELSENIQ NielsenIQ is a global measurement and data analytics company that provides the most complete and trusted view available of consumers and markets worldwide. We provide consumer packaged goods manufacturers/fast-moving consumer goods and retailers with accurate, actionable information and insights and a complete picture of the complex and changing marketplace that companies need to innovate and grow. Our approach marries proprietary NielsenIQ data with other data sources to help clients around the world understand what’s happening now, what’s happening next, and how to best act on this knowledge. We like to be in the middle of the action. That’s why you can find us at work in over 90 countries, covering more than 90% of the world’s population. For more information, visit www.niq.com. NielsenIQ is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer, making decisions without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, protected veteran status or any other protected class. Job Description We are seeking a meticulous and detail-oriented professional with a background for data governance specialist. You will serve as the quality goalkeeper of our data assets, responsible for cleansing, standardizing, spatializing, and auditing our data. Your work will be a solid foundation for retail measurement products delivery, client data-oriented decision-making. The scope of data and duties might includes： 1. FMCG product information cleaning and standardization This mainly includes enhancing the weighting of words which’s used in original product descriptions, with the goal of improving the match accuracy between raw product and NIQ standardized product description. 2. Raw data quality control Using standard methods for the different source data cleaning and validation, including checks for abnormals/outliers in sales figures, irregularities in data formatting, and potential omissions to addressing various levels of data quality issues. 3. Process Optimization and Cross-Team Collaboration Design and optimize automated pipelines for store data processing to improve output efficiency. Collaborate closely with business teams and data collection units to identify and resolve data quality issues, and drive upstream improvements. 4. store information Cleansing & Processing Handle large-scale, multi-source offline store census data (e.g., Excel, CSV, form-based inputs), performing data cleansing tasks such as deduplication, error fixing, missing value imputation, and anomaly handling. Standardize non-uniform store information (e.g., name, address, business type, operating status), and develop and enforce unified data standards and protocols. 5. Geocoding & Spatialization* Use AMap (Gaode) Web Service APIs, especially geocoding and reverse geocoding interfaces, to batch-convert textual address data into high-precision geographic coordinates. Resolve coordinate system discrepancies (e.g., WGS-84, GCJ-02, BD-09) to ensure all spatial data aligns under a consistent geospatial reference. 6. Spatial Data Management & Quality Assessment* Apply advanced spatial data processing using GeoPandas, including Spatial Join operations to enrich store points with administrative boundaries, commercial zones, competitor locations, and other layers. Establish automated data quality rules and validation workflows using spatial and attribute analysis to ensure accuracy, completeness, and logical positioning of store data. Maintain and manage databases to ensure traceability and integrity of store information. Qualifications Required Qualifications 1. Education & Background · Bachelor’s degree or above in Information system, Computer Science, Data Science, or related disciplines. 2. Core Technical Skills and knowledge · Proficient in Python data processing: strong command of Pandas, NumPy, Re, and other libraries for large-scale structured data manipulation. · Proficient in database tools (e.g., Oracle, MySQL) for data inspection and basic operations. · Strong experience for handling different source data. · Know traditional retail, business concepts (e.g., shoptype, banner, brand), meanwhile emerging channel. · High sensitivity to data quality, with a rigorous and responsible work ethic. 3. additional GIS Skill can have which is preferred · Skilled in spatial data handling: hands-on experience with GeoPandas and Shapely, including solving real-world problems using Spatial Join and other spatial operations. · Experience with map APIs: practical experience using AMap, Baidu Maps, or similar services for batch geocoding/reverse geocoding via API. · Domain expertise. Deep understanding of address models and Chinese address parsing/standardization. Familiarity with common spatial reference systems and coordinate transformations. Additional Information /LP Our Benefits Flexible working environment Volunteer time off LinkedIn Learning Employee-Assistance-Program (EAP) About NIQ NIQ is the world’s leading consumer intelligence company, delivering the most complete understanding of consumer buying behavior and revealing new pathways to growth. In 2023, NIQ combined with GfK, bringing together the two industry leaders with unparalleled global reach. With a holistic retail read and the most comprehensive consumer insights—delivered with advanced analytics through state-of-the-art platforms—NIQ delivers the Full View™. NIQ is an Advent International portfolio company with operations in 100+ markets, covering more than 90% of the world’s population. For more information, visit NIQ.com Want to keep up with our latest updates? Follow us on: LinkedIn | Instagram | Twitter | Facebook Our commitment to Diversity, Equity, and Inclusion At NIQ, we are steadfast in our commitment to fostering an inclusive workplace that mirrors the rich diversity of the communities and markets we serve. We believe that embracing a wide range of perspectives drives innovation and excellence. All employment decisions at NIQ are made without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, marital status, veteran status, or any other characteristic protected by applicable laws. We invite individuals who share our dedication to inclusivity and equity to join us in making a meaningful impact. To learn more about our ongoing efforts in diversity and inclusion, please visit the https://nielseniq.com/global/en/news-center/diversity-inclusion

Responsibilities

The Principal Data Operations Analyst will be responsible for cleansing, standardizing, spatializing, and auditing data assets. This role involves ensuring data quality for retail measurement products and supporting client data-oriented decision-making.