Senior Data Engineer - Jobs Opendatascience

WHO YOU’LL WORK WITH

You will join our Waltham or Atlanta office and be a part of our One Firm Tech-Cloud Data & Analytics team. You will work with product managers, software engineers, architects and various platform teams. You’ll be part of a team responsible for delivering technology enabled solutions of the future. You will be involved in all business value chain activities from understanding product needs to product development to on-going maintenance and enhancement.

Our vision & mission of the Cloud Data and Analytics (CDA) group is to give our Firm colleagues the ability to generate valuable insights through a scalable, highly responsive and value driven data and analytics framework. We will achieve that by moving all our data and processes into Cloud. The CDA team has several complementary teams working on various facets of delivering Cloud services.

WHAT YOU’LL DO

You will be responsible for creating innovative interoperability platforms, tools and solutions to enable seamless and secure data integration.

In this role, your solutions will be used to connect legacy, newly developed, and vendor applications across the datacenter and cloud environments, and you will be responsible for the full lifecycle of the solutions.

You will be developing specifications, designing infrastructure and interfaces, developing code. As Engineers & Senior Engineers you will be 80% hands on coding and Senior Engineers will also Coach & Mentor. You will build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies. You will assemble large, complex data sets that meet business requirements, identify, design and implement internal process improvements, automate manual processes, optimize data delivery, and propose re-designing of infrastructure as appropriate to achieve scalability and cost reduction.

QUALIFICATIONS

Bachelor’s/Masters degree in technology area of study
5+ years of experience programming in a backend language (Java, J2EE, Kafka, Spark, etc.)
3+ years of experience as a Data Engineer or similar role
2+ years of experience with Data Analytics and Reporting
Advanced working SQL and No-SQL knowledge and experience working with a variety of databases (MySQL, NoSQL, Hadoop, MongoDB, etc.)
Experience in building pipelines to migrate data from on-prem to cloud data repositories (e.g., Snowflake, Redshift, Synapse, Databricks)
Experience in ingesting data into cloud repositories from sources including flat files, SQL server, Kafka, CDC and Web APIs
Experience with development work to support data migration, cloud applications, Spark, or the Hadoop ecosystem and similar frameworks
Familiarity with various cloud technologies such as AWS (EMR, RDS, Redshift, etc.) and Azure
Proficient in building large scale systems end to end using Java/Python/GoLang or other high-performance languages, developer tools, CI/CD, DevOps, monitoring tools and engineering cloud migration solutions
Experience in working with modern IDE’s (such as Visual Studio Code, Intellij)

COVID-19 vaccination mandate:

Employment with McKinsey & Company, Inc. in the United States and Canada is conditioned on proof of full vaccination against the COVID-19 virus (with a WHO-approved or Health Canada-approved COVID-19 vaccine, as applicable) or approval of an exemption due to a qualifying medical condition or sincerely held religious belief prior to start date.

More Information

Salary Offer 0 ~ $3000
Experience Level Junior
Total Years Experience 0-5
Dropdown field Option 1