Sr. Analyst, Data Engineering
Core
Design, develop, and optimize Enterprise Data Warehouse (EDW) solutions by extracting and loading data from heterogeneous OLTP sources.
Role type
Senior Data Engineer (ETL & Data Warehousing)
Builds
Enterprise Data Warehouse (EDW) and data pipelines
Domain
Enterprise Data Management / Cloud Data Warehousing
Required skills
ETL design and development, Data modeling, Advanced SQL and PL/SQL, Python scripting, Unix/Linux/Windows OS, Version Control, Root cause analysis, Data acquisition from XML/JSON/RDBMS/Flat files
Preferred skills
React.js, Node.js
Technologies
Pentaho Data Integration, Snowflake, Oracle R12 ERP, MySQL, NoSQL DBs, XML, JSON
Responsibilities
Participate in the incremental development of the Enterprise Data Warehouse (EDW), optimize design considering cost and quality, analyze poorly performing queries/ETL mappings to provide tuning suggestions, extract data through various sources (XML, Json, RDBMS, Flat file), populate data warehouses from heterogeneous OLTP sources.
Seniority
Senior, hands-on IC