ETL Developer

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

Our client is a large Legal Firm based in the Cleveland area. The are seeking someone interested in a contract to hire. You would be on the payroll of EIS for 6 months and then convert.

Candidates need to be local to the Greater Cleveland area, be a US Citizen or have a Green Card.

About the Role

The ETL Developer provides high quality, data driven, technology solutions that address business needs. Hours: Monday - Friday 8am - 5pm EST in office for the first 90 days and then hybrid schedule option

Responsibilities

• Responsibilities/Duties/Functions/Tasks:
• Create and support data load processes via SSIS (SQL Server Integration System) and database refreshes
• Communicate effectively in both verbal (i.e. day-to-day discussions, team meetings) and written (requirements and design specifications) form, as well as have an overall ability to be clear and concise in all communications
• Development/management of schema data model through all data warehouse environments
• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
• Design and develop ETL programs to extract data from transactional database systems and load to the Data Warehouse using SSIS (SQL Server Integration System)
• Create technical design documentation, which includes database design models and ETL program specifications for the implementation of the data model
• Create and maintain documentation as it relates to data configuration, mapping, standards, and processes
• Maintain mappings of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
• Understand technical requirements and confirm that needs are met or exceeded
• Provide appropriate information to elicit or help clarify around the requirements
• Complete all required training applicable to this position
• Regular and predictable attendance is an essential function of this position
• Other duties, as assigned

Qualifications

• BA/BS in Computer Science or related field is preferable. Equivalent combination of experience, education and training will be considered
• 5 years of experience and proficiency in Microsoft SQL Server 2005/ 2008 R2/2012/2014 or an equivalent combination of education, training, and experience.
• Knowledge of ETL processing. SSIS Technology preferred
• Hands on experience with ETL data integration, enrichment, consolidation and aggregation; capture and transformation; error handling
• High-level development skills and experience with Complex T-SQL
• Experience with Data Warehousing Methodology and best practices, Kimball preferred
• Experience and familiarity with the following: MS Office Products, MS CRM, MS Project, MS Visio, MS PowerPoint, and MS Team Foundation Server (TFS)
• Ability to read, analyze and interpret technical documents.

Required Skills

• Proficiency in Microsoft SQL Server 2005/ 2008 R2/2012/2014
• Knowledge of ETL processing
• Hands on experience with ETL data integration, enrichment, consolidation and aggregation; capture and transformation; error handling
• High-level development skills and experience with Complex T-SQL
• Experience with Data Warehousing Methodology and best practices, Kimball preferred
• Experience and familiarity with MS Office Products, MS CRM, MS Project, MS Visio, MS PowerPoint, and MS Team Foundation Server (TFS)
• Ability to read, analyze and interpret technical documents.

Preferred Skills

• Experience with Data Warehousing Methodology and best practices, Kimball preferred