Data Engineer

Cypress HCM; Cincinnati (OH); Hybrid; USD 55,104 - 64,747; Full time

Job summary

Cypress HCM in Cincinnati, OH is seeking a seasoned Data Engineer/BI Developer for a 6-month contract-to-hire engagement. The role focuses on building scalable data pipelines using Python, SQL, DBT, and Snowflake to support enterprise reporting and analytics.

Responsibilities include ETL/ELT design, data modeling, data quality, and transitioning BI dashboards from Cognos to Power BI while ensuring data governance and lineage. Remote flexibility is offered with on-site Cincinnati base.

Qualifications

• 3+ years of Data Engineering and BI experience.
• Hands-on Python, SQL, DBT and data integration tools.
• Experience with Snowflake data warehousing and scalable pipelines.
• Familiar with CI/CD practices and SDLC methodologies.
• Experience working in agile teams.
• Experience with reporting and BI solutions.

Responsibilities

• Design, develop, and maintain ETL/ELT processes for enterprise reporting and analytics.
• Consolidate and transform data from multiple sources into business-ready datasets.
• Design table structures and ETL/ELT for scalable data solutions.
• Develop automated validation, reconciliation, and monitoring for data integrity.
• Implement auditing, balancing, and control mechanisms in data workflows.
• Perform data analysis, root cause investigations, and ad hoc reporting.
• Contribute to solution architecture and enterprise data initiatives.
• Collaborate with DBAs, data architects, and tech teams to resolve issues.
• Support development of reporting/analytics apps with proper data structures.
• Promote data governance, metadata management, and quality assurance.
• Helping transition BI dashboards from Cognos to Power BI and create data lineage.

Skills

Python

SQL

DBT

ETL/ELT

Snowflake

Data Warehousing

Git

CI/CD

Power BI

Cognos

Tools

Visual Studio Code

Git-based source control

Job description

6-Month Contract-to-Hire

Location: Cincinnati, OH (remote flexibility)

Pay: $40 - $47/hr (Compensation can vary depending on experience)

General Overview

We are seeking an experienced developer focused on delivering scalable, high-quality data solutions. This individual will play a key role in designing, building, and optimizing data pipelines that support reporting, analytics, and enterprise decision-making. As the Business Intelligence and Data Management team continues to modernize its data ecosystem, this role will help drive the adoption of contemporary data engineering practices and modern tooling including DBT, Python, and SQL.

Responsibilities

• Design, develop, and maintain efficient ETL/ELT processes to support enterprise reporting and analytics needs.
• Consolidate and transform data from a variety of internal and external sources into business ready datasets.
• Design table structures and ETL/ELT to build scalable performance data solutions.
• Develop automated validation, reconciliation, and monitoring processes to ensure data integrity and accuracy.
• Implement auditing, balancing, and control mechanisms within data workflows.
• Perform data analysis, root cause investigations, and complex ad hoc reporting as needed.
• Contribute to solution architecture discussions and help guide the design and implementation of enterprise data initiatives.
• Collaborate with database administrators, data architects, and technical teams to resolve issues and improve system performance.
• Collaborate with database administrators, data architects, and technical teams to resolve issues and improve system performance.
• Support the development of reporting and analytics applications by ensuring appropriate data structures and source availability.
• Promote adherence to data governance, metadata management, and quality assurance standards.
• Helping transition BI dashboards (currently moving from IBM’s Cognos to Microsoft Power BI) and creating quality scorecards and data lineage.

Requirements

• 3+ years of Data Engineering and Business Intelligence experience.
• Demonstrated experience designing and implementing enterprise ETL/ELT solutions.
• Hands on Python, SQL, DBT, and related data integration tools.
• Knowledge of CI/CD practices and software development lifecycle methodologies.
• Experience utilizing Git-based source control platforms for collaborative development, code management, and peer review processes.
• Proficiency with modern development environments and debugging tools.
• Proficiency in using Visual Studio Code as a development environment, including debugging tool to streamline coding workflows.
• Experience with Snowflake for scalable data warehousing, including designing and optimizing data pipelines and leveraging its features for performance and security.
• Hands on experience distilling business requirements into data warehouse design artifacts such as Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models.
• Understanding of BI dashboards (IBM Cognos, Microsoft Power BI); experience creating data quality scorecards and data lineage.
• Extensive experience with agile teams.
• Assist and mentor development team in design and development of BI solutions.
• Create visual models to enable collective understanding of processes, data flow, and user interactions.
• Reporting application support experience.
• Experience architecting small, medium, and enterprise-scale solutions.
• P&C Insurance background strongly preferred.