Overview
Skills
Job Details
Big Data/Data Warehouse Engineer Consultant
No 3rd parties, please.
Local candidates only
Location: Columbus, OH (Onsite 5 days/week)
Schedule: M F, 8:00 AM 5:00 PM EST
Interview: Video
We are seeking a Technical Specialist to design, develop, migrate, and maintain enterprise data warehouse and Big Data solutions. This role involves building data marts, integrating data from multiple sources, and supporting large-scale analytics initiatives. You will work closely with data governance, analytics, and IT operations teams to deliver robust ETL/ELT pipelines, optimize performance, and ensure data quality.
Key Responsibilities
Design, develop, and maintain Hadoop/Hive/Impala data ingestion and ETL/ELT processes.
Create PySpark, Sqoop, and StreamSets jobs for data migration and analytics.
Model and manage STAGE/ODS/Data Warehouse tables.
Perform data analysis, profiling, and quality checks.
Optimize query and job performance; implement reusable frameworks.
Manage deployments, runbooks, and technical documentation.
Required Skills
8+ years in Big Data/Data Warehousing with Hadoop, Hive, Impala, Spark, Sqoop, PySpark, and related tools.
Strong SQL (Oracle & Hadoop) with performance tuning experience.
Proficiency in Unix/Linux scripting.
Experience with PHI/PII data handling and data security.
Familiarity with Agile and Waterfall project methods.