Database Architect (Expert) Oracle, Informatica, ERWIN, MS Office, Visio, SharePoint, Remedy Force, OBIEE, SQL Developer, Linux Operating System

MVP Consulting

Menands, NY

Apply

JOB DETAILS

SKILLS

Best Practices, Business Intelligence Software, Business Processes, Consulting, Data Analysis, Data Management, Data Mart, Data Migration, Data Modeling, Data Modeling Tools, Data Quality, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Documentation, Documentation Models, Enterprise Architecture, Enterprise Data Integration, Establish Priorities, Gap Analysis, Healthcare, Identify Issues, Informatica, Information Technology & Information Systems, Linux Operating System, Maintain Compliance, Management of Information Systems/Technology (MIS), Metadata, Microsoft .NET, Microsoft Office, Microsoft SharePoint, Microsoft Visio, Nutrition, Operational Audit, Oracle, Oracle Business Intelligence Enterprise Edition (OBIEE), People Management, Performance Management, Performance Modeling, Performance Tuning/Optimization, Process Improvement, Prototyping, Regulations, Regulatory Compliance, Remedy, Reporting Dashboards, Requirements Management, Resolve Customer Issues, SQL (Structured Query Language), Software Engineering, Test Plan/Schedule, Test Scripts, Testing, Time Management, erwin Data Modeler

LOCATION

Menands, NY

POSTED

1 day ago

HBITS: HBITS-08-14879

Expert, Database Architect

30 month contract

Interview: Virtual Interview

Work model: 50% telecommuting, 50% Office per week

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.

--- Project Description ---
Special Supplemental Nutrition Program for Women, Infants, and
Children (WIC)
The NYWIC (New York Women, Infants, and Children) system is a
statewide application that supports the administration of New York's
WIC nutrition program, which provides nutritional assistance and
health services to eligible women, infants, and children.
The Division of Nutrition relies on custom applications to support the
delivery of these programs. The NYWIC MIS-EBT project provides a
.NET/Oracle-based platform that enables efficient program operations
and ongoing enhancements to meet evolving business needs.
Within this environment, the DataMart team is responsible for the
design, development, and ongoing maintenance of the enterprise data
warehouse and reporting layer supporting the NYWIC application. The
team includes Business Analysts, Data Modelers, Informatica
Developers, and OBIEE Developers who work collaboratively to deliver
and sustain data solutions.The team continuously implements
enhancements and updates to the DataMart as the core application
evolves, ensuring accurate, reliable, and timely reporting for business
users, program administrators, and regulatory stakeholders.

--- Day-to-Day Tasks ---
1. Perform data analysis of current and future WIC systems, including
system comparison, to support ongoing and future data needs.
2. Collaborate with customers, vendors, and technical teams to
gather requirements, perform gap analysis, and prioritize reporting
needs.
3. Design and maintain enterprise data architecture, including
conceptual, logical, and physical data models, while performing
ongoing data modeling and schema design.
4. Define and enforce data standards, naming conventions,
governance practices, and ensure data quality, integrity, and
consistency across all environments.
5. Develop and maintain documentation of business processes,
workflows, and data flows using modeling techniques and flowcharts.
6. Develop, review, and optimize ETL processes and mappings for
data migration, improving performance and efficiency.
7. Design and support reporting solutions, including dashboards and
prototypes, aligned with end-user requirements.
8. Develop and execute test plans, scripts, and validation scenarios
to ensure data accuracy and compliance with business requirements.

--- Required Qualifications ---
" 84 Months 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.
" 84 Months 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.
" 84 Months 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.
" 72 months of experience supporting healthcare analytics environments,
including maintenance and troubleshooting of OBIEE reporting
solutions and ETL processes to ensure data availability, accuracy, and
business continuity.
" 48 Months Experience participating in business analysis and
requirements gathering sessions, including translating business
requirements into data and reporting requirements.
" 24 Months Experience designing and implementing enterprise OBIEE
dashboards and reports, including repository (RPD) development,
metadata modeling, and performance tuning for high-volume data mart
environments.
" 24 Months 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.
" 48 Months Experience in designing enterprise data integration
architecture using Informatica, including implementing best practices
and mentoring team members for data warehouse and reporting
solutions.
" Bachelor's degree in IT field
" 48 months of experience using business intelligence tools (e.g., OBIEE
11g) to support data analytics, reporting, and enterprise decision-
support solutions.

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.

About the Company

MVP Consulting

Resume Resources

Free Resume Templates Free Resume Builder