Business Intelligence Specialist

What We Do:

Florence software advances cures by helping the world’s most important research sites do their best work. Our solutions are now used by over 30,000 research teams in 70 countries around the world—we’re the most widely deployed site workflow tool in the industry. By the end of the decade, we’ll double the pace at which new medicines get to market by doubling the output of trial site teams. To date, we were named a Deloitte Fast 50 business, G2 Category Leader, an Inc. & AJC best place to work, and an Inc. 5000 company five years in a row. 

At Florence, we are committed to make the world a better place by accelerating research while providing an environment for our employees where they can be happy in their lives, enjoy their jobs, and grow. 

What You’ll Bring to The Team:

Reporting directly to the Sr. Director of Finance & BI, the Business Intelligence Specialist candidate will partner with business leaders to implement and unlock business insights across Sales, Marketing, Finance, and Customer Success.  This position will be a fit for a candidate looking for exposure to various business functions and their leaders, using curiosity to experiment with data, and make an impact on the executive decision-making process within the first year.

You Will:

 Data Architecture (Technical Skills)

• Data Management: Design, optimize, and maintain robust data models (Snowflake schemas) within the data warehouse environment.
• Data ETL: Develop, test, and implement ETL/ELT processes to integrate data from disparate sources (cloud platforms, databases, APIs, semantic layer) into the BI environment, ensuring data quality and integrity.
• BI Platform: Serve as the subject matter expert for core BI tools (Tableau), developing advanced calculated fields using languages like DAX.
• Querying & Scripting: Write SQL queries and develop scripts in Python/R for advanced data manipulation and statistical analysis.
• Enterprise Architecture: Support the enterprise architecture program, identifying and fixing data discrepancies across systems.

Analytics & Insights (Business Acumen)

• Data Strategy: Partner with business leaders to translate strategic objectives and information needs into measurable KPIs.
• Storytelling: Create and present compelling reports/dashboards that visually communicate complex findings and actionable recommendations.
• Analysis: Conduct deep-dive statistical and descriptive analysis to identify trends, anomalies, and opportunities for business improvement.
• Discovery: Lead discovery sessions with stakeholders across finance, operations, and marketing to elicit, document, and prioritize business requirements for new BI solutions.

Collaboration & Leadership (Soft Skills)

• Project Management: Manage the full lifecycle of BI projects, ensuring timely delivery and quality control from requirement definition through deployment.
• Coaching/Team Management: Provide guidance and mentorship to junior analysts on best practices and data standards.
• Process Improvement: Champion data governance best practices and seek opportunities to improve data quality and reporting efficiency.

An Ideal Candidate Has:

• Minimum of 5 years in Business Intelligence and Data Analysis roles, with a problem-solving mindset and strong drive 
• Expert-level proficiency in writing/optimizing SQL queries as well as familiarity navigating/structuring data including Salesforce, Snowflake and semantic layers (dbt, Fivetran)
• Mastery of at least one major BI visualization platform (Power BI / Tableau / Looker), including report design, dashboard development, and understanding the visual flow and progressive disclosure concepts.
• Strong practical experience in dimensional modeling techniques (snowflake schemas, star schema, fact constellations) and implementing data governance principles (ownership, quality, integrity, transparency, accessibility).
• Proven ability to engage with business stakeholders, gather non-technical requirements and translate them directly into technical data solutions and KPIs.
• Excellent verbal and written communication skills with experience presenting analytical findings to management and non-technical teams.

We’ll Be Extra Excited If You Have:

• Data architecture, ETL, visualization certifications 
• Data consulting experience 
• Tech/Pharma/SaaS experience
• Familiarity with HubSpot, Gainsight, NetSuite 

What’s in it for you?

• Do well. We offer a competitive compensation package, medical and dental insurance, and office space in the heart of the city.
• Do good. We insist that health technology is the highest calling for software development. We pride ourselves on working on something bigger than ourselves; helping advance cures and therapies.
• Make the leap. Join our high-output culture to create innovative, modern, and purposeful software solutions.

Florence supports workplace diversity and does not discriminate on the basis of race, color, religion, gender identity or expression, national origin, age, military service eligibility, veteran status, sexual orientation, marital status, physical disability, or any other protected class.

Please be cautious of potential recruitment fraud. If you are interested in exploring opportunities at Florence Healthcare, please go directly to our Careers Page. Florence Healthcare will never ask you to pay a fee or download software as part of the interview process with our company. In addition, Florence Healthcare will not ask for your personal banking information until you have signed an offer of employment and completed onboarding paperwork that is provided by our People Operations team. All communications with Florence Healthcare employees will only be sent from @florencehc.com email addresses.