HBITS-08-14879-Database Architect-Expert

Day-to-Day Tasks

• Perform data analysis of current and future WIC systems, including system comparison, to support ongoing and future data needs.
• Collaborate with customers, vendors, and technical teams to gather requirements, perform gap analysis, and prioritize reporting needs.
• Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema design.
• Define and enforce data standards, naming conventions, governance practices, and ensure data quality, integrity, and consistency across all environments.
• Develop and maintain documentation of business processes, workflows, and data flows using modeling techniques and flowcharts.
• Develop, review, and optimize ETL processes and mappings for data migration, improving performance and efficiency.
• Design and support reporting solutions, including dashboards and prototypes, aligned with end-user requirements.
• Develop and execute test plans, scripts, and validation scenarios to ensure data accuracy and compliance with business requirements.
• Monitor and optimize database performance through query tuning, indexing, partitioning, and overall system optimization.
• Implement and maintain database security, access controls, auditing, and comply with organizational and state data privacy requirements.
• Evaluate implementation strategies, identify risks and issues, and support resolution and mitigation planning.
• Provide technical guidance, conduct design reviews, mentor team members, and support release planning and post-implementation reviews.
• Facilitate and document meetings, support reporting development discussions, and ensure proper tracking of outcomes.

Mandatory Qualifications

• Database Architect – Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
• Expert 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments.
• Experience using data modeling tools (e.g., Erwin) for data model design, documentation, and review to ensure compliance with enterprise data standards and development best practices.
• Experience in relational data management, database design, and development using Oracle technologies, including advanced SQL programming for data analysis, optimization, and reporting in data warehouse environments.
• Experience supporting healthcare analytics environments, including maintenance and troubleshooting of OBIEE reporting solutions and ETL processes to ensure data availability, accuracy, and business continuity.
• Experience in designing enterprise data integration architecture using Informatica, including implementing best practices and mentoring team members for data warehouse and reporting solutions.
• Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements.
• Experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decision support solutions.
• Experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume data mart environments.
• Experience establishing and enforcing enterprise data governance, lineage, and data quality frameworks to ensure data integrity, compliance, and reliable reporting across data marts and reporting environments.
• Bachelor’s degree in IT field.