Lead Data Engineer

The Team:

At Hitachi Vantara's Digital Insights practice, we help our clients by building technology solutions that addresses business challenges and improve business outcomes with data-driven insights. As we continue expand our big data team, we are looking for Technical Lead Data engineers who are passionate about technology and want to build a career working on the latest technology platforms.

Position Overview
A Technical Lead Data Engineer is proficient in leading a team in development of all aspects of data processing including data warehouse architecture/modeling and ETL processing. This position focuses research on development and delivery of analytical solutions using various tools including Confluent Kafka, Kinesis, Glue, Lambda, Snowflake and SQL Server. A Technical Lead Data Engineer must be highly technical and able to prioritize/align their team's work with company goals to deliver projects on time with scalable solutions.

Position Responsibilities
• Responsible for project prioritization, resource allocation and on time delivery of solutions
• Require interaction with onshore/offshore counterparts to communicate business requirements in a technical design document
• Lead and foster data engineers in their careers to produce higher quality solutions at a faster velocity through optimization training and code review
• Multi-task across several ongoing projects and daily duties of varying priorities as required
• Partner with business stakeholders to gather requirements and translate them into technical specifications and process documentation for IT counterparts (on-prem and offshore)
• Highly proficient in the architecture and development of an event driven data warehouse; streaming, batch, data modeling, and storage
• Advanced database knowledge; creating/optimizing SQL queries, stored procedures, functions, partitioning data, indexing, and reading execution plans
• Skilled experience in writing and troubleshooting Python/PySpark scripts to generate extracts, cleanse, conform and deliver data for consumption
• Expert level of understanding and implementing ETL architecture; data profiling, process flow, metric logging and error handling
• Support continuous improvement by investigating and presenting alternatives to processes and technologies to an architectural review board
• Develop and ensure adherence to published system architectural decisions and development standards

Requirements
• 4+ years leading a team or projects
• 10+ years of development experience
• Highly proficient in Snowflake development
• Bachelor's degree in Computer Science, MIS or related field (industry experience substitutable)
• Expert level in data warehouse design/architecture, dimensional data modeling and ETL process development
• Advanced level development in SQL/NoSQL scripting and complex stored procedures (Snowflake, SQL Server, DynomoDB, NEO4J a plus)
• Extremely proficient in Python, PySpark, and Java
• AWS Expertise - Kinesis, Glue (Spark), EMR, S3, Lambda, and Athena
• Streaming Services - Confluent Kafka and Kinesis (or equivalent)
• Hands on experience in designing and developing applications using Java Spring Framework (Spring Boot, Spring Cloud, Spring Data etc)

We are proud to say we are an equal opportunity employer and welcome all applicants for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. With Japanese roots going back over 100 years, our culture is founded on the values of our parent company expressed as the Hitachi Spirit:

Wa - Harmony, Trust, Respect
Makoto - Sincerity, Fairness, Honesty, Integrity
Kaitakusha-Seishin - Pioneering Spirit, Challenge