EngineerJobs.io
← Back to all jobs

Job Description

As a Data Engineer focused on ETL, this role supports the modernization of on-premises SQL Server data pipelines and the delivery of governed ODS and DWH solutions. The position includes building and refining ETL/ELT processes and developing Databricks-based pipelines as the platform transitions to corporate-managed capabilities.

Location

  • Jacksonville, FL (onsite)
  • Onsite requirement: Candidate must sit in the Jacksonville, FL office.

Education

  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Data Engineering, or a related field

Core Responsibilities

  • Assess, document, and rationalize existing SQL Server ETL pipelines, databases, and data silos.
  • Refactor redundant or fragile SQL processes into standardized, maintainable ETL/ELT pipelines.
  • Design and develop ingestion, transformation, and reconciliation pipelines for governed ODS and DWH environments.
  • Implement logging, monitoring, error handling, auditability, lineage, and repeatable deployment practices.
  • Develop Databricks notebooks and pipelines using SQL and, where appropriate, Python or PySpark.
  • Partner with corporate platform teams to align solutions with enterprise architecture, security, and engineering standards.
  • Support source-to-target mapping, testing, production support, and migration validation.
  • Perform other duties and/or projects as assigned.

Required Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Data Engineering, or a related field
  • Strong SQL and Microsoft SQL Server development experience
  • Hands-on experience designing, building, and supporting ETL/ELT pipelines
  • Knowledge of relational databases, data warehousing, and incremental data processing
  • Experience troubleshooting complex data issues and reconciling source-to-target results
  • Experience with source control and disciplined software development practices
  • Strong analytical, documentation, and communication skills

Technology Exposure

  • SQL, Microsoft SQL Server
  • Databricks, Python, PySpark
  • Apache Spark, ETL/ELT
  • ODS, DWH
  • Source control

Preferred Qualifications

  • Databricks, Python, PySpark, or Apache Spark experience
  • Experience migrating legacy ETL workloads to a cloud data platform
  • Dimensional modeling and data quality automation experience
  • Experience in a SOX-controlled or regulated environment
  • Property and casualty insurance industry knowledge (policy, billing, claims, or underwriting data)
  • Experience working with Guidewire applications or data, including Guidewire ClaimCenter (GWCC), Guidewire BillingCenter (GWBilling), or related policy systems
  • Experience engineering feature-ready datasets or pipelines for predictive analytics and machine learning
  • Familiarity with model lifecycle concepts, including experimentation, deployment, monitoring, and reproducibility
  • Exposure to generative AI, large language models (LLMs), retrieval-augmented generation (RAG), vector search, or AI-assisted data engineering

Sponsorship

Sponsorship not offered for this role.

Similar Jobs