Senior Data Warehouse Developer - PL/SQL/ETL & SSIS

Sdna; United States; Hybrid; USD 120,000 - 160,000; Full time

Job summary

Sdna seeks an experienced Senior Developer to design and optimize data solutions using PL/SQL, SQL, ETL, and Microsoft SSIS, supporting enterprise data warehousing initiatives in a hybrid work model. This role focuses on building robust scheduling workflows and integrating multi-channel and supply chain data for global stakeholders.

The ideal candidate will implement and optimize ETL pipelines, ensure data quality, and collaborate with cross-functional teams to deliver reliable analytics that

Qualifications

• Experience designing and optimizing data solutions for enterprise reporting.
• Strong skills in PL/SQL, SQL, and ETL workflows.
• Proficiency with Microsoft SSIS and managing data warehousing pipelines.
• Ability to translate multi-system data into centralized, reliable datasets.

Responsibilities

• Design and develop PL/SQL procedures, functions, and queries for robust data processing.
• Implement and optimize ETL workflows using SSIS to move and transform large datasets.
• Configure and manage scheduling for batch jobs to ensure timely data availability.
• Analyze data warehousing concepts to improve scalability and analytical value.
• Collaborate with cross-functional teams to translate data requirements into technical solutions.
• Perform root cause analysis and remediate data quality issues.
• Document data flows, mappings, and deployment steps for maintainability.
• Conduct unit, integration, and regression testing of PL/SQL, SQL, and ETL components.
• Provide production support for data warehouse jobs and SSIS packages.
• Engage stakeholders in a hybrid work setting to refine deliverables.
• Propose new data engineering patterns to increase automation and reliability.
• Align development with organizational goals to improve customer experiences and supply chains.
• Ensure compliance with quality guidelines and regulatory expectations.

Skills

PL/SQL

SQL

ETL

Data warehousing

SSIS

Tools

Microsoft SSIS

PL/SQL

SQL

Data warehousing

ETL

Job description

Sdna seeks an experienced Senior Developer to design and optimize data solutions using PL/SQL, SQL, ETL, and Microsoft SSIS, supporting enterprise data warehousing initiatives in a hybrid work model. This role focuses on building robust scheduling workflows and integrating multi-channel and supply chain data for global stakeholders.

The ideal candidate will implement and optimize ETL pipelines, ensure data quality, and collaborate with cross-functional teams to deliver reliable analytics that