Weltman, Weinberg & Reis Co., LPA - ETL Developer

Developer is needed in Independence, United States.

Client: Weltman, Weinberg & Reis Co., LPA

Location: Independence, OH

Contract: undefined

Job Description

The ETL Developer provides high quality, data driven, technology solutions that address business needs. The position requires Monday to Friday 8am - 5pm EST in-office work for the first 90 days, followed by a hybrid schedule option.

Responsibilities/Duties/Functions/Tasks

• Create and support data load processes via SSIS (SQL Server Integration System) and database refreshes.
• Communicate effectively in both verbal and written forms and be clear and concise in all communications.
• Development/management of schema data model across all data warehouse environments.
• Perform detailed data analysis to 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.
• Create technical design documentation including database design models and ETL program specifications.
• Create and maintain documentation related to data configuration, mapping, standards, and processes.
• Maintain mappings of data sources, data movement, interfaces, and analytics to ensure data quality.
• Understand technical requirements and confirm that needs are met or exceeded.
• Provide information to elicit or help clarify requirements.
• Complete all required training applicable to this position.
• Regular and predictable attendance is an essential function of this position.
• Perform other duties as assigned.

Requirements

• 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 (versions 2005-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, aggregation, capture, transformation, and error handling.
• High-level development skills and experience with Complex T-SQL.
• Experience with Data Warehousing Methodology and best practices, with Kimball preferred.
• 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.

Compensation and Benefits

• The expected compensation is $67,770 - $84,713/year.
• Paid Time Off (PTO) - 16 days annually + 9 Company paid holidays.
• Competitive benefits include Medical, Rx, Dental, Vision, 401(k), Parental Leave, Life and Disability Insurance, and more. More information available at www.weltman.com/careers.
• Promotional opportunities from within the Firm.
• Employee perks available from local businesses and events.
• On-site “Bistro To Go” vending and fresh foods available.
• Parking or public transit stipend available with benefits elections.
• Onsite fitness center available to join.

Physical and Mental Demands

The physical and mental demands described here represent those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made for individuals with disabilities. The employee is regularly required to remain stationary at a workstation, use hands and fingers for typing and operating a computer, and communicate information and ideas effectively. Occasional standing, walking, bending, and lifting items weighing up to 15 pounds may be required. Close visual acuity is needed to read, analyze data, and view a computer for extended periods.

Work Environment

This position operates in a professional office environment with low to moderate noise levels and moderate interruptions. The workspace is well-lit and climate controlled.

EEO Statement

Weltman is an equal opportunity employer. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.