Senior Database Architect- Remote
: Job Details :

This position is now 100% remote.Complete Description:The Senior Database Architect will be responsible for Medicaid Enterprise Data Warehouse (EDW)design, development, implementation, migration, maintenance, and operational activities. Thecandidate will closely with Data Governance and Analytics team. Will be one of the key technicalresource for data warehouse projects for various Enterprise Data Warehouse projects and buildingcritical data marts, data ingestion to Big Data platform for data analytics and exchange with State andMedicaid partners. This position is a member of Medicaid closely with the BusinessIntelligence & Data Analytics team.Responsibilities:Participate in Team activities, Design discussions, Stand up meetings and planning Reviewwith team.Perform data analysis, data profiling, data cleansing and data quality analysis in variouslayers using Database queries both in 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 anddesign decisions.Perform data gap and impact analysis due to new data addition and existing data changes forany new business requirements and enhancements.Follow the organization design standards document, create data mapping specificationdocument, pseudo codes for the development team(s) and design documents.Create logical and physical data models.Review and understand existing business logic used in Hadoop ETL platforms to verifyagainst the business user needs.Review PySpark programs that are used to ingest historical and incremental data.Review SQOOP scripts to ingest historical data from Module Vendor's databases to HadoopIOP, created HIVE tables and Impala view creation scripts for multiple data mart tables.Assist Business Analyst to create Test Plan, Design Test scenarios, SQL scripts(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 codefor 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 minimalsupervision.Create and present project plan, project status and other dashboards as necessary.Perform other duties as assignedEQUIRED Skill Sets:8+ years Data analysis/architecture experience in Waterfall and Agile Methodology in variousdomains (prefer Healthcare) in a data warehouse environment.Good knowledge of relational database, Hadoop big data platform and tools, data vault anddimensional 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-9 years' experience).Experience in analysis, design, development, support and enhancements in data warehouseenvironment with Cloudera Bigdata Technologies (with a minimum of 8-9 years' experience indata analysis, data profiling, data model, data cleansing and data quality analysis in variouslayers using Database queries both in Oracle and Big Data platforms).Experience (minimum of 8-9 years) in working Erwin Data Model tool, hive/impala queries, Unixcommands, scripting and shell scripting etc.Experience in migrating data from relational database (prefer Oracle) to big data - Hadoopplatform is a plus.Experience eliciting, analyzing and documenting functional and non-functional requirements.Ability to document business, functional and non-functional requirements, meeting minutes, andkey 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 withminimal 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 skillsRequired excellent written and oral communication skills with technical and business teams.Ability to work independently, as well as part of a teamStay abreast of current technologies in area of IT assignedEstablish facts and draw valid conclusionsRecognize patterns and opportunities for improvement throughout the entire organizationAbility to discern critical from minor problems and innovate new solutions