ETL Developer - Contract-to-Hire | SSIS

Exodus Integrity Services | IT Staffing & Consulting; Cleveland (OH); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Exodus Integrity Services | IT Staffing & Consulting in Cleveland is seeking an experienced ETL Developer for a contract-to-hire engagement with a large Legal Firm client. You would start on the payroll of EIS for six months and then convert.

The role requires in-office work Mon-Fri 8am-5pm EST for the first 90 days, followed by a hybrid schedule. Responsibilities include building data load processes with SSIS, data warehouse modeling, and ensuring data quality.

Qualifications

• BA/BS in Computer Science or related field; equivalent experience considered.
• 5+ years of experience with Microsoft SQL Server 2005/2008 R2/2012/2014 or equivalent.
• Knowledge of ETL processing; SSIS preferred.
• Hands-on ETL data integration, enrichment, consolidation and aggregation; capture and transformation; error handling.
• High-level development skills with Complex T-SQL.
• Experience with Data Warehousing Methodology; Kimball preferred.
• Familiarity with MS Office products and MS Project tools.
• Ability to read, analyze and interpret technical documents.

Responsibilities

• Create and support data load processes via SSIS and database refreshes.
• Communicate effectively in verbal and written form.
• Develop and manage schema data models across data warehouse environments.
• Perform detailed data analysis of source systems and samples.
• Design and develop ETL programs to extract data and load to the Data Warehouse using SSIS.
• Create technical design documentation for the data model implementation.
• Create and maintain documentation related to data configuration, mapping, standards, and processes.
• Maintain mappings of data sources, data movement, interfaces, and analytics.
• Ensure requirements are understood and met.
• Provide information to clarify requirements.
• Complete required training; maintain regular attendance.
• Other duties as assigned.

Skills

ETL processing

Complex T-SQL

Data analysis

Data warehousing

SQL Server proficiency

Education

BA/BS in Computer Science

Tools

SSIS

TFS

MS Visio

Job description

Exodus Integrity Services | IT Staffing & Consulting in Cleveland is seeking an experienced ETL Developer for a contract-to-hire engagement with a large Legal Firm client. You would start on the payroll of EIS for six months and then convert.

The role requires in-office work Mon-Fri 8am-5pm EST for the first 90 days, followed by a hybrid schedule. Responsibilities include building data load processes with SSIS, data warehouse modeling, and ensuring data quality.