Senior Expert

Job Description

Job Description

About the Role We are seeking a highly experienced Senior Data Analyst with over 10 years of expertise in data analytics, database architecture, and business intelligence. This role demands deep technical proficiency in SQL, Power BI, and SSIS, along with a strong understanding of database schema design and data warehouse architecture. You will play a key role in transforming complex data into actionable insights and scalable solutions that drive business performance.

Key Responsibilities

- Design and maintain robust database schemas to support scalable and efficient data storage and retrieval.
- Develop and optimize data warehouse solutions, including star and snowflake schema models, fact and dimension tables, and ETL pipelines.
- Build and manage Power BI dashboards and reports that deliver clear, actionable insights to stakeholders.
- Design, develop, and maintain SSIS packages for robust ETL processes across multiple data sources.
- Monitor and troubleshoot data integration workflows to ensure data quality and reliability.
- Collaborate with cross-functional teams to define data requirements and translate business needs into technical solutions.
- Lead data modeling efforts and enforce best practices in schema normalization, indexing, and partitioning.
- Automate and orchestrate data workflows using tools like SSIS and scheduled jobs to improve operational efficiency.
- Mentor junior analysts and contribute to the development of data governance and documentation standards.
- Ensure compliance with data security and privacy regulations across all data platforms.

Qualifications

Required Skills & Qualifications

- 10+ years of experience in data analytics, data engineering, or business intelligence roles.
- Expert-level proficiency in SQL, including advanced query optimization, stored procedures, and schema design. Strong hands-on experience with Power BI, including DAX, Power Query, and data modeling.
- Proficiency in SSIS for building and managing ETL pipelines.
- Deep understanding of data warehouse concepts, including OLAP vs. OLTP, ETL processes, and data lake vs. data mart vs. warehouse architectures.
- Experience designing and managing star and snowflake schemas, including implementation of surrogate keys, slowly changing dimensions (SCDs), and maintaining data lineage.
- Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

- Experience with business intelligence tools beyond Power BI.
- Familiarity with data governance frameworks and metadata management.
- Understanding of Agile methodologies and experience in sprint-based delivery environments.
- Exposure to cloud-based data platforms (e.g., Azure Synapse, Snowflake, BigQuery).
- Experience with CI/CD practices for data solutions.
- Knowledge of Python for data analysis and automation is a plus.

Additional Information

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.

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: | | |

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

---