Digital Specialist w/ McKinsey & Co, Inc. US (NY, NY). Conduct business analysis and collect business requirements to translate them into digital solution leveraging best practices. Build physical data models to link data schema, modeling choices, and business considerations. Design and implement data Extraction, Transformation, and Loading (ETL) pipeline leveraging modern data engineering architecture patterns.Implement robust and scalable big data engineering and analytics solutions using distributed programming and big data technologies like Hadoop, MapReduce and Spark. Apply statistical and machine learning methodologies to identify trends, patterns, anomalies and commonalities from various data sources. Develop and deliver automated reports and advanced visualization solutions using various business intelligence tools like Tableau and PowerBI. Architect, develop, and deploy end-to-end data solutions on clients’ cloud platform, leveraging cloud services provided by Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform (GCP) etc. Define digital solution architecture and manage prioritization of features working with Agile development teams. Telecommuting permitted.Minimum of a Master’s degree in Industrial Technology and Operations, Computer Science, or related field, or foreign degree equivalent. Minimum two (2) years of experience developing data analytics solutions. Experience must include the following: Cloud platforms: AWS, Google, or Microsoft Azure; Big data platforms and tools: Hadoop, Spark, and Hive; Database programming skills: MySQL, PostgreSQL, Microsoft SQL Server, NoSQL, Cassandra, MongoDB; object oriented programming languages: Python or VBA; statistical analysis and visualization tools: Pandas, Seaborn, Dash, Tableau, PowerBI, Looker.Salary: $192,000 - $208,000/yrWorksite location: McKinsey & Company, Inc. United States, 3 World Trade Center, 175 Greenwich St., New York, NY 10007Email your resume to [email protected] and refer to Job #7124468

　　Minimum Salary: 192,000Maximum Salary: 208,000Salary Unit: Yearly