Job Title: Lead Data Engineer - Advanced Location: Columbus, OH Duration: Contract to hire, 6+ months Pay Range: $75.00/hr - $82.00/hr (W2) 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 Lead Data Engineer to join our team. The ideal candidate will have strong experience in Java, Python, AWS, Apache Spark, and large-scale ETL/ELT data engineering and a proven ability to design and deliver high-quality data platforms, optimize performance, and lead AI-assisted engineering adoption. Responsibilities: * Execute creative software solutions, including design, development, and technical troubleshooting for complex data challenges. * Drive team adoption of enterprise-authorized AI-assisted engineering practices and establish validation standards including secure coding, peer review, and automated testing. * Apply SDLC toolchain and automation, including AI-assisted development capabilities, to increase delivery value. * Lead architecture and hands-on delivery of large-scale ETL/ELT pipelines across ingestion, transformation, validation, reconciliation, and publishing. * Design and operationalize data lake patterns including partitioning, data quality controls, lineage, governance, and reusable datasets. * Build and optimize distributed processing workloads using Apache Spark and modern formats such as Parquet and Avro. * Drive performance tuning across compute and storage, including Spark tuning for shuffle, joins, caching, and skew handling. * Implement engineering best practices including code quality, automated testing, CI/CD, observability, security-by-design, and operational readiness. * Build and maintain Java-based services supporting data workflows, including ingestion services, orchestration helpers, APIs, and data access layers. * Develop REST APIs and integration components to enable downstream consumption and platform interoperability. * Apply modern application practices including clean architecture, SOLID principles, test automation, and secure coding. Required Skills & Qualifications: * Formal training or certification in software engineering and 5+ years of applied experience. * 10+ years of software engineering experience with depth in data engineering and big data platforms. * Strong hands-on development experience in Java and proficiency in Python. * Proven experience designing and building robust ETL/ELT pipelines and data integration frameworks. * Strong experience with Apache Spark, distributed processing concepts, and performance tuning. * Knowledge of data storage serialization and formats such as Parquet and Avro. * Solid understanding of data lake and lakehouse concepts, including data quality, metadata, and governance. * Experience with cloud data warehouses such as Snowflake or equivalent. * Demonstrated experience leading responsible use of AI-assisted development tools and setting validation standards for correctness, performance, and security.