What are the responsibilities and job description for the Senior Database Architect position at United Software Group?
Job Description : Senior Database Architect
Work Location : 50 West Town Street, Columbus, Ohio 43215 - Remote
Description : The Senior Database Architect will play a crucial role in Medicaid Enterprise Data Warehouse (EDW) design, development, and operational activities. Collaborating closely with the Data Governance and Analytics team, this position involves being a key technical resource for various Enterprise Data Warehouse projects. The focus includes building critical data marts, data ingestion to Big Data platforms for analytics, and facilitating data exchange with State and Medicaid partners. This role is a pivotal member of Medicaid ITS and OST, closely aligned with the Business Intelligence & Data Analytics team.
Responsibilities :
- Participate in team activities, design discussions, stand-up meetings, and planning reviews.
- Conduct data analysis, profiling, cleansing, and quality analysis in various layers using Database queries in Big Data platforms.
- Elicit, analyze, and document functional and non-functional requirements.
- Lead client meetings with data-driven analysis to clarify requirements and design decisions.
- Create logical and physical data models, ensuring compliance with organizational design standards.
- Review and understand existing business logic used in Hadoop ETL platforms.
- Assist in creating and executing test plans, scenarios, and scripts, validating results, and addressing production issues.
- Establish priorities, present project plans and status, and perform other assigned duties.
REQUIRED Skill Sets :
Experience :
