Live chat

ETL Developer

eNgage Partners, Inc. - Brooklyn Heights, OH

Location:  Brooklyn Heights, OH Position Purpose:  Under minimal direction, the ETL Developer, Senior provides high quality, data driven, technology solutions that address business needs.     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.         Partner with and lead others in the delivery of database/data warehouse development solutions.            Proactively establish effective interdepartmental relationships.          Effectively manage self, time and lead resources.         Provides technical assistance in identifying, evaluating, and developing systems and procedures.         Complete all required training applicable to assigned position.         Additional duties as requested or required.  Qualifications:         Bachelors Degree in Computer Science, Information Technology or a related field.         10 years of experience and proficiency in Microsoft SQL Server 2005/ 2008 R2/2012/2014 or an equivalent combination of education, training, and experience.         Strong proficiency in SSIS with ETL processing utilizing MS SQL Server 2005/2008 R2/2012/2014.         Hands on experience with ETL data integration, enrichment, consolidation and aggregation; capture and transformation; error handling.          High-level development skills and experience with T-SQL, SSIS and PowerShell scripting.         Past experience with Data Warehousing Methodology and best practices, Kimball preferred.         Experience and familiarity with the following: .NET development, 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.  Ability to design systems and applications based on analysts of business unit requirements.  The ability to effectively present information to IT management, technical groups, and/or project teams. Work

Job Requirements
         While performing the duties of this job, the employee is frequently required to sit at the work station for extended periods.  The employee must have the ability to communicate effectively in written and oral form; enter data into a computer; and operate standard office equipment including computer, telephone, printer, copier, and facsimile machine.          The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  Normal office conditions.  The noise level in the work environment is usually moderate. Please forward your resume to [Click Here to Email Your Resumé] for immediate consideration. #CB

9 days 1 hour ago

eNgage Partners, Inc.


ETL Developer eNgage Partners, Inc. - Brooklyn Heights, OH, United States


Location: Brooklyn Heights, OH

Company Profile:
Engage Partners brings decades of combined strategic recruitment and talent acquisition expertise. Our multi-tiered collection of Recruiting and Consulting Programs provide distinct levels of services crafted to meet our clients' needs. Whether it's Direct Hire or Temporary Placement, Retained Executive Search, or Consulting Services, Engage is poised to create the right solution for your staffing needs.