Waterfall Relational Database Hadoop Data Analysis Design Pyspark Hive PHI PII Secu   Requirement id 115544 Job title Analyst Job location in Columbus, OH Skills required Business Data Analyst, Waterfall, Agile Methodology, Relational Database Hadoop Data Analysis Open Date 29-Mar-2021 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: Business Data Analyst, Waterfall, Agile Methodology, Relational Database Hadoop Data Analysis start date: 04/12/2021 End date:06/30/2021 submission deadline:Wednesday 3/31 @ 10 am EST client info : MCD Note: * REPOST OF 80595 - DO NOT RESUBMIT CANDIDATES * Interviews: teams with video Description: The Business Analyst 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 business/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: • Participate in Team activities, Design discussions, Stand up meetings and planning Review with team. • Eliciting, analyzing and documenting functional, non-functional and data requirements. • Document business requirements, meeting minutes, and key decisions/actions. • Perform business data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms. • 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 Data 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. * KS Consultant Job Title: Business Analyst 4 Detailed Day-To-Day Job Duties to be performed: Responsibilities: • Participate in Team activities, Design discussions, Stand up meetings and planning Review with team. • Eliciting, analyzing and documenting functional, non-functional and data requirements. • Document business requirements, meeting minutes, and key decisions/actions. • Perform business data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms. • Lead client meetings and sessions with data-driven analysis to clarify requiremen   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 115544 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Business Data Analyst job openings in Columbus, OH Jobs List Business Consulting Analyst - 6461 Create date: 25-May-2017 Business Consulting Analyst who will be responsible for the creation of the Actuarial Business Data Glossary as part of the Actuarial Modernization program. This person will work daily with actuaries and governance associates to gain consensus while compiling the definitions for data attributes. This process will involve taking system d.... (This job is for - Jobs in OH Columbus Analyst - (in Columbus, OH))    Business Data Analyst job openings in other states Jobs List Business Data Analyst - 31830 Create date: 08-Feb-2018 Candidate must be our own W2 Employee We should take signed RTR form from candidate (Candidates RTR form should be only on the name of APEX Systems)" The Production Support Systems Analyst will work with minimal supervision to support iHub Project Integration Analysis Services. Business & Data analysis will .... (This job is for - BRD Jobs in CA SanFrancisco Analyst - (in San Francisco, CA)) Business Data Analyst III - 10229-17 Create date: 06-Apr-2017 Start date : 05/15/2017 End date : 11/10/2017 Deadline : 04/18/2017 Client : DHS / OHA Description : Interprets results using a variety of techniques, ranging from simple data aggregation via statistical analysis to complex data mining independently. Designs, develops, implements and maintains business solut.... (This job is for - HIPPA Jobs in OR Salem Analyst - (in Salem, OR)) Business Data Analyst Create date: 20-Feb-2017 Start Date : 03/02/2017 Submission Dead Line : 02/24/2017 Description : candidates for a Business Data Analyst role in Washington, DC (must be onsite) for a contract position (10 months). The position will utilize Business Analysis and Data Analysis skills and must be very comfortable interacting with business .... (This job is for - job Jobs in DC Washington Analyst - (in Washington, DC)) ITSB_Data Governance Consultant-SP Create date: 02-Dec-2016 [ Submission deadline : 12/15/2016 5:00 p.m ] Description: The Data Governance Consultant is the system-wide expert on business data supporting the data governance effort to define: what data is available, where it is located, how it is structured, what it means, how it is calculated, how it is maintained, and how it.... (This job is for - job Jobs in CA Sacramento Manager - (in Sacramento, CA)) Business Data Analyst III - 2017*1464A Create date: 24-Aug-2016 Description: Federal Reporting •Represents the Department as the senior authority for federally mandated reporting requirements for adoption, foster care, youth emancipating from the foster care system, and child abuse and neglect. •Coordinates the production of data files with technical staff, program review .... (This job is for - job Jobs in CO Denver Analyst - (in Denver, CO))     (Analyst: Business Data Analyst, Waterfall, Agile Methodology, Relational Database Hadoop Data Analysis in Columbus, OH)

Featured Jobs ASP.Net JQuery Azure Developer (Jobs in Des Moines, Iowa) Antivirus Cisco Writing Specialist (Jobs in Raleigh, North Carolina) Azure Administrator (Jobs in Jackson, Mississippi) Help Desk Troubleshooting TechLead (Jobs in Jackson, Mississippi) VDI VPN Architect (Jobs in Raleigh, North Carolina) Patching Dataverse Engineer (Jobs in Madison, Wisconsin) MS Architect (Jobs in Madison, Wisconsin) GitHub Azure Architect (Jobs in Madison, Wisconsin) IOS Ongoing Developer (Jobs in Madison, Wisconsin) Oral Architect (Jobs in Durham, North Carolina)