Data Warehouse/ETL Developer

Wilson Legal Solutions; Newtown Township (Delaware County); On-site; USD 75,000 - 95,000; Full time

Job summary

Wilson Legal Solutions is looking for a Data warehouse/ETL Developer to join our team in Delaware County. The role involves analyzing business requirements and developing ETL solutions using Microsoft BI stack. Candidates must have a Bachelor's degree in IT or Computer Science and 3-5 years of relevant experience, particularly with SQL Server and SSIS.

The ideal candidate demonstrates strong analytical skills and can communicate effectively with both technical and non-technical personnel. We value high attention to detail and the ability to work independently within a fast-paced environment.

Qualifications

• 3-5 years of related experience in ETL development.
• Minimum 3 years experience with SQL Server BI stack.
• Experience with SQL Server Integration Services (SSIS).
• Ability to adapt to change quickly.

Responsibilities

• Analyze business requirements for ETL solutions.
• Design and develop ETL processes and SQL queries.
• Document ETL development standards and processes.
• Support database ETL development for applications.

Skills

SQL Server Integration Services (SSIS)

T-SQL

Data Warehousing methodologies

Analytical and problem-solving skills

Interpersonal skills

Education

Bachelor's degree in Information Technology or Computer Science

Job description

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 the Inc. 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

Job Description

Data warehouse/ETL Developer

Responsibilities

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 queries, 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.

Qualifications

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

Additional Information

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