Senior Data Analytics Specialist

Forfirm; Ticino; Hybrid; CHF 120,000 - 165,000; Full time

Job summary

FORFIRM in Switzerland seeks a Senior Data Analytics Consultant to lead data-driven transformation for Swiss and European clients. You will work with stakeholders, design analytics solutions, and shape modern data architectures.

You will own SQL development, data modelling, Power BI dashboards, and mentor junior consultants, contributing to pre-sales and delivery in a dynamic international team.

Qualifications

• Bachelor's or Master's degree in CS/Engineering/Math/Stats/Data Science or related field.
• At least 5 years of professional experience in Data Analytics, BI, Data Warehousing, or related fields.
• Strong expertise in SQL development and relational databases.

Responsibilities

• Engage with business stakeholders to understand strategic objectives and analytical requirements.
• Translate business needs into scalable data and reporting solutions.
• Lead workshops, requirement-gathering sessions, and analytical assessments.
• Support clients in defining KPI frameworks and performance measurement models.
• Act as a trusted advisor for data-driven decision-making initiatives.
• Design and maintain data models (conceptual/logical/physical).
• Define dimensional models (Star/Snowflake) for reporting needs.
• Collaborate with Data Engineers and Architects on analytics architectures.
• Support data governance, MDM, and data quality initiatives.
• Ensure consistency, integrity, and sustainability of analytical data platforms.
• Develop and optimize complex SQL queries and data analysis.
• Perform data profiling and root cause investigations.
• Analyze large datasets to identify trends and opportunities.
• Support data migration and transformation initiatives.
• Design and develop dashboards/reports using Power BI.
• Develop advanced DAX calculations, KPIs, and semantic models.
• Implement reporting best practices and governance standards.
• Support executive reporting and management dashboards.
• Ensure performance optimization and scalability of reporting solutions.
• Act as senior reference in client engagements.
• Coach and mentor junior consultants and analysts.
• Define scope, timelines, and deliverables with project managers.
• Contribute to proposals and business development.

Skills

SQL development

Data analytics

Power BI

Stakeholder management

Data modeling

Education

Bachelor's or Master's Degree in Computer Science, Engineering, Mathematics, Statistics, Economics, Data Science, or related discipline

Tools

Power BI

DAX

Job description

ABOUT FORFIRM

FORFIRM is providing solutions to real business challenges for our clients through innovation and deep industry understanding.

We pride ourselves on being a knowledge-based company, with no barriers or pre-built solutions. We listen to our clients and solve their unique problems.

At FORFIRM, we are creating a culture where each person can define their own role parameters and speak their mind without hesitation. We are a true meritocracy, where individual results define each person's career path.

We are looking for an experienced and highly motivated Senior Data Analytics Consultant to join our international team and contribute to strategic data and reporting initiatives for leading Swiss and European organizations.

ABOUT THE ROLE

The Senior Data Analytics Consultant will act as a trusted advisor for clients and internal stakeholders, supporting the design and implementation of data-driven solutions that enable effective decision-making and business transformation.

The role combines consulting expertise, data modelling capabilities, advanced SQL development, and Business Intelligence competencies. The selected candidate will lead analytical initiatives, interact directly with business stakeholders and management teams, and contribute to the definition of modern data architectures and reporting frameworks.

RESPONSIBILITIES

Data Analytics & Consulting

• Engage with business stakeholders to understand strategic objectives and analytical requirements.
• Translate business needs into scalable data and reporting solutions.
• Lead workshops, requirement-gathering sessions, and analytical assessments.
• Support clients in defining KPI frameworks and performance measurement models.
• Act as a trusted advisor for data-driven decision-making initiatives.

Data Modeling & Data Architecture

• Design and maintain conceptual, logical, and physical data models.
• Define dimensional data models (Star Schema and Snowflake Schema) supporting enterprise reporting needs.
• Collaborate with Data Engineers and Architects to define scalable analytics architectures.
• Support data governance, master data management, and data quality initiatives.
• Ensure consistency, integrity, and sustainability of analytical data platforms.

SQL Development & Data Analysis

• Develop and optimize complex SQL queries and database objects.
• Perform advanced data analysis and profiling activities.
• Conduct data reconciliation and root cause investigations.
• Analyze large datasets to identify trends, anomalies, risks, and opportunities.
• Support data migration and transformation initiatives.

Power BI & Business Intelligence

• Design and develop enterprise-grade dashboards and reports using Microsoft Power BI.
• Develop advanced DAX calculations, KPIs, measures, and semantic models.
• Implement reporting best practices and governance standards.
• Support executive reporting and management dashboards.
• Ensure performance optimization and scalability of reporting solutions.

Leadership & Project Delivery

• Act as senior reference point within client engagements.
• Coach and mentor junior consultants and analysts.
• Collaborate with project managers in defining scope, timelines, and deliverables.
• Contribute to proposal preparation and business development activities.
• Support pre-sales initiatives related to Data & Analytics services.

WHAT ARE WE LOOKING FOR?

• Bachelor's or Master's Degree in Computer Science, Engineering, Mathematics, Statistics, Economics, Data Science, or a related discipline.
• At least 5 years of professional experience in Data Analytics, Business Intelligence, Data Warehousing, or related fields.
• Strong expertise in SQL development and relational databases.