Senior Data Engineer: Enterprise Pipelines & DataOps

TM Floyd & Company (TMF); Richmond (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

TM Floyd & Company in Richmond, VA seeks a highly experienced Senior Data Engineer to support a large-scale enterprise data environment. You will build robust ETL/ELT pipelines, develop scalable batch and streaming solutions, and optimize high-volume data processing using SQL-centric approaches.

The ideal candidate has 5-7+ years of data engineering, strong SQL and ELT skills, and hands-on experience with Oracle Exadata, Snowflake, Talend, dbt, or Informatica, plus DataOps and observability

Qualifications

• 5-7+ years of Data Engineering experience.
• Advanced SQL and ELT expertise.
• Experience with Oracle Exadata, Snowflake, or similar data warehouses.
• Hands-on with ETL/ELT platforms such as Talend, dbt, or Informatica.
• Knowledge of dimensional modeling and data governance.

Responsibilities

• Build and support enterprise-scale ETL/ELT data pipelines.
• Develop scalable batch and incremental processing solutions.
• Design and optimize high-volume SQL-centric data pipelines.
• Implement reliable error handling, restartability, monitoring, and alerting.
• Develop streaming pipelines using Kafka, Kinesis, Spark Streaming, or similar.
• Perform data cleansing, validation, reconciliation, and enrichment.
• Optimize warehouse performance via indexing, partitioning, and query tuning.
• Support data quality investigations and root-cause analysis.
• Implement DataOps, CI/CD, observability, governance, lineage, and auditability.
• Partner with architects, infrastructure, application, and governance teams.
• Translate complex requirements into practical solutions.
• Participate in design and code reviews.
• Troubleshoot production issues to improve reliability and cost.

Skills

SQL/ELT

Oracle Exadata

Snowflake

ETL/ELT tools

Dimensional modeling

Python scripting

DataOps/CI/CD

Data quality

5-7+ yrs exp

Kafka/Spark

Tools

Talend

dbt

Informatica

Job description

TM Floyd & Company in Richmond, VA seeks a highly experienced Senior Data Engineer to support a large-scale enterprise data environment. You will build robust ETL/ELT pipelines, develop scalable batch and streaming solutions, and optimize high-volume data processing using SQL-centric approaches.

The ideal candidate has 5-7+ years of data engineering, strong SQL and ELT skills, and hands-on experience with Oracle Exadata, Snowflake, Talend, dbt, or Informatica, plus DataOps and observability