ETL Architect (SSIS) for Data Warehousing

Openkyber; Alaska; Hybrid; USD 90,000 - 130,000; Full time

Job summary

OpenKyber is seeking an ETL Developer for a contract-to-hire role supporting enterprise data integration, warehousing, and reporting initiatives. You will design, develop, and maintain data solutions using SQL Server and SSIS. The ideal candidate has 5+ years of hands-on SQL Server/ETL experience, data modeling expertise, and Kimball dimensional modeling.

You will collaborate with business stakeholders and technical teams across the organization. Location: Hybrid (Northeast Ohio).

Qualifications

• Bachelor’s degree in CS/IS/DM or equivalent experience.
• 5+ years in Microsoft SQL Server environments.
• Strong SSIS and ETL development experience.
• Knowledge of Kimball data warehouse methodology.
• Proficient in T-SQL, performance tuning.

Responsibilities

• Develop and maintain SSIS ETL workflows.
• Build and optimize data warehouse structures.
• Collaborate with stakeholders to gather requirements.
• Ensure data quality and integrity across systems.
• Document technical designs and metadata.
• Support data lifecycle from design to deployment.

Skills

SSIS

T-SQL

Data modeling

ETL development

SQL Server

Kimball

Education

Bachelor's degree in CS/IS/DM or equivalent

Tools

Dynamics CRM

Project

Visio

PowerPoint

Source control

Job description

OpenKyber is seeking an ETL Developer for a contract-to-hire role supporting enterprise data integration, warehousing, and reporting initiatives. You will design, develop, and maintain data solutions using SQL Server and SSIS. The ideal candidate has 5+ years of hands-on SQL Server/ETL experience, data modeling expertise, and Kimball dimensional modeling.

You will collaborate with business stakeholders and technical teams across the organization. Location: Hybrid (Northeast Ohio).