ETL Developer

Cynet Systems•San Jose, CA

About The Position

The Contractor will develop new features/enhancements, refactor legacy ETL code, and fix bugs for the Business Intelligence and Analytics team. The Contractor will own tasks through the entire software development lifecycle from concept to release to production, including documenting business requirements, documenting the development approach, implementing code changes, testing, gathering approvals, and migrating code. The Contractor will develop code changes, unit tests, integration tests, and performance tests in accordance with development standards and best practices. The Contractor will develop code changes based on functional requirements defined via business requirement documents (BRDs), functional specification design documents (FSDs), Technical Design Documents (TDDs), or other written/verbal instructions. The Contractor will collaborate with business analysts, program managers, and other contractors to determine functional and technical requirements. The Contractor will also own report/dashboard delivery tasks from development through support, including documenting the development approach, implementing code changes, testing, gathering approvals, migrating code, and supporting/enhancing code post-production. Additionally, the Contractor will provide support for new and existing data models, ETL pipelines, and data marts, and create and maintain detailed documentation using Google Docs/Sheets/Slides for assigned design/development and testing tasks as prescribed by the BI team.

Requirements

5+ years of experience in Data engineering projects
Experience with SQL or equivalent database querying language
Working knowledge of relational databases, including BigQuery, MySQL and large-scale distributed systems
Analytical skills with the experience identifying, quantifying, and effectively raising business risks associated with data quality or non-compliance
Strong communication and collaboration skills with capability to execute with business stakeholders
Experience in delivering Business Intelligence solutions
Strong SQL skills in complex queries and data manipulation
Experience in developing ETL/building data pipelines with ETL tools or programming languages
Experience in databridge

Nice To Haves

Python programming
Shell scripting
Java scripting
Supply chain experience background

Responsibilities

Develop new features/enhancements
Refactor legacy ETL code
Fix bugs for the Business Intelligence and Analytics team
Own tasks through the entire software development life cycle from concept to release to production
Document business requirements
Document development approach
Implement code changes
Test code changes
Gather approvals for code changes
Migrate code
Develop code changes, unit tests, integration tests and performance tests
Develop code changes based on functional requirements defined via BRDs, FSDs, TDDs, or other instructions
Work with business analysts, program managers and other contractors to determine functional & technical requirements
Own report/dashboard delivery tasks from development through support
Support new and existing data models, ETL pipelines and data marts
Create and maintain detailed documentation via Google Docs/Sheets/Slides