Lead Data Engineer - Columbus, OH - Information Technology - Analysts

Job Description We’re Looking for a Lead Data Engineer - Columbus, OH Position type: Contract to Hire Duration: 6+ Months Lead Data engineer - comparable to 603 experience level Must have: python java ETL pipeline AWS AI Tool experience Job responsibilities Executes creative software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or breakdown technical problems Drives team adoption of enterprise-authorized AI-assisted engineering practices within the work environment to improve code quality, delivery speed, and operational outcomes (e.g., AI-assisted code review/refactoring, test strategy acceleration, incident/root-cause analysis support), while establishing consistent validation standards (secure coding, peer review, automated testing) and promoting reuse of effective patterns across the team. Applies knowledge of tools within the Software Development Life Cycle toolchain, including enterprise-authorized AI-assisted development and automation capabilities, to improve the value realized by automation Lead architecture and hands‑on delivery of large-scale data pipelines (ETL/ELT) covering ingestion, transformation, validation, reconciliation, and publishing across curated layers Design and operationalize data lake patterns, including partitioning strategies, data quality controls, lineage, governance, and reusable datasets/data products Build and optimize distributed processing workloads using Apache Spark and modern storage/file formats (e.g., Parquet, Avro) Drive performance tuning across compute and storage (e.g., Spark tuning: shuffle, joins, caching, skew handling; and warehouse tuning where applicable) Implement engineering best practices: code quality, automated testing, CI/CD, observability (metrics/logs/traces), security-by-design, and operational readiness Build and maintain Java‑based services and components that support data workflows (e.g., ingestion services, orchestration helpers, APIs, data access layers) Develop REST APIs and integration components to enable downstream consumption and platform interoperability Apply modern application engineering practices (clean architecture, SOLID principles, test automation, and secure coding practices) Required qualifications, capabilities, and skills Formal training or certification on software engineering concepts and 5+ years applied experience Demonstrated experience leading effective use of approved AI‑assisted software development tools (e.g., for coding, code review, test acceleration, troubleshooting) with the ability to set team expectations for validating AI outputs for correctness, performance, and security. Strong understanding of responsible AI use in engineering workflows, including data sensitivity considerations, secure handling of inputs/outputs, and adherence to resiliency and security expectations; experience coaching engineers on safe, compliant adoption within delivery practices 10+ years of software engineering experience, with strong depth in data engineering/big data platforms Strong hands‑on development experience in Java plus proficiency in at least one data‑focused language such as Python Proven experience designing and building robust ETL/ELT pipelines and data integration frameworks Strong experience with Apache Spark and distributed processing concepts (fault tolerance, partitioning, performance tuning) Strong understanding of data storage serialization and formats such as Parquet and Avro Solid knowledge of data lake/lakehouse concepts and patterns (e.g., Medallion architecture), including data quality, metadata, and governance considerations Experience working with cloud data warehouses such as Snowflake (loading/unloading patterns, performance basics) or equivalent Ability to lead technical discussions, communicate clearly to varied stakeholders, and drive delivery in cross‑functional environments Preferred qualifications, capabilities, and skills Experience with orchestration and workflow scheduling tools (e.g., Airflow, Dagster, Control‑M, etc.) Exposure to streaming/event‑driven processing (e.g., Kafka, Spark Structured Streaming) and incremental processing patterns (CDC, upserts) Experience with table formats / ACID layers (e.g., Delta Lake, Apache Iceberg, Hudi). Strong production operations mindset (on‑call practices, SLAs/SLOs, observability, incident response). Experience in regulated environments (risk, audit, compliance, privacy, PII handling). Experience with cost optimization / FinOps practices for data platforms. Experience with working with Agentic AI / Gen AI solutions and capabilities will be an added advantage. Pay Range and Benefits Pay Range*: $ 60/Hr. *Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc. Medical & pharmacy coverage Dental/vision insurance 401(k) Health saving account (HSA) and Flexible spending account (FSA) Life Insurance Pet Insurance Short term and Long term Disability Accident & Critical illness coverage Pre-paid legal & ID theft protection Sick time, and other types of paid leaves (as required by law) Employee Assistance Program (EAP) About Innova Solutions Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields. Recent Recognitions Named One of America’s Best Employers for New Grads by Forbes (2024) Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025) One of the Largest IT Staffing Firms in the US – Ranked #3 by Staffing Industry Analysts (SIA, 2024) One of the Largest Staffing Firms in the US – Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics) Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023) One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024) AWS Advanced Tier Services Partner with 100+ certifications Equal Opportunity Statement Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at View email address on click.appcast.io or View phone number on click.appcast.io. Please indicate the specifics of the assistance needed. Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b. The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Innova Solutions and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - innovasolutions . Thank You! Team Innova Solutions #J-18808-Ljbffr MassGenics, Inc.