Financial Business Intelligence Senior Developer

The 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., * 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 assist 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
• Interpret data and develop recommendations based on findings.
• Daily review of data to identify errors and anomalies, resolving issues related to data inconsistencies and irregularities, prioritizing and managing multiple tasks, analyzing and solving problems logically, communicating effectively regarding assigned tasks, and providing excellent customer service to both internal and external customers.
• Expected to maintain a regular and predictable work schedule and full attention to and engagement in work activities on behalf of the firm during business hours unless otherwise approved or required by applicable law.
• Special projects and duties as assigned.

• Collaborate efficiently within a team environment
• Utilizing data analytic skills for investigative purposes.
• Proficient in Microsoft Office Suite, or Microsoft 365., * Bachelor’s degree in business Analytics, Information Systems, Information Technology, or related field
• 7-10 years of related experience with SQL Server database development (database design, stored procedures, triggers, etc.), Microsoft SQL Server Reporting Services, Transact-SQL, ETL processes, Data Warehousing and Data Marts, * Master’s degree in business Analytics, Information Systems or Technology preferred.
• Multidimensional OLAP reporting (SSAS or similar) preferred.
• Microsoft Certifications and/or completed coursework in Business Intelligence preferred.

• Ability to sit or stand for extended periods of time.
• Moderate or advanced keyboard usage.

Benefits: Our goal is to promote a work environment in which individuals have access to the resources they need to be their best both professionally and personally, which includes resources that encourage individuals to focus on their health and well-being.

Below are the benefits we offer: comprehensive medical (PPO and HDHPs), dental and vision plans including coverage for domestic partners; life and AD&D insurance; short and long term disability insurance; tax-advantaged accounts for health care expenses, including FSAs and HSAs; FSAs for dependent care; health advocacy services; behavioral health and counseling resources for all family members; 401(k); profit sharing; backup dependent care; senior care planning support; resources for individuals with development disabilities and their caregivers; and paid holidays and other paid time off, including paid leave for new parents.