About the job Senior Data Engineer (Backend)
About TSG:
Technology Staffing Group SA is a Swiss IT consulting group based in Geneva. With our expertise in IT talent recruitment and the co-management of complex projects, we collaborate with a diverse range of clients, from promising start-ups to major Fortune 500 companies across Europe. Our 100+ employees, spread across the continent, are the driving force that accelerates and transforms the organizations we work with.
Job Summary:
We are seeking a highly skilled Senior Data Engineer with expertise in SQL, database management, ETL processes, and Power BI to support our data-driven decision-making processes. The ideal candidate will have strong technical skills in database development, data modeling, and business intelligence, along with experience in cloud technologies and security best practices.
Key Responsibilities:
Database Management & SQL Expertise
- Develop, optimize, and maintain SQL queries, stored procedures, and performance tuning (T-SQL, PL/SQL).
- Manage and administer relational database management systems (RDBMS), including:
Mandatory: SQL Server (SSMS, SSIS, SSRS).
Nice to have: PostgreSQL, MySQL, MariaDB, Azure SQL Database, AWS RDS.
- Implement database normalization, indexing, partitioning, and performance optimization techniques.
Data Modeling & ETL Development
- Design and manage data models to support Power BI reporting.
- Develop star schema and snowflake schema for efficient data warehousing.
- Build ETL (Extract, Transform, Load) pipelines using:
Preferred: SQL Server Integration Services (SSIS), Azure Data Factory. Python (Pandas, NumPy) for data manipulation.
- Work with DAX (Data Analysis Expressions) and Power Query (M language) for data transformations.
Power BI & Business Intelligence (Mandatory)
- Develop interactive dashboards, KPIs, and data visualizations using Power BI Desktop & Power BI Service.
- Build Power BI Paginated Reports and work with Power BI Report Server.
- Implement Row-Level Security (RLS) for data access control.
- Nice to have: Knowledge of Power Automate for workflow automation.
Cloud & DevOps Integration
- Work with Azure Data Services, including: Azure Synapse Analytics, Azure Data Lake, Azure SQL.
- Manage Power BI deployment pipelines.
- Implement CI/CD pipelines for data models and APIs.
Security & Compliance
- Implement data security best practices, including encryption and GDPR compliance.
- Manage Role-Based Access Control (RBAC) for Power BI and SQL databases.
Soft Skills & Other Requirements:
- Strong analytical and problem-solving skills.
- Ability to communicate insights from data to non-technical stakeholders.
- Experience working in Agile and DevOps environments.
- Ability to collaborate with frontend developers, data analysts, and business teams.
- Nice to have: Experience in healthtech, wellness, or clinic management systems.
Qualifications & Experience:
- Bachelors/Masters degree in Computer Science, Data Science, Information Technology, or a related field.
- 5+ years of experience in SQL development, data engineering, or business intelligence.
- Proficiency in Power BI and data visualization best practices.
- Experience with cloud platforms (Azure, AWS) is a plus.
Why Join Us?
- Opportunity to work on cutting-edge data projects.
- Collaborative and innovative work environment.
- Competitive salary and benefits.
Your Personal Data:
By submitting your application, you agree that the provided information will be stored and used by TSG to contact you and share with our clients as part of the recruitment process.