Data Engineer [Zeal]

Livefront

3d•$120,000 - $145,000•Hybrid

About The Position

Zeal is an AI-enabled software consultancy purpose-built for Fortune 1000 companies, and we’re now part of Livefront. We help companies navigate technology to drive business outcomes by attracting, retaining, and growing exceptional talent and empowering them to use innovative technologies and process frameworks. We’re a values-driven technology company grounded in kindness, generosity, and integrity. Our mission is to build a place where our employees love their future and where clients trust us to deliver what we promise: to improve their business through technology. Love your future. We’re looking for an outstanding Data Engineer to join our team. This role is available across our primary U.S. hubs: Dallas, Houston, Atlanta, Chicago, Minneapolis, Denver, and Portland.

Requirements

Solid foundation in data engineering and a keen interest in consulting.
SQL: Strong SQL skills - including an understanding of performance and parallelism.
OLTP Experience: At least one year of material experience on a traditional OLTP database (Oracle, SQL Server, Postgres, etc.).
MPP Experience: At least one year of material experience on a modern, MPP, data platform (Databricks, Snowflake, Azure Synapse, Redshift, BigQuery).
Cloud Familiarity: Familiarity with cloud platforms including the basics of storage and security.
Transformation Tools: Material experience with at least one data transformation tool (Fivetran, Informatica, DataStage, dbt, or the native tools of one of the data platforms) or the native transformation tools of the cloud providers.
Data Architecture: A basic understanding of Medallion data architectures.
DevOps Basics: Basic skills with orchestration (Airflow, etc.), source code control (git) and CI/CD.
Communication: Effective writing and communication skills.
AI Proficiency: The ability to use AI tools to improve productivity.

Nice To Haves

Data modeling experience on modern data platforms.
Python proficiency.
Experience with queuing and event-driven distribution systems (Kafka, RabbitMQ, native tools of cloud platforms).
Data presentation and visualization tools (Power BI, Tableau, etc.).
Specific experience with ELT on Snowflake or Databricks.
Experience with testing methodologies and tools.

Responsibilities

Gather and understand requirements for data migration and transformation.
Design, build, and maintain performant, resilient, and maintainable data pipelines that meet the business requirements.
Collaborate with stakeholders to ensure that designs and implementations meet requirements and project standards while fulfilling the business needs, providing feedback and proposals for alternative implementations where appropriate.
Implement the required data architectures and designs using the appropriate tools and in a manner that is performant, effective, efficient, and maintainable.
Shepherd the pipelines through the review and deployment process to ensure a proper implementation in production (testing, version control, and CI/CD).
Monitor new and existing pipelines to ensure that they are meeting requirements and expectations.
Troubleshoot and remediate new and existing pipelines to ensure continued stability and effectiveness.
Document and transfer knowledge as required and appropriate within the project team.
Maintain awareness and understanding of the business and technical requirements and the larger project in order to provide value beyond your specific responsibilities.
Actively engage in project meetings and discussions to build context beyond your immediate tasks.
Provide input and feedback to the architecture teams on the designs with an eye towards improvement.
Ensure data quality, integrity, and availability with upstream and downstream systems.
Contribute to data governance and best practices for data management.