Financial Business Intelligence Developer

Holland & Knight LLP; Tampa (FL); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical coverage

Dental & Vision

401(k) with profit sharing

Paid holidays

Paid time off

Disability insurance

Job summary

Holland & Knight LLP seeks a Financial BI Developer to design, build, and maintain BI reports and data solutions using SQL Server-based tools. You will query, cleanse, and migrate data from multiple sources to support reporting and business operations, collaborating with stakeholders to understand requirements and drive data-driven decisions.

The role covers ETL/ELT processes, SSIS/SSRS development, dashboards, and data warehouse support.

Qualifications

• Bachelor’s degree required; field related to BI/Analytics preferred.

Responsibilities

• Develop, maintain, and optimize SQL queries, stored procedures, views, and other database objects to support reporting and BI initiatives.
• Design, develop, and maintain SSRS reports and support BI initiatives using Power BI or similar tools.
• Develop and support ETL/ELT processes using SSIS and other data integration technologies.
• Integrate data from multiple systems and sources and support data governance efforts.
• Create dashboards and visualizations that communicate financial information clearly.

Skills

Attention to detail

Advanced SQL development

ETL/ELT processes

Data governance

Analytical thinking

Communication with stakeholders

Team collaboration

Office 365

Education

Bachelor’s Degree

4–6 years BI/Analytics experience

Tools

SSRS

SSIS

Power BI

Tableau

Azure DevOps

SQL Server

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

General Description

We are seeking a Financial Business Intelligence Developer to join our team. The Financial Business Intelligence Developer is primarily responsible for designing, developing, and maintaining business intelligence reports and data solutions using SQL Server technologies and related business intelligence tools. This role involves querying, cleansing, troubleshooting, integrating, and migrating data from multiple sources to support reporting and business operations. The Developer collaborates effectively within a team environment and partners with business stakeholders to understand reporting requirements, develop data-driven solutions, and support business decision-making. Responsibilities include advanced SQL development, ETL processes, SSRS report development, data modeling, dashboard creation, and supporting data warehouse initiatives. The Developer applies strong analytical and problem-solving skills to investigate, interpret, and present data while adhering to established data governance and development standards.

Key Responsibilities And Essential Job Functions

• Develop, maintain, and optimize SQL queries, stored procedures, views, and other database objects to support reporting and business intelligence initiatives.
• Design, develop, and maintain SQL Server Reporting Services (SSRS) reports and support future business intelligence initiatives utilizing Power BI or similar visualization platforms.
• Develop and support ETL/ELT processes using SQL Server Integration Services (SSIS) and other data integration technologies.
• Integrate data from multiple systems and sources, including databases, flat files, and third-party applications.
• Support data governance efforts by promoting data quality, consistency, integrity, and proper documentation.
• Participate in application lifecycle management and source control processes using Azure DevOps or equivalent version control and deployment tools.
• Create and maintain technical documentation related to reports, data integrations, ETL processes, and database structures.
• Develop dashboards and visualizations that communicate business and financial information in a meaningful and actionable manner.
• Analyze complex data issues and recommend solutions to improve reporting efficiency, accuracy, and usability.
• 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

• Very detail-oriented with the ability to administer, support, and maintain key business applications and reporting systems.
• Advanced SQL development skills including T-SQL, stored procedures, views, functions, query tuning, and database troubleshooting.
• Experience developing and maintaining SQL Server Integration Services (SSIS) packages and ETL/ELT processes.
• Experience developing business intelligence reports using SQL Server Reporting Services (SSRS); exposure to or experience with Power BI, Tableau, or similar visualization tools is preferred.
• Knowledge of relational database design, data modeling, and dimensional modeling concepts.
• Familiarity with data warehouse concepts, architecture, and reporting environments.
• Experience integrating data from multiple systems through databases, flat files, and other data exchange mechanisms.
• Knowledge of financial systems and concepts, including ERP systems, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), budgeting, and financial reporting processes.
• Understanding of data governance, data stewardship, and data quality best practices.
• Experience designing dashboards, reports, and visualizations that effectively communicate business and financial information.
• Experience with Azure DevOps or equivalent source control, version management, and deployment tools.
• Strong analytical, statistical, and problem-solving skills with the ability to interpret data and identify trends, anomalies, and opportunities.
• Experience automating and streamlining business processes and reporting workflows.
• Must be able to interact and communicate effectively with professionals in other administrative departments as well as attorneys and legal staff.
• Proficient in Microsoft Office Suite and Microsoft 365.

Required Qualifications & Education

• Bachelor’s Degree
• 4 to 6 years of experience in Business Intelligence, Reporting, Data Analytics, Database Development, Financial Systems, or a related technical field.

Preferred Qualifications & Education

• Experience with legal financial systems would be an asset (Aderant Expert Sierra would be an advantage).

Physical Requirements

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

Benefits

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

Applicants who are interested in applying for a position and require an accommodation during the process should contact [e-mail].

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.