Data Engineer: Build Scalable Pipelines for Impact

Livefront; Northern (KY); Hybrid; USD 120,000 - 145,000; Full time

Job summary

Livefront is seeking an outstanding Data Engineer to join Zeal, a data-driven AI-enabled software consultancy. This role supports data migration, pipeline design, and governance across key U.S. hubs such as Dallas, Houston, Atlanta, Chicago, Minneapolis, Denver, and Portland.

You will build scalable data pipelines, collaborate with stakeholders, and ensure data quality and security while leveraging AI tools to boost productivity in a consulting environment.

Qualifications

• Strong SQL skills with attention to performance.
• 1+ year OLTP experience on traditional databases.
• 1+ year MPP data platform experience (Databricks, Snowflake, etc.).
• Familiarity with cloud platforms and security basics.
• Experience with at least one data transformation tool or cloud-native tools.
• Understanding of Medallion data architectures.
• Basic orchestration, source control and CI/CD skills.
• Effective written and verbal communication.
• Ability to leverage AI tools to boost productivity.
• Data modeling experience on modern platforms.
• Experience with queuing and event-driven systems.
• Data visualization experience (Power BI, Tableau, etc.).
• ELT experience on Snowflake or Databricks.
• Testing methodologies and tools.

Responsibilities

• Gather and understand requirements for data migration and transformation.
• Build and maintain performant, resilient data pipelines.
• Collaborate with stakeholders to meet project standards.
• Design and implement data architectures with appropriate tools.
• Manage pipelines through review and deployment, including CI/CD.
• Monitor pipelines to ensure they meet requirements.
• Troubleshoot pipelines to maintain stability.
• Document knowledge within the project team.
• Understand business and technical context to add value.
• Engage in meetings to build broader context.
• Provide feedback to architecture teams for improvements.
• Ensure data quality, integrity, and availability with upstream/downstream systems.
• Contribute to data governance and best practices.

Skills

SQL

OLTP

MPP

Cloud familiarity

Data transformation

Data architecture

DevOps basics

Communication

AI productivity tools

Data modeling

Queuing & events

Visualization tools

ELT on Snowflake/Databricks

Testing

Tools

Databricks

Snowflake

Azure Synapse

Redshift

BigQuery

Airflow

Git

CI/CD

Job description

Livefront is seeking an outstanding Data Engineer to join Zeal, a data-driven AI-enabled software consultancy. This role supports data migration, pipeline design, and governance across key U.S. hubs such as Dallas, Houston, Atlanta, Chicago, Minneapolis, Denver, and Portland.

You will build scalable data pipelines, collaborate with stakeholders, and ensure data quality and security while leveraging AI tools to boost productivity in a consulting environment.