Consultant Software Engineer - MSBI

Job description

Vos missions au quotidien Minimum 10+ Years of Rich Experience on Design, develop, and maintain **end-to-end MSBI solutions using SQL Server using TSQL, SSIS, SSAS.** Define and implement end-to-end BI architecture using MSBI stack (SSIS, SSRS, SSAS, SQL Server) Design robust data warehouse solutions (star/snowflake schema, data marts, OLAP models) Contribute on application enhancements, conduct POCs on various improvement initiatives and ensure their implementation, and handle DevOps and infrastructure-related aspects for the applications. They will also collaborate with multiple stakeholders and drive engagement within the AFP BI community Establish ETL frameworks and data integration strategies Create scalable and performant data models and semantic layers Ensure adherence to data governance, security, and compliance standards Oversee development of ETL pipelines (SSIS) and reporting solutions (SSRS, Power BI) Design and maintain SSAS cubes (Tabular/Multidimensional) Ensure performance optimization across queries, ETL, and reporting layers Provide solutions for data quality, lineage, and metadata management Act as a technical leader and mentor for BI teams Collaborate with business stakeholders, architects, and engineering teams Translate complex business requirements into scalable BI solutions Conduct design reviews, code reviews, and best practices enforcement Et si c’était vous ? Minimum 10+ Years of Rich Experience on Design, develop, and maintain **end-to-end MSBI solutions using SQL Server using TSQL, SSIS, SSAS.** Define and implement end-to-end BI architecture using MSBI stack (SSIS, SSRS, SSAS, SQL Server) Design robust data warehouse solutions (star/snowflake schema, data marts, OLAP models) Contribute on application enhancements, conduct POCs on various improvement initiatives and ensure their implementation, and handle DevOps and infrastructure-related aspects for the applications. They will also collaborate with multiple stakeholders and drive engagement within the AFP BI community Establish ETL frameworks and data integration strategies Create scalable and performant data models and semantic layers Ensure adherence to data governance, security, and compliance standards Oversee development of ETL pipelines (SSIS) and reporting solutions (SSRS, Power BI) Design and maintain SSAS cubes (Tabular/Multidimensional) Ensure performance optimization across queries, ETL, and reporting layers Provide solutions for data quality, lineage, and metadata management Act as a technical leader and mentor for BI teams Collaborate with business stakeholders, architects, and engineering teams Translate complex business requirements into scalable BI solutions Conduct design reviews, code reviews, and best practices enforcement Plus qu’un poste, un tremplin “We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status”. Pourquoi nous choisir ? Business Insight At Société Générale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious. Whether you’re joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating and taking action are part of our DNA. If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us! Still hesitating? You should know that our employees can dedicate several days per year to solidarity actions during their working hours, including sponsoring people struggling with their orientation or professional integration, participating in the financial education of young apprentices and sharing their skills with charities. There are many ways to get involved. Diversité et inclusion Nous sommes un **employeur garantissant l'égalité des chances** et nous sommes fiers de faire de la diversité une force pour notre entreprise. Le groupe s’engage à reconnaître et à **promouvoir tous les talents** , quels que soient leurs croyances, âge, handicap, parentalité, origine ethnique, nationalité, identité de genre, orientation sexuelle, appartenance à une organisation politique, religieuse, syndicale ou à une minorité, ou toute autre caractéristique qui pourrait faire l’objet d’une discrimination. Partager