Financial Business Intelligence Senior Developer

Holland & Knight; Tampa (FL); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Medical insurance

401(k) plan

Paid holidays

Job summary

Holland & Knight in Tampa, FL seeks a Financial Business Intelligence Senior Developer to design and deliver BI reports using SSRS and manage data in SQL Server environments. You will cleanse, query, migrate data and support Attorney Practices with analytical insights.

You will collaborate with teams, develop dashboards for Practice Groups, and guide junior BI developers while ensuring data quality and timely delivery.

Qualifications

• Bachelor's degree required in a relevant field; 7–10 years of SQL Server development experience including stored procedures, functions, triggers, and data warehouse concepts.
• Experience with Microsoft SQL Server Reporting Services (SSRS) and ETL processes; strong data cleansing and migration skills.
• Multidimensional OLAP knowledge is preferred; Microsoft Certifications are a plus.

Responsibilities

• Develop and maintain stored procedures, functions, and views to support reporting.
• Design and develop dashboards for Attorney Practice Groups.
• Acquire and abstract data from internal/external sources.
• Perform ad hoc queries and develop reports using SSRS.
• Maintain databases and data systems for projects and department needs.
• Provide guidance to junior BI developers and interpret data to inform decisions.

Skills

Team collaboration

Data analytics

MS Office 365

Education

Bachelor's degree in Business Analytics / IT / related field

Tools

SQL Server

SSRS

T-SQL

ETL

Data Warehousing

Data Marts

SSAS

Job description

General Description:

We are a Firm where people truly believe in what they do and strive to achieve the highest standards of performance and success.

This position is based in the Firm's global operations center in Tampa, FL.

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.

Key Responsibilities and Essential Job Functions:

• 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.

Required Skills:

• Collaborate efficiently within a team environment
• Utilizing data analytic skills for investigative purposes.
• Proficient in Microsoft Office Suite, or Microsoft 365.

Required Qualifications & Education:

• 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

Preferred Qualifications & Education:

• 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.

Physical Requirements:

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

Benefits:

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.

Holland & Knight is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy, childbirth or related conditions, transgender status, and sexual orientation), national origin, age, disability, genetic information, veteran status or any other factor prohibited by law.

Personal Information collected from applicants will be used for the purpose of processing the application throughout any recruitment or employment process, as well as inclusion in a personnel file. Categories of data collected may include name, address, phone numbers, email, Social Security Number, and signature. Holland & Knight may collect further information if you consent to a background check. This includes criminal background, employment, and certifications. Please visit Legal Information Portal for Holland & Knight LLP's privacy policies.