SSRS Report Developer
Apply NowCompany: Wilson Legal Solutions
Location: Newtown Square, PA 19073
Description:
Company 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 quires, 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.
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 quires, 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.