Data Integration Scientist Senior Specialist


  • Company:
    Bain & Company Inc
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    2 weeks ago
  • Category:
    IT & Software

This is an opportunity to be a key member of Bain’s expanding data science capability area. This position will be part of the Advanced Analytics Group (Bain’s team of data science, engineering, marketing science, operations research and primary research experts) Responsibilities will include Supporting regional Data Scientists in extending and innovating our big data and analytic capabilitiesWorking with Bain consultants and Advanced Analytics experts to define data requirements, plan data acquisition, and develop target data schemasWorking with consultants and clients to extract large and complex data sets from client and third party sources (structured and unstructured) and then transfer & load the data onto Bain data servers into target data schemasFacilitating data merging and transformation in preparation for analysis by planning the process and either executing directly or training consultants to implement directlyAssist Advanced Analytics experts with data validations and analysis of large and complex datasets The person in this role will need the ability toCommunicate effectively with analytics/data experts, business leaders, and executives inside and outside of Bain to assess opportunities and develop data driven solutions for Bain clients across a variety of sectorsTranslate business objectives into data and analytics solutions using appropriate data engineering, analytics, visualization & dashboard applicationsDesign, execute and direct data engineering and analytics solutionsCommunicate with and educate both senior and junior colleagues to further embed data science and analytics across the firmThis position can be located in any of the following offices: Amsterdam, Berlin, Brussels, Dubai, Johannesburg, London, Frankfurt, Hamburg, Stockholm, Copenhagen, Oslo, Helsinki, Warsaw, Istanbul, Madrid, Milan, Rome or MunichDevelop and/or implement tools for data acquisition, extraction, transformation, management, and manipulation of large and complex data setsExplore, model, mine, and experiment with data to answer critical business issuesSupport and train consulting teams in use of data and visualization tools to generate and communicate insightsTrain relevant Advanced Analytics Group team members to support data integration initiativesProvide training, documentation and other assistance to Bain’s consulting staff to support and expand the use of data integration and advanced analytics Keep abreast of new and current data science techniquesBachelor’s degree or higher in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics or information sciences such as business analytics or informatics5+ years experience in data acquisition, integration, transformation, and cleaning of both structured and unstructured data; 3+ with a related graduate degreeStrong SQL expertise and strong data modeling (logical and physical data models) experienceStrong experience with ETL/ELT design and implementations in the context of large and complex datasets, especially in the context of Data Science pipeline developmentExperience with ETL tools (e.g., Talend, Informatica, DataStage, SSIS, Redpoint)Demonstrated experience with a variety of relational database and data warehousing technology (e.g. Oracle, SAP BW, DB2, Teradata, MS SQL Server, Vertica, Greenplum, SAP HANA, MySQL, PostgreSQL, AWS Redshift)Experience with Python, Java, and VBA a plusFamiliarity with Business Intelligence tools a plus (e.g. Cognos, Qlikview, Tableau, Tibco, MicroStrategy)Experience with Hadoop and Spark ecosystem (e.g., HBase, Pig, Hive) a plusExperience with NoSQL database technologies (e.g., MongoDB, Cassandra, CouchDB) a plusExperience with cloud computing Experience with statistical analysis software (e.g. R, SPSS, SAS, RapidMiner) a plusExcellent oral and written communication skills a mustExcellent business English and local languageAbility to collaborate with people at all levels and with multi-office/region teamsMust thrive in a fast paced environment and be able to work independently Travel required