Data Engineer (ETL / DWH)

• 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

• 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.
  

• 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.