The Business Intelligence Developer will use an in-depth and hands-on knowledge of enterprise data systems, software technology and report authoring to perform enterprise-scale data analysis and reporting across core Firm software systems. The Developer will be responsible for the design, development, implementation and support of reports, dashboards and ad-hoc data analysis using the Microsoft SQL Server technology stack.

Responsibilities include, but are not limited to:

• Design, build and implement reports, dashboards, ETLs, cubes and business intelligence solutions using SQL Server, SSIS, SSAS and SSRS
• Develop, test, and deploy ETLs, SQL stored procedures and MDX/DAX queries to solve complex data analysis problems based on requirements from different teams
• Design and implement reports and dashboards using PowerPivot, PerformancePoint and SharePoint technologies
• Develop and maintain comprehensive business process knowledge of internal functional groups including Finance, eDiscovery, Records, Payroll, HR and Information Technology
• Collaborate with Applications, Infrastructure, and DBA teams as well as business owners to design and build enterprise-scalable analysis platform and reports
• Conduct proactive end-to-end monitoring of reporting platforms, identify business application opportunities for improvement and streamline operational processes
• Troubleshoot and address technical issues with reports and source systems
• Act as liaison to external vendors in conducting case management
• Review and advise toward market developments, including upgrades, available features and functionality and new applications

Qualifications

• Bachelor’s Degree in Computer Science, Information Systems or a related area
• 3-5 years of experience as a Business Intelligence Analyst, Application Developer or Software Engineer in executing all facets of the systems development life cycle
• 3 years of hands-on experience in the design and development of business intelligence solutions using Microsoft SQL Server, SSIS, SSAS and SSRS
• 3 years of hands-on database development experience in T-SQL, MDX, DAX and ETL platforms
• Strong familiarity with the Microsoft technology suite, OLAP cubes, relational database management systems and enterprise application integration is required
• Ability to design and deliver scalable solutions which balance performance, reliability and maintainability
• Strong professional and interpersonal skills including creative problem solving, effective written and verbal communications, planned and organized coordination of cross-functional teams, acute attention to detail and quality, and driven with the ability to self-manage
• Ability to multi-task across projects/initiatives and deliver according to time and cost commitments
• Experience producing interactive dashboards and/or BI data visualization techniques
• Experience working with both technical and business teams
• Experience with Microsoft SharePoint, Aderant, Oracle Cloud, Intappfind Time/APS DTE and similar legal industry systems is a plus
• Experience in business analysis is a plus