PRACTICE AREA:
BCG’s Advanced Analytics group GAMMA delivers powerful analytics-based insights designed to help our clients tackle their most pressing business problems. We partner with BCG case teams and practices across the full analytics value chain: Framing new business challenges, building fact-bases, designing innovative analytics workflows, training colleagues in new methodologies and interpreting findings for our clients. The GAMMA team is a global resource, working with clients in every BCG region and in every industry area. It is a core member of a rapidly growing analytics enterprise at BCG – a constellation of teams focused on driving practical results for BCG clients by applying leading edge analytics approaches.
POSITION SUMMARY:BCG has established GAMMA to support case teams in managing and realizing insight and opportunity by application of advanced analytics to our clients’ problems. Data Engineers, Data Scientists, Scientific Modelers, Scientific Programmers, Data Visualization Specialists as well as Geospatial Analysts are the core of the GAMMA team. They work closely with case teams to provide both consultation on analytics topics and hands-on support, focusing on data engineering, advanced analytics tools, modelling, visualization, and bespoke client-facing analytics deliverables.
The Analyst – Data Engineering will join a growing team with a global presence, and will work with both clients and case teams worldwide. Successful candidates shall possess advanced analytical technical expertise, strong collaborative and execution capabilities, excellent communication skills, a practical and flexible mindset and high attention to detail and work quality.
RESPONSIBILITIES
Work with Case Teams
- Design databases, develop extract-transfer-load (ETL) processes and facilitate customized (statistical) analyses for client work
- Collaborate with case teams to identify and accurately assess client needs and gather business requirements
- Deliver accurate, fully tested output and documentation that meets business requirements
- Perform quality assurance according to standards and guidelines for client projects
- Work on site or remote with case teams and clients
- Work as an individual contributor directly with a case team or as team member in larger case team settings
Provide training, assistance and support to clients
- Provide quick-response support to case teams on subject matter expertise
- Deliver highest-quality work both within team and to case teams / clients
- Train clients, consultants and team members on the use of data tools and methods
Other
- Perform internal team projects and duties as required
- Travel depending on project requirements
JOB REQUIREMENTS:
Education & Experience:
- Undergraduate degree related to data engineering, machine learning, computer science, applied mathematics, data science or IT is required, advanced degree is preferred
- 2+ years of industry experience or 1 year of consulting experience focused on data engineering or related areas
- Previous experience in extracting, transferring, loading large datasets, set up & manage databases, software development & -architecture, technical understanding of system capabilities and constraints is preferred
- Working experience in a global organization or professional services company is preferred
- Experience with collaboration tools & ticketing systems (e.g. JIRA, Confluence, GitHub) is preferred
- Fluent written and spoken English (other languages desirable)
KEY COMPETENCIES:
Professional capabilities
- Problem solving, communication, interpersonal and teaming skills
- Ability to effectively handle difficult and stressful situations with poise, tact and patience
- Ability to anticipate, identify, and solve critical problems
- Excellent interpersonal and communication skills
- Ability and willingness to give and receive honest, balanced feedback
- Ability to act as thought partner and expert with stakeholders at different levels
- Work management, organization and planning
- Excellent organizational skills, attention to detail, efficient time management
- Proactive communication of issues, priorities and objectives
- Ability to thrive in a dynamic, fast-paced, demanding environment
- Customer and business focus
- Strong collaborative skills and ability to adjust approach to effectively interact with clients
- Focus on excellent client service and close attention to client needs
- Values and ethics
- Demonstrates competence and character that inspires trust
- Flexible, self-motivated, and proactive out-of-the-box and critical thinker
- Able to respect all BCG and client information as personal and confidential
Technical expertise
- Experience in core big data engineering activities (one or more of the following):
- Understanding of uses of different databases (key/value, NoSQL, relational, Graph)
- Database architecture and optimization (sort keys, indexes, query optimization…)
- Data loading and management tools (Redshift copy, SQL Workbench J, Oracle SQL Developer…)
- Data cleansing
- Data modelling (variable transformation & summarization, algorithm development, …)
- Linux command line
- Cloud based experience a plus (AWS, Azure, Google)
- Familiarity with a broad base of analytics tools (one or more of the following):
- Data management: e.g. Spark, SQL Server, Amazon Redshift, Amazon S3, PostgreSql, Hadoop/Hive, Alteryx, neo4j, Teradata, other relational databases
- Programming and/or scripting experience (Python, R, Scala, Java, C#)
- Experience with continuous integration a plus (Jenkins, Travis CI)
