Data Engineer (ETL / DWH)

We are seeking an experienced Data Engineer with 8+ years of IT experience and at least 4 years of experience in ETL, DWH/BI, and data visualization, along with knowledge of SQL, data pipelines, and cloud platforms.

Key Responsibilities

• Participate in the estimation of data-related work products to provide the project manager (PM) with the appropriate information for overall project estimation.
• Understand functional and non-functional requirements by reviewing specifications and gathering input from business analysts, and translate them into system requirements to create a system requirements document.
• Participate effectively in the design, development, and testing phases of data projects.
• Create data design documents to deliver outputs in line with architectural requirements.
• Build data infrastructure for extracting, transforming, and loading data from data sources to consumption.
• Build and optimize data pipelines and manage metadata.
• Define data management processes to improve data quality.
• Develop and review artifacts, including code, mapping, documentation, monitoring scripts, and unit test scripts.
• Conduct reviews of personal and peer deliverables, perform unit testing, and document unit test results for complex data programs to prepare applications for validation and delivery.
• Work with cross-functional teams in a dynamic environment.
• Participate in a learning culture where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.

Requirements

What are we looking for

• A bachelor's degree or foreign equivalent from an accredited institution is required. Three years of progressive experience in the specialty may be considered in place of each year of education.
• At least 8 years of experience in the IT field.
• At least 4 years of experience in ETL, DWH/BI, and data visualization.
• Japanese nationality or valid work authorization in Japan is welcome. Visa sponsorship is not currently available.

Preferred Qualifications

• At least 4 years of experience in ETL, DWH/BI, data visualization, AWS/Azure/GCP cloud platforms, Master Data Management (MDM), Snowflake, SQL databases, and NoSQL databases such as DynamoDB, Cassandra, and MongoDB.
• At least 4 years of experience in the Data and Analytics domain.
• Excellent verbal and written communication skills.
• Experience with the software development life cycle (SDLC).
• Ability to work effectively in a team within a diverse environment involving multiple stakeholders.
• Experience working in a global delivery environment and a desire to work in such an environment.