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
