Sogeti is a leading provider of professional technology services, specializing in Application Management, Infrastructure Management and High-Tech Engineering. Sogeti offers cutting-edge solutions around Testing, Business Intelligence, Mobility, Cloud and Security, combining world class methodologies and the global delivery model, Rightshore®. Sogeti brings together more than 20,000 professionals in 15 countries and is present in over 100 locations in Europe, the US and India. Sogeti is a wholly-owned subsidiary of Cap Gemini S.A., listed on the Paris Stock Exchange. At Sogeti USA, we are committed to building a long and enduring relationship with our employees and to creating an environment that rewards and empowers. Our mission is to constantly exceed our employees' expectations in the same way that we strive to exceed our clients' expectations. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be an employer of choice! **What You-ll Do** + Prepare Impact Analysis document based on Businessrequirement document to identify gaps to help in timeline estimation. + Design and Develop ETL framework using SSIS, Azure DataFactory, Sangam. + Design and Develop Data Storage and Processing layersusing Azure Data Lake Store, Azure Data Warehouse, Azure Databricks,COSMOS, T-SQL. + Design and Develop Data Presentation layer usingMulti-Dimensional, Tabular Model (SSAS). + Design and Develop Data Visualization dashboards usingSSRS, Power BI. + Design, Develop and Automate Unit, Integration testingscripts using SCOPE, T-SQL, U-SQL, Spark-SQL etc. + Enable code maintenance and deployment through GIT. + Update sprint work items progress in Visual StudioOnline (VSO) for visibility. **Minimum education qualification** - SQL Server 2014/16, Good SQL &ETL skills - Strong on SSAS, SSIS &COSMOS - Good knowledge of PowerBI - Strong data analytical skills - Strong knowledge on Excel - Pivots, PowerPivots, Charts - Bachelor's Degree in Computer Science, Computer Engineering, MIS or related field. **The ideal candidate will have:** - Understanding Data Management &BI concepts, Data Analysis, Cubes, Reporting Technologies, ETL - Ability to make business conclusions from data, connect scenarios - Ability to deal with ambiguity and work in agile environment. - Excellent communications skills - Attention to detail - Strong troubleshooting skills - Hands on experience with SharePoint - Prior experience in Microsoft landscape is preferred **The benefits our employees enjoy:** + 401(k) Savings Plan- Matched 150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in the US!) + Medical/Prescription/Dental/Vision Coverage! + Low-premium and deductible. Plan with free preventive care. + $12,000 in Tuition Reimbursement + 100% Company-paid mobile phone plan + Personal Time Off (PTO)- Ensuring a balance of work and home life Sogeti is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.