Apply on Employer Site

Cypress HCM · 1 day ago

Sr. Data Engineer

Cincinnati, OH

Contract

Onsite

Senior Level

$60/hr - $80/hr

5+ years exp

Cypress HCM is seeking an experienced and strategic Sr. Data Engineer to architect, implement, and optimize reliable data pipelines and models. This role involves leading efforts across technical and business teams to ensure data accuracy and governance while delivering scalable solutions that enhance insights and system performance.

Human ResourcesInformation TechnologyStaffing Agency

Growth Opportunities

Responsibilities

Architect, implement, and optimize data pipelines using Fivetran, Airflow (via Astronomer), and AWS to support both analytical and operational workloads

Design complex dbt transformations and Snowflake models for performance, reliability, and scalability

Integrate structured and semi-structured source data from multiple systems

Define and promote internal data governance standards, emphasize rigorous testing and adhere to data quality and engineering best practices

Develop and maintain documentation, including data dictionaries, data flow diagrams, best practices, and data recovery processes to provide clear visibility into the data ecosystem

Lead the collaboration with analytics and visualization engineers to ensure data models align with business logic and reporting needs

Participate in code reviews, testing, and CI/CD workflows using Git and containerized environments such as Docker and drive best practices in these processes

Continuously identify opportunities to improve data quality, automation, and observability

Mentor junior engineers and provide guidance on technical design, coding standards, and adoption of emerging technologies

Participate in cross-functional and business discussions to understand how cleaned and transformed data is used by the business, ensuring alignment with business goals

Qualification

Data engineeringSQLPythonSnowflakeDbtAirflowAWSFivetranDockerData modelingCI/CD workflowsUnstructured dataAnalytical skillsCommunication skillsProblem-solvingAdaptability

Required

5+ years of experience in data engineering, building and scaling modern data pipelines and models

Advanced proficiency in SQL and Python for data transformation, automation, and performance tuning

Deep hands-on experience with Snowflake, dbt, and orchestration tools like Airflow

Strong knowledge with Fivetran, AWS, and Docker

Strong understanding of data modeling, warehousing, and CI/CD workflows

Clear written and verbal communication skills, including the ability to document and present technical work effectively to engineering teams and business stakeholders

Experience with unstructured data (JSON, Parquet, Avro)

Exposure to containerization and infrastructure-as-code concepts

Commitment to data governance, documentation, and data quality

Ownership mindset and accountability for delivering reliable solutions

Strong analytical and problem-solving abilities with attention to detail

Adaptable and proactive learner in a fast-evolving technical environment

Effective communicator with both technical and non-technical stakeholders