Hadoop Analysis Design And Development Data Warehouse MapReduce PHIPII Visio BA De   Requirement id 114915 Job title Architect Job location in Columbus, OH Skills required Data Analysis, Waterfall, Agile, LEAN Methodologies, Relational Database, Hadoop Analysis Design And Development D Open Date 10-Mar-2021 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Data Analysis, Waterfall, Agile, LEAN Methodologies, Relational Database, Hadoop Analysis Design And Development D 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: The Data Architect will be responsible for Medicaid 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 Medicaid ITS and works closely with the Business Intelligence & Data Analytics team. Responsibilities: * KS Consultant Job Title: Data Architect 1 Detailed Day-To-Day Job Duties to be performed: Responsibilities: • 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. • Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (Hadoop, MapReduce, S   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114915 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 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 - 58521 Create date: 19-Aug-2021 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, impl.... (This job is for - Waterfall Jobs in OH Columbus Architect - (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)) Sr. Database Architect - 57840 Create date: 01-Mar-2021 Job industry: Public Sector and Government Responsibilities Our Client in Columbus, Ohio is seeking an experienced Sr. Database Architect for a contract role CANDIDATES MUST BE LOCAL TO OHIO FOR CONSIDERATION The Sr Database Architect will be responsible for Enterprise data warehouse design, deve.... (This job is for - Waterfall Jobs in OH Columbus Architect - (in Columbus, OH))    Data Analysis job openings in other states Jobs List VITA Market Research-Financial Analyst (728526) Create date: 29-Jan-2024 Hybrid start date :02/12/2024 End date :02/12/2025 submission deadline :2/1/2024 client info :VITA Description : *Local Richmond, VA candidates required for onsite work *Candidates must work onsite 3 days a week with 2 remote job Jobs in VA Richmond Analyst - (in Richmond, VA)) VDOT Business Analyst With Agile/Scrum (726886) Create date: 16-Jan-2024 Hybrid start date :01/29/2024 End date :06/30/2024 submission deadline : 1/19/2024 client info : VDOT Description : **candidate must be able to come to Richmond, VA occasionally **candidate must have experience working in Agile/Scru.... (This job is for - Wireframes Jobs in VA Richmond Analyst - (in Richmond, VA)) VDOT Senior Power BI Developer (723760) Create date: 14-Nov-2023 Hybrid Start date :12/11/2023 End date :06/30/2024 Submission deadline :11/17/2023 Client info :VDOT Description : *Local candidates only please *Candidate must also be able to work onsite 2-3 days/week. *Contractor will be r.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) Business Analyst Sr - 61540 Create date: 03-Oct-2023 Start date : 11/01/2023 End date : 11/01/2024 Submission deadline : 10/11/2023 Client info : TN EC Note : * Position Location : Hybrid Description : Analyze and document business requirements and processes related to publ.... (This job is for - UX Jobs in TN Nashville Analyst - (in Nashville, TN)) GA TECH IT Business Analyst 2 (721168) Create date: 26-Sep-2023 Remote start date :10/23/2023 End date :04/19/2024 submission deadline :09/29/2023 client info :Georgia Tech - OIT Description : The Business Analyst will act as a key link between business stakeholders and technical teams, facilitatin.... (This job is for - Tableau Jobs in GA Atlanta Analyst - (in Atlanta, GA))    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, LEAN Methodologies, Relational Database, Hadoop Analysis Design And Development D in Columbus, OH)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)