SSRS Report 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 skilled professional to analyze business requirements and implement ETL solutions based on Microsoft BI stack. This role demands strong expertise in SQL Server and experience in data warehousing methodologies.

The ideal candidate will possess a Bachelor’s degree in Information Technology or Computer Science and 3-5 years of relevant experience, including SSIS and SSRS. Join our rapidly growing team in Newtown Township!

Qualifications

• 3 - 5 years related experience required.
• Must have extensive experience with SQL Server BI stack.
• Strong knowledge of data warehousing methodologies is a must.

Responsibilities

• Analyze business requirements and support data warehouse ETL solutions.
• Develop, test, and implement ETL processes and SSRS reports.
• Resolve production-related ETL database development issues.

Skills

SQL Server Integration Service (SSIS)

SQL Server Reporting Services (SSRS)

Data Warehousing methodologies

T-SQL

Complex SQL queries

Analytical skills

Organizational skills

Problem solving

Communication skills

Interpersonal skills

Education

Bachelor's degree in Information Technology or Computer Science

Tools

SQL Server 2008R2/2012/2014

Microsoft BI stack

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 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

Job Description

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 and SSRS reports relating to proprietary Business Intelligence solution built on the Microsoft BI stack.
• Design, develop, test, tune, and implement ETL processes, SSRS Reports, SQL queries, stored procedures; this includes but not limited to SSIS packages, stored procedures, views, and functions
• Research and facilitate resolutions of support or production related ETL database development issues and SSRS report issues
• Create and maintain documentation as it relates to ETL, database and report development standards, templates, and processes
• Responsible for the analysis, design, documentation, development, unit testing, and support of database ETL and report 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)
• Minimum 3 years development experience with SQL Server Reporting Services (SSRS)
• 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 preferable
• Experience working with Aderant a plus
• Demonstrates initiative and works independently with minimal supervision

Additional Information

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