Waterfall Relational Database SQL Database Hadoop Cloudera Management Pyspark Hive   Requirement id 118677 Job title Architect Job location in Columbus, OH Skills required Data Analysis, Waterfall, Agile Methodologies, Relational Database SQL Database Hadoop Open Date 19-Aug-2021 Close Date Job type Contract Duration 10 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: Data Analysis, Waterfall, Agile Methodologies, Relational Database SQL Database Hadoop Responsibilities: Our Client in Columbus, Ohio is seeking an experienced Senior Database Architect for a long-term contract role CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR RELOCATED BY DAY ONE FOR CONSIDERATION The Senior Database Architect will be responsible for Enterprise data warehouse design, development, implementation, migration, maintenance, and operational activities. The candidate will closely with Data Governance and Analytics team. Will be one of the key technical resource for data warehouse projects for various Enterprise data warehouse projects and building critical data marts, data ingestion to Big Data platform for data analytics and exchange with State and Medicaid partners. This position is a member of Department ITS and will work closely with the Business Intelligence & Data Analytics team. Detailed Day-To-Day Job Duties to be performed: • Participate in Team activities, Design discussions, Stand up meetings and planning Review with team. • Perform data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms. • Eliciting, analyzing and documenting functional and non-functional requirements. • Document business requirements, meeting minutes, and key decisions/actions. • Lead client meetings and sessions with data-driven analysis to clarify requirements and design decisions. • Perform data gap and impact analysis due to new data addition and existing data changes for any new business requirements and enhancements. • Follow the organization design standards document, create data mapping specification document, pseudo codes for the development team(s) and design documents. • Create logical & physical data models. • Review and understand existing business logic used in Oracle and Hadoop ETL platforms to verify against the business user needs. • Review PySpark programs that are used to ingest historical and incremental data. • Review SQOOP scripts to ingest historical data from Oracle database to Hadoop IOP, created HIVE tables and Impala view creation scripts for Dimension tables. • Assist Business Analyst to create Test Plan, Design Test scenarios, SQL scripts (prefer Oracle and Hadoop), test or mockup data, executes the test scripts. • Validate test results and records as well as log and research defects. • Analyze production data issues, report problems and find solutions to fix the issues, if any. • Create incidents and tickets to fix production issues, create Support Requests to deploy code for development team to UAT environment. • Participate in meetings to continuously upgrade the Functional and technical expertise. • Establish priorities & follow through on projects, paying close attention to detail with minimal supervision. • Create and present project plan, project status and other dashboards as necessary. • Perform other duties as assigned. REQUIRED Skill Sets: • 8+ years Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment. • Good knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design. • Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDLs and DMLs in Oracle, Hive and Impala (minimum of 8 years experience). • Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8-9 years experience in Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 118677 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Data Analysis job openings in Columbus, OH Jobs List FCDC Data Architect 1 (791670) Create date: 16-Jan-2026 Start date : 03/02/2026 End Date : 07/31/2026 Submission deadline : 02/01/2026 Client Info : FCDC Note: * FullTime, Onsite * Contractwith Possible Extension or Hire Description : The client is seeking a senior level Data Analyst to support reporting, analytics,.... (This job is for - Business Analyst Jobs in OH Columbus Architect - (in Columbus, OH)) INS-IT Consultant 1/ ITC1 (687972) Create date: 18-Jul-2022 Start date :08/01/2022 End Date :06/30/2023 Submission deadline :07/21/2022 Client Info :INS Description : Preferred Education College Degree Insurance is seeking a Data Analyst to join our IT Team. We are seeking someone who has Data warehouse experience with ETL data flows, .... (This job is for - Business Analyst Jobs in OH Columbus Consultant - (in Columbus, OH)) Sr. Business Analyst - 58537 Create date: 23-Aug-2021 Note: * Interview:Phone or video call Responsibilities: Our Client in Columbus, Ohio is seeking an experienced Sr. Business Analyst for a contract role CANDIDATES MUST BE LOCAL TO CENTRAL OHIO OR RELOCATED BY DAY ONE FOR CONSIDERATION Sr Business Analyst Job Duties to be performe.... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH)) Senior Database Architect 1/SDA1 - 83944 - SP Create date: 07-Apr-2021 start date:05/03/2021 End date:06/30/2021 submission deadline:4/12/2021 client info :MCD Note: * Interviews: Teams * Position location: remote start from Columbus. Must be able to pick up equipment day 1. * REPOST OF 79316 AND 83070 DO NOT RESUBMIT CANDIDAT.... (This job is for - job Jobs in OH Columbus Architect - (in Columbus, OH)) Senior Database Architect 1/SDA1 - 83070 - SP Create date: 10-Mar-2021 start date:3/29/2021 End date:06/30/2021 submission deadline: Monday 3/15 @ 10 am EST Note: * Interviews: Teams * Position location: remote start from Columbus. Must be able to pick up equipment day 1 Description: job Jobs in OH Columbus Architect - (in Columbus, OH))    Data Analysis job openings in other states Jobs List DBHDS - Data Governance Analyst (CDC Funded) (807900) Create date: 09-Sep-2026 Start date :10/05/2026 End Date :10/15/2027 Submission deadline :9/15/2026 Deadline to submit: By 4 pm EST on Tuesday 9/15 Client Info : DBHDS Note: * Work Arrangement: Hybrid * Agency Interview Type: Both Web Cam and In Person Interview Description: Wor.... (This job is for - datawarehouse Jobs in VA Richmond Analyst - (in Richmond, VA)) DCS - Sr. Oracle SQL Analyst (807268) Create date: 15-Jul-2026 Start date : 8/10/2026 End Date : 06/30/2027 Submission deadline : 7/27/2026 Client Info : DCS Note: *Agency Interview Type : In Person Only *Work Arrangement : Hybrid *ON-SITE INTERVIEWS ONLY! *Candidate MUST come ON-SITE Day 1 for Orientation and Equipment Pick up. The Clie.... (This job is for - Jobs in GA Atlanta Analyst - (in Atlanta, GA)) Business Intel Architect III - 159566 Create date: 05-Jun-2026 start date :07/13/2026 End Date : 06/30/2027 Submission deadline : 6/11/2026 at 4:00 PM CST. Client Info : DHS Note: * This position is remote, but work must be performed within the State of Wisconsin. Selected candidate will be required to be onsite in Madison, Wisconsin once a month. job Jobs in WI Madison Architect - (in Madison, WI)) VDH Business Analyst 3 (799036) Create date: 02-Apr-2026 Start date :4/6/2026 End Date :06/30/2026 Submission deadline :4/6/2026 Client Info : VDH Note: * Agency Interview Type: In Person Only * Work Arrangement:Hybrid Description: Seeking a detail-oriented and analytical Business Analyst to support the design, devel.... (This job is for - Business AnalystSDLC Jobs in VA Richmond Analyst - (in Richmond, VA)) System Data Analysis And Conversion (798514) Create date: 30-Mar-2026 Start date : 04/27/2026 End Date : 06/30/2027 Submission deadline : 04/03/2026 Client Info : DMAS Note: * Agency Interview Type : Both Web Cam and In Person Interview * ON SITE REQUIRED: 3 days onsite and 2 days remote. Parking is not provided for contractors Description: Mapping Jobs in VA Richmond Analyst - (in Richmond, VA))    Data Analysis job openings in OH Jobs List Data Engineer Level 2 - 63154 Create date: 11-May-2020 Candidate must be our W2 Employee. Candidate must be local : Yes We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens. Job Description : Data Engineer Level 2 - Position Summary Accountable for developing and delivering technological responses to targeted business outcomes. Analyze, de.... (This job is for - Architecture Jobs in OH BlueAsh Engineer - (in BLUE ASH, OH)) SCM Analyst - 56951 Create date: 18-Dec-2019 Note: * Candidate must be our W2 Employee. * This is a very entry level role, please do not submit senior level candidates. Job Description : Performs data analysis for assigned less complex spend categories, Collaborates with Sr. Level analyst on contract negotiations and project, meets with team to id.... (This job is for - job Jobs in OH Cleveland Analyst - (in Cleveland, OH)) GBT Mid Level Data Analyst - 54527 Create date: 23-Oct-2019 Note: * We should take signed RTR form from the candidate (Candidate RTR form should be only on the name of Apex Systems) Job Description : Position: GBT Data Entry Data Analyst x5 Length: Contract through 5/30/2020 Location: Beachwood, OH Shift: 8a-5p The Global Business .... (This job is for - Operation Jobs in OH Cleveland Analyst - (in Cleveland, OH)) Data Analyst Level 1 - 51181 Create date: 13-Aug-2019 Candidate must be our W2 Employee Description:* our client is seeking a Digital Analyst to work with one of our clients in the Greater Cincinnati area. Job requirements are below: Work cross-functionally to generate actionable channel performance reporting for targeted digital interactions for individuals and h.... (This job is for - ECommerce Jobs in OH Cincinnati Consultant - (in Cincinnati, OH)) Global Master Data - Configuration/Operations - 51165 Create date: 13-Aug-2019 We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description:* I have a client that is looking to bring on a Global Master Data candidate to join them on a contract to perm basis. This position will require onsite work in either Cincinnati, OH or Detroit, MI. The candidate in this role will part.... (This job is for - ERP Jobs in OH Cincinnati Consultant - (in Cincinnati, OH)) (Architect: Data Analysis, Waterfall, Agile Methodologies, Relational Database SQL Database Hadoop in Columbus, OH)

Featured Jobs APEX SOQL Architect (Jobs in Columbus, Ohio) JavaScript ASP. Consultant (Jobs in Cayce, South Carolina) Cybersecurity Threat Analyst (Jobs in Austin, Texas) Quality Assurance Jira Azure Analyst (Jobs in Lansing, Michigan) EHR Jira Windows Analyst (Jobs in Atlanta, Georgia) ITSM ServiceNow BMC Jira Developer (Jobs in Atlanta, Georgia) J2EE Curam Technical Developer (Jobs in Raleigh, North Carolina) Communication Quality Assurance Tourbleshooting Analyst (Jobs in Tallahass - - Consultant (Jobs in Tennessee, Tennessee) Migration Engineer (Jobs in Raleigh, North Carolina)