Sr. Data Engineer

Florence software advances cures by helping the world’s most important research sites do their best work. Our solutions are now used by over 65,000 research teams in 90 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:

Lead the design and delivery of large, cross-functional data engineering initiatives. Build scalable, reliable, secure, and well-governed data solutions that support analytics, reporting, business applications, and emerging AI/ML use cases.

You Will:

• Lead the design and implementation of scalable batch and real-time data pipelines.
• Define and enforce standards for data modeling, reliability, testing, documentation, observability, security, and governance.
• Drive root-cause analysis, performance optimization, and remediation of systemic data and platform issues.
• Partner with product, engineering, analytics, data science, and business leaders on roadmap and prioritization.
• Engineer scalable data pipelines and data models across PostgreSQL, MongoDB, Snowflake, and AWS using modern ETL/ELT and DataOps practices.
• Develop and maintain transformation workflows using dbt , including reusable models, testing, documentation, and lineage.
• Design and support real-time and event-driven data pipelines using Kafka and related streaming technologies.
• Implement data integration and Master Data Management (MDM) practices to improve data consistency, quality, governance, and integrity across enterprise systems.
• Build curated datasets and semantic layers that support analytics and business intelligence platforms such as Amazon QuickSight and Tableau .
• Develop data solutions that support machine learning, AI, and Generative AI use cases, including preparation of structured and unstructured data.
• Support RAG and LLM-based applications through data ingestion, transformation, enrichment, embeddings, vector search, and retrieval pipelines.
• Apply data quality, lineage, security, governance, and access-control practices to data used across analytics and AI/ML applications.
• Leverage AI-assisted development tools such as Claude Code, Cursor, GitHub Copilot , or equivalent to improve engineering productivity, testing, documentation, and code quality.
• Mentor engineers across multiple levels and contribute to technical strategy, architecture reviews, code reviews, and engineering best practices.

An Ideal Candidate is/has:

Experience

• 5+ years relevant experience
• A bachelor’s or master’s degree in computer science, data science, information science or related field, or equivalent work experience
• Deep, hands‑on expertise in data engineering, cloud data platforms, data integration, and data modeling, with practical experience supporting analytics and AI/ML use cases.
• PostgreSQL / SQL: Advanced SQL development, query optimization, indexing, performance tuning, backup, recovery, and security.
• MongoDB: NoSQL data modeling, query optimization, indexing, performance, and administration concepts.
• Snowflake: Data warehousing, performance optimization, scalable data processing, security, and cost optimization.
• dbt: ELT transformation frameworks, modular data models, testing, documentation, lineage, and CI/CD integration.
• ETL/ELT: Design, development, optimization, monitoring, and troubleshooting of enterprise data pipelines.
• Data Modeling: Dimensional, analytical, transactional, and normalized data models.
• Master Data Management (MDM): Data standardization, master/reference data, data quality, governance, and enterprise data integration.
• Data Quality & Governance: Data validation, integrity, lineage, metadata, observability, and governance.
• Workflow & Orchestration: Airflow or equivalent workflow orchestration technologies.
• Streaming: Kafka and event-driven data processing.

Hands‑on experience with the AWS ecosystem and cloud-native data engineering, including relevant services such as:

• Amazon S3
• Amazon MSK / Kafka
• AWS Lambda
• Amazon RDS
• Amazon Aurora
• AWS IAM
• Amazon QuickSight

Ability to design secure, scalable, highly available, and cost-effective cloud data solutions using AWS services.

• Experience preparing and serving trusted, governed datasets for BI and analytics.
• Amazon QuickSight — dashboards, datasets, data preparation, and analytics.
• Tableau — dashboards, reporting, data sources, and analytical data models.
• Strong understanding of the relationship between data engineering, semantic models, BI, and business reporting requirements.

AI/ML & Generative AI — Working Experience

• Practical experience preparing and managing data for machine learning and AI applications .
• Understanding of data preparation, transformation, feature engineering, and training datasets.
• Familiarity with LLM data pipelines and the role of data engineering in supporting LLM-based applications.
• Understanding of AI/ML data governance concepts, including data quality, lineage, privacy, security, and access controls.
• Experience using AI-assisted development tools such as Claude Code, Cursor, GitHub Copilot, or equivalent.
• Ability to collaborate effectively with data scientists, ML engineers, and application engineers on AI/ML data requirements.
• Exposure to RAG and LLM-based applications
• DataOps and CI/CD practices for data pipelines and transformations.
• Automated data testing and quality validation.
• Git-based development and code review practices.
• Infrastructure as Code using Terraform .
• Monitoring, observability, logging, alerting, and production support.
• Strong documentation and engineering compliance practices.

Core Strengths

• Communication — Advanced
• Ownership — Advanced
• Accountability — Advanced
• Technical Leadership
• Problem Solving
• Cross-functional Collaboration

Bonus Points if you have:

• AWS, Snowflake, MongoDB, PostgreSQL, or dbt certifications
• Experience with Databricks, Spark, Delta Lake, or other lakehouse technologies
• Experience with advanced Kafka/event-streaming architectures
• Experience with vector databases and vector search
• Exposure to MLOps and machine learning data pipelines
• Experience with AWS AI/ML services such as Amazon Bedrock or SageMaker
• Experience with data observability platforms
• Experience implementing enterprise data governance and MDM solutions
• Experience supporting large-scale enterprise analytics and BI environments

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.

As set forth in Florence Healthcare - US’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service‑connected disability.

A "recently separated veteran" means any veteran during the three‑year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.