Senior Expert - BI

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 whats happening now whats happening next and how to best act on this knowledge. We like to be in the middle of the action. Thats why you can find us at work in over 90 countries covering more than 90% of the worlds population. For more information visit . 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 worlds leading consumer intelligence company delivering the most complete understanding of consumer buying behavior and revealing new pathways to 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 insightsdelivered with advanced analytics through state-of-the-art platformsNIQ delivers the Full View. NIQ is an Advent International portfolio company with operations in 100 markets covering more than 90% of the worlds population.

For more information visit

Want to keep up with our latest updates

Follow us on: LinkedIn  Instagram  Twitter  Facebook

Our commitment to Diversity Equity and Inclusion

NIQ is committed to reflecting the diversity of the clients communities and markets we measure within our own workforce. We exist to count everyone and are on a mission to systematically embed inclusion and diversity into all aspects of our workforce measurement and products. We enthusiastically invite candidates who share that mission to join us. 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 global non-discrimination policy covers these protected classes in every market in which we do business worldwide. Learn more about how we are driving diversity and inclusion in everything we do by visiting the NIQ News Center:  Work :

No