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.

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.
• Solid experience in conceptual, logical, dimensional, and physical data modeling.
• Proven experience designing and developing solutions with Microsoft Power BI.
• Strong knowledge of DAX, Power Query, and semantic model design.
• Experience interacting directly with business stakeholders and senior management.
• Strong analytical mindset and problem-solving capabilities.
• Excellent communication and presentation skills.
• Fluent English and Italian.

NICE TO HAVE

• Python for data analysis, automation, and data processing.
• Microsoft Fabric.
• Azure Data Platform.
• Data Warehouse architectures.
• ETL / ELT frameworks and tools.
• Cloud analytics environments.
• Banking or Financial Services experience.
• Knowledge of Data Governance, Data Quality, and Regulatory Reporting frameworks.

WHAT WE OFFER

• Opportunity to work on strategic and highly visible projects for major Swiss and international clients.
• Exposure to complex Data & Analytics transformation programs.
• Meritocratic environment with clear career progression opportunities.
• Continuous investment in professional development and certifications.
• Dynamic, international, and collaborative working environment.
• Participation in the growth of FORFIRM's Data & Analytics practice.