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

MassGenics, Inc.; Columbus (OH); On-site; USD 68,000 - 97,000; Full time

Benefits offered by this job

Medical coverage

Dental/vision insurance

401(k)

Job summary

Innova Solutions seeks a Lead Data Engineer in Columbus, OH, to architect and deliver large-scale data pipelines (ETL/ELT) and to drive AI-assisted engineering practices across the team.

The role focuses on building distributed processing with Spark, Parquet/AVRO formats, and secure CI/CD, with strong collaboration across stakeholders and cross-functional teams. A strong foundation in Java and Python is required.

Qualifications

• 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.
• Strong understanding of responsible AI use in engineering workflows, including data sensitivity considerations and secure handling.

Responsibilities

• Lead architecture and hands-on delivery of large-scale data pipelines (ETL/ELT).
• Drive AI-assisted engineering practices to improve code quality and delivery speed.
• Build REST APIs and data access layers to enable platform interoperability.

Skills

Python

Java

ETL pipelines

AWS

AI-assisted tooling

Tools

Spark

Parquet

Avro

Job description

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 [e-mail] or [phone]. 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