Data Engineer

Job Title: Data Engineer Location: Cincinnati OH Duration: Contract - 13 months Pay Range: $55/hr to $60/hr (W2) Job ID: 411854 About BCforward BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity. Job Description We are seeking a Data Engineer to join our dynamic team. The ideal candidate will have strong experience in Snowflake, dbt, SQL, and modern data engineering practices and a proven ability to translate business problems into implementable, production-ready data solutions across the full delivery lifecycle. Responsibilities: * Partner with business and technical stakeholders to convert business problems into clear technical requirements and data solutions. * Analyze business processes, source data, existing system behavior, and downstream usage to define underlying technical problems. * Design, build, test, deploy, and support production data pipelines using Snowflake, dbt, SQL, and approved enterprise technologies. * Refine high-level features into workable Agile stories with clear technical requirements and acceptance criteria. * Participate in Agile planning, backlog refinement, estimation, design discussions, sprint execution, and retrospectives. * Develop scalable and reusable data models, transformations, and integration patterns. * Support analysis and modernization of legacy ETL and file-based data flows, including integrations with QRM and Oracle OFSAA/FTPCS. * Implement data testing, reconciliation, monitoring, alerting, and exception-handling controls. * Design reliable processing that supports reruns, source corrections, backfills, and recovery from production failures. * Integrate data pipelines with databases, schedulers, APIs, files, and vendor applications. * Use approved AI-assisted development tools to improve analysis, coding, testing, troubleshooting, and documentation while validating generated output. * Participate in the shared production-support rotation and assist with critical data-processing incidents. * Troubleshoot production issues, perform root-cause analysis, and implement sustainable corrections. * Maintain technical designs, source-to-target mappings, data-flow documentation, runbooks, and troubleshooting procedures. * Identify opportunities to simplify processing, automate recurring activities, and improve operational stability. Required Skills & Qualifications: * Hands-on experience with Snowflake, dbt, and SQL. * Experience designing, implementing, and supporting production data flows. * Proven ability to translate business problems into technical requirements and implementable solutions. * Experience working through ambiguous, incomplete, or evolving requirements within an Agile team. * Data modeling, testing, reconciliation, and production troubleshooting experience. * Understanding of reruns, backfills, failure recovery, and operational supportability. * Experience with Git-based development and code reviews.