All offers

SSIS / SQL Server Expert - M/F

Twyce is a consulting firm specializing in Digital Transformation, but above all it's an incredible human adventure, with a community of over 40 collaborators based mainly in Paris, but also more recently in Montreal.

Founded in 2021 around the principles of transparency, collective intelligence and co-construction, Twyce emphasizes a strong commitment to its customers and partner consultants.

In order to support its customers at every stage of their projects, Twyce has 3 key areas of expertise:

Data & Cloud

Dev Factory

Product & Project

 

Your mission:

➢ Understand business challenges, problems to be solved and opportunities to be realized.

➢ Discuss and challenge business needs with AMOA BI teams, taking technical constraints into account.

➢ Propose, design and specify viable, scalable technical solutions that take existing systems into account.

➢ Drafting of technical documents (technical specifications, operating documents, etc.).

➢ Advise, suggest areas for improvement, alert if necessary.

➢ Ensure RUN of existing applications (ETL, databases, level 3 support)

 

 

➢ Technical skills

▪ BI design/modeling (data flows & models)

▪ Significant experience on the complete implementation of BI Data ETL projects (design, modeling, realization) and on RUN in a Full Microsoft environment (SSIS, SQL Server: Modeling, stored procedures, SQL optimization, etc.).

▪ Knowledge and implementation of the Microsoft AZURE DEVOPS suite (Git, Agile Board, CI/CD deployment pipeline).

▪ Professional English.

 

➢ Organizational skills

▪ Significant experience in implementing BI data integration projects (datawarehouse & datamarts)

▪ Have the ability to carry out mini-projects independently, while being supported by a project manager and/or the business.

▪ Ability to organize, adapt to priorities, summarize the progress of activities and raise alerts if necessary.

➢ Profile

▪ Good interpersonal skills, good communication skills, good oral and written expression, appetite for collaborative work and functional issues.

▪ Be a driving force

▪ Methodology, organization, rigor

▪ Capacity for synthesis and analysis

▪ Ability to work as part of a team, to adapt to different people, sense of service, ability to listen, humility and open-mindedness.

▪ Appreciated skill(s):

➢ BI reporting technologies: TABLEAU, IBM Cognos

➢ Working with an offshore partner

➢ MSBI suite certifications

 

▪ Detailed description of the mission :

➢ Understand business challenges, problems to be solved and opportunities to be realized.

➢ Discuss and challenge business needs with AMOA BI teams, taking technical constraints into account.

➢ Propose, design and specify viable, scalable technical solutions that take existing systems into account.

➢ Drafting of technical documents (technical specifications, operating documents, etc.).

➢ Advise, suggest areas for improvement, alert if necessary.

➢ Ensure RUN of existing applications (ETL, databases, level 3 support)

 

 

▪ Technical environment of the mission :

➢ Data foundation: SSIS, SQLServer (2016), stored procedures, Azure DevOps (Git, Agile Board, CI/CD deployment pipeline)

➢ Reporting: COGNOS BI 10.2 and 11 & Tableau

Key information
Paris
Freelance
MRT: €650
Apply at