You will work with an agile team to shape and build out a new defense analytics hub to scale across our defense and security clients on some of their toughest issues, in a fast-paced and non-hierarchical environment.
What You'll Do
Our data delivery analysts work to provide data engineering expertise in client service. You will be responsible for coding and testing assets to deliver analytics to our customers.
You will spend ~60% of your time deploying high quality analytics solutions across our defense customers. You will also perform the transformation, filtering and aggregation of raw data into concise, accurate and focused data marts or client specific data models.
You may also be responsible for data-intensive ad hoc analytics, including novel analytics for which tools are not sufficiently push button. In addition, you will collaborate with the product and delivery team in defining the requirements of analytics products, within an agile framework. You will be an integral part of our team with opportunities for coaching and mentorship from your senior colleagues.
In order to be successful, you will be an active learner, identifying and evaluating new tools and technologies to meet requirements. It is expected that your voice and opinion be heard and expressed. We have an environment that thrives on the creation of better solutions by utilizing the variety of our people's experiences and skillsets.
The role requires US citizenship and the ability to obtain a certain level of security clearance mandated by relevant U.S government branch and or agency.
Who You'll Work With
You will join our office in either Atlanta, Dallas, Waltham, or Washington DC as part of our new Defense Analytics Product team.
You will work with our data delivery team alongside data scientists, tool developers, consultants and clients on projects that use complex data and advanced modeling to solve client problems and deliver significant measurable impact.
As the solution is developed and brought to new clients, you will have exposure to the client leadership team serving defense and national security clients, senior McKinsey leaders and consultants.
In addition to the Defense Analytics Product team, you will work with our broader ecosystem of data and analytics experts within the Social, Healthcare and Public Entities (SHaPE) practice. This team has grown to 300+ colleagues globally over the last four years. It is a unique mix of public sector and healthcare experts, statisticians, engineers, data scientists and more.
We are redefining what it means for clients to work with McKinsey by driving innovation through advanced analytics, user experience design thinking, and new product development.
Qualifications

• Bachelor's degree in engineering, computer science or an equivalent area; advanced degree is a plus
• 2+ years of experience in ETL and data-intensive applications development using Python, Hadoop, Spark and Hive
• Strong experience in SQL, query optimization and data transformation functions
• Experience with visualization tools (e.g., Tableau or Power BI)
• Knowledge of DevOps practices is preferred
• Ability to translate business requirements and time management skills (managing estimated workload according to scope)
• Demonstrated willingness and ability to engage with teams to collectively solve complex problems
• Social, healthcare and public entities domain knowledge is not required, but interest in these areas is appreciated
• U.S. citizenship is required