Senior Data Analytics Specialist

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.

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.

• 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 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.

• 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.

• 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.

• 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.

• 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.
• Solid experience in conceptual, logical, dimensional, and physical data modeling.
• Proven experience designing and developing…