Data Warehouse Developer - DWD 25-34542

NavitsPartners•New York, NY

41d

About The Position

The Data Warehouse Developer will work closely with internal stakeholders to maintain and enhance existing data warehouse processes and systems, convert legacy ETL processes to modern enterprise ETL platforms, and develop new workflows to integrate additional datasets into the data warehouse environment. Only one candidate should be proposed for this role, and the candidate must meet all defined minimum qualifications. This role focuses on database development, ETL development, and analytics platform support for enterprise data warehouse and reporting systems.

Nice To Haves

Additional years of experience beyond the minimum required qualifications
Strong hands-on experience with ETL development , particularly using Attunity Compose
Proven experience working in enterprise data warehouse environments supporting both transactional and analytical systems

Responsibilities

Maintain and develop SQL and PL/SQL code supporting enterprise transactional applications
Maintain, convert, and develop BI Publisher reports supporting transactional and reporting systems
Perform database modeling for Online Transaction Processing (OLTP) systems
Perform database modeling for Online Analytical Processing (OLAP) systems within the enterprise data warehouse
Tune SQL queries to improve performance and efficiency
Develop new ETL processes using enterprise ETL tools
Maintain existing ETL processes using legacy and modern ETL platforms (e.g., Oracle Warehouse Builder and Attunity Compose)
Convert existing ETL workflows from legacy ETL tools to Attunity Compose
Maintain and develop physical, logical, and business layers in the analytics repository within a multi-user development environment (MUDE)
Maintain and enhance dashboards, reports, visualizations, and analytical content in enterprise analytics platforms