Latest Jobs  
Advance your technical career… Find a tech school and start an IT career!
Start your career in the fast-growing technical field – Get more info here »
Advance your technology career with the latest technology skills - Get more info here »
 
 
Job Information
Job title

Data Warehouse ETL Developer (2605)

Company Crowe Chizek and Company LLC
Wage Not specified
Location United States, Illinois, Villa Park
Employment type Full Time
Education Not Specified
Year Experience 4 - 5 Years of Practical Experience
Travel Not Specified
Published on 7/17/2008
Description
Why Crowe?
What could you do with a true work life balance - spend time with your family or pursue outside interests? Find out by working for Crowe! Would you like to be promoted based on your abilities versus on your tenure? Crowe values all of your experience and promotes or enhances positions to leverage every employee's contributions. What if you can have all of this with an attractive salary and benefits? Then Crowe Chizek and Company LLC is the firm for you! We understand that in order to be satisfied in your career every aspect of your life should be fulfilled. We offer the opportunities to expand and enrich your career while allowing you a balance with your personal life through a team atmosphere, flexibility and Talent Development. We have maintained an average compounded growth of 17 percent for the past 40 years through our strong client relationships and employees' talent.

Under its core purpose of "Building Value with ValuesÁ®," Crowe Chizek and Company LLC (www.crowechizek.com) provides innovative business solutions in the areas of assurance, benefit plan services, financial advisory, forensic services, performance services, risk consulting and tax consulting. Crowe Chizek, a Crowe Group LLP entity, was founded in 1942. One of the top 10 public accounting and consulting firms in the United States, Crowe also serves clients worldwide as a leading independent member of the Horwath International global professional services organization.

Summary
The Data Warehouse ETL Developer will develop and deploy subject oriented data marts to support business intelligence applications. This position works within the Information Services Business Intelligence-Data Warehouse (BI-DW) team to deliver, enhance and support our BI Data Warehouse. In this role, you will establish technical design plans, develop extract-transform-load packages, unit test, enhance/fix, document, deploy, support and maintain data warehouse solutions using SQL Server tools.

Responsibilities
- Design, develop and work with production support to deploy object/schema changes and extraction-transformation-load (ETL) packages/processes for new and existing source data for the data warehouse
- Develop data warehouse solutions according to established ETL development standards. Where standards do not exist (e.g., new technology, complexity) this position will provide thought leadership to develop alternatives and guidelines, best practices and standards
- Work with production support personnel to implement, support; maintain jobs that run in the production environment
- Interact with business analysts and end users to gather or review requirements and prepare design specifications
- Conduct impact analysis for change requests (architecture, objects, datasets, processes) and advise stakeholders
- Troubleshoot and resolve data, system and performance problems and recommend solutions
- Design, deploy transaction rollback and data restore functions as required to recover from bad dataset entries
- Develop exception handling and notification and ETL audit functions to support new and existing data marts (data quality screens, flash totals, production monitors)
- Prepare and keep system level metadata and documentation current and accurate
- Design, develop and work with production support to deploy ETL jobs to meet performance requirements (input, refresh/update job performance) and optimize data warehouse performance (output, query performance)
- Ensure all designs adhere to security, privacy and compliance requirements
- Ensure high quality deliverables; that errors are detected in programming or testing to avoid production outages, and in initial component design to avoid delays in project schedules
- Conduct and facilitate/support testing (unit, integration, user acceptance, performance tests)
- Support the project manager in defining scope, plans, and deliverables for assigned projects
- Support project management activities, including development estimates, project activity tracking, status reporting, risk mitigation, etc.

Technical Skills/Experience
Required
- Experience with software development methodologies and tools
- Experience in database design
- 3+ years experience with relational database engines, preference to MS SQL Server (SQL agent, encryption, replication, backup, restore and other admin tasks in a development environment)
- 3+ years experience developing advanced SQL queries and stored procedures
- Working knowledge of data warehouse and data mart architectures (dimensional models, star schema)
- 2+ years experience developing Data Warehouse ETL solutions
- 2+ years experience with ETL tools (MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS))
- 2+ years experience developing with the .Net Framework
- 1 year / working knowledge of Visual Studio Team Suite (VSTS)

Preferred
Experience with SQL Server Analysis Services (SSAS) is a plusdf-tc

Experience/Skills
See Above

Other desired skills:
Data Warehouse ETL Developer (2550)