ETL Developer

Weltman, Weinberg & Reis Co., LPA•Seven Hills, OH

2h•$67,770 - $84,713•Hybrid

About The Position

The ETL Developer provides high quality, data driven, technology solutions that address business needs.

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.

BA/BS in Computer Science or related field is preferable. Equivalent combination of experience, education and training will be considered

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

Paid Time Off (PTO) - 16 days annually + 9 Company paid holidays
Competitive benefits - Medical, Rx, Dental, Vision, 401(k), Parental Leave, Life and Disability Insurance and more.
Promotional opportunities from within the Firm
Employee Perks available from Verizon, Car Dealerships, Local Movie Theaters, Theme Parks, etc.
Positive office environment with regularly scheduled parties, contests, and community support initiatives
On site "Bistro To Go" vending and fresh foods available
Stipend for parking or public transit available with benefits elections
Onsite fitness center available to join

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.