Senior Data Analytics Specialist

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

• Bachelors or Masters 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.

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

• 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 FORFIRMs Data & Analytics practice.