MCD - Senior Database Architect 1 / SDA1

Role MCD - Senior Database Architect 1 / SDA1
Location 50 W Town St #400, Columbus, OH 4321

Short Description:
Consultant is expected to work on-site, in the office 5 days per week
Complete Description:
Consultant is expected to work on-site, in the office 5 days per week
Hrs 8-5pm M-F
The Senior Database Architect will be responsible for Medicaid Enterprise data warehouse
design, development, implementation, migration, maintenance, and operational activities.
The candidate will work closely with the Data Governance and Analytics team. Consultant
will be one of the key technical resources 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 OST closely with the Business Intelligence & Data Analytics team.
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 DDL's and DML's
in Oracle, Hive and Impala (minimum of 8 or more years' experience).
Experience in analysis, design, development, support and enhancements in data
warehouse environment with Cloudera Bigdata Technologies (with a minimum of 8 or more
years' experience in data analysis, data profiling, data model, data cleansing and data quality
analysis in various layers using Database queries both in Oracle and Big Data platforms).
Experience (minimum of 8 or more years) in working Erwin Data Model tool,
hive/impala queries, Unix commands, scripting and shell scripting etc.
Experience in migrating data from relational database (prefer Oracle) to big data
Hadoop platform is a plus.
Experience eliciting, analyzing and documenting functional and non-functional
requirements.
Ability to document business, functional and non-functional requirements, meeting
minutes, and key decisions/actions.
Experience in identifying data anomalies.

Experience building data sets and familiarity with PHI and PII data.
Ability to establish priorities & follow through on projects, paying close attention to
detail with minimal supervision.
Effective communication, presentation, & organizational skills.
Good experience in working with Visio, Excel, PowerPoint, Word, etc.
Effective team player in a fast paced and quick delivery environment.
Required Education: BS/BA degree or combination of education & experience.
DESIRED Skill Sets:
Demonstrate effective leadership, analytical and problem-solving skills
Required excellent written and oral communication skills with technical and
business teams.
Ability to work independently, as well as part of a team
Stay abreast of current technologies in area of IT assigned
Establish facts and draw valid conclusions
Recognize patterns and opportunities for improvement throughout the entire
organization
Ability to discern critical from minor problems and innovate new solutions

Skills :