Data Warehouse/ETL Developer

Wilson Legal Solutions Overview: Founded in 2009 by Bruce A Wilson, Wilson Legal Solutions is a professional services firm that helps law firm customers maximize the benefits of technology to reach new levels of operational efficiency and profitability. We apply more than 25 years of technical and law firm experience to help clients navigate the often complex maze of practice management software. Wilson Legal Solutions is based in Newtown Square Pa. and has several offices in the U.S. We are a small, but fast growing company that recently obtained Incs 500 list of the 2013 fastest-growing private companies in America. With a three-year growth rate of 4,839%, the company has earned the following recognition: • Number 62 on the overall 2013 Inc. 500 list • Number 4 among the top 100 IT services companies • Number 1 among the 100 fastest-growing Pennsylvania companies • Number 1 among the fastest-growing companies in the Philadelphia metro area 

Data warehouse/ETL Developer

Responsibilities include:

• Work with Clients, Project Managers, Business Analysts, Application Developers, Solution Architects and Data Architects in analyzing business requirements and specifications to define, implement, customize and support data warehouse ETL solutions relating to proprietary Business Intelligence solution built on the Microsoft BI stack.

• Design, develop, test, tune, and implement ETL processes, SQL quires, stored procedures; this includes but is not limited to SSIS packages, stored procedures, views, and functions

• Research and facilitate resolution of support or production related ETL database development issues

• Create and maintain documentation as it relates to ETL database development standards, templates, and processes

• Responsible for the analysis, design, documentation, development, unit testing, and support of database ETL development for software applications

REQUIREMENTS:

• Bachelor's degree from four-year college or university (in Information Technology or Computer Science preferred) plus 3 - 5 years related experience 

• Minimum 3 years experience with SQL Server 2008R2/2012/2014 development BI stack

• Minimum 3 years development experience with SQL Server Integration Service (SSIS)

• Strong knowledge of Data Warehousing methodologies and concepts

• Advanced knowledge of T-SQL including complex SQL queries, stored procedures, views and functions

• Experience with index design and T-SQL performance tuning techniques

• Experience with SSAS multi-dimensional and tabular models a plus

• Strong quantitative, analytical, problem solving, organizational and communication skills are required

• Ability to comprehend complex technical and logical concepts and adapt quickly to change

• Must be able to manage timelines and task priorities across multiple projects

• Attention to detail and maintaining high quality standards is a must

• Must be able to effectively communicate technical information to both technical and non-technical personnel

• Strong interpersonal skills - must be able to work effectively as part of a project team and foster team co-operation

• Legal industry experience working with Aderant preferable.

• Demonstrates initiative and works independently with minimal supervision

All your information will be kept confidential according to EEO guidelines.