Remote Data Engineer - ETL/BI for Enterprise Analytics

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

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.