The Firm's IT Financial Business Intelligence Senior Developer is primarily responsible for developing business intelligence (BI) reports in SSRS, and the technical design and support of the BI infrastructure. The role is also involved in querying, cleansing, troubleshooting, and migrating data. The incumbent in this will work productively in a collaborative environment, using data analytic skills in an investigative capacity to provide direct support to Attorney Practices.
Requirements
- SQL Server database development (database design, stored procedures, triggers, etc.)
- Microsoft SQL Server Reporting Services
- Transact-SQL
- ETL processes
- Data Warehousing and Data Marts
- Multidimensional OLAP reporting (SSAS or similar) preferred.
- Microsoft Certifications and/or completed coursework in Business Intelligence preferred.
Responsibilities
- Develop and maintain stored procedures, functions, and views to facilitate reporting.
- Design and develop dashboard reporting for Attorney Practice Groups
- Acquire and abstract primary or secondary data from existing internal or external data sources.
- Perform ad hoc queries and assists in the development of reports based in response to internal and external requests using Microsoft SQL Server and SQL Server Reporting Services
- Develop and maintain databases and data systems necessary for projects and department functions.
- Develop and implement data collection systems and strategies that optimize data quality.
- Provide technical guidance and support to junior level BI Developers
Other
- This position is currently a hybrid role with specific days required to be in the office, which may change based on the future needs of the Firm or industry standards.
- Interpret data and develop recommendations based on findings.
- Prioritize and manage multiple tasks.
- Analyze and solve problems logically.
- Communicate effectively regarding assigned tasks.
