Software Architect (Expert)Oracle, Informatica, ERWIN, MS Office

HBITS: HBITS-08-14906

Software Architect

Makes high-level design choices and dictates technical standards,

including software coding standards, tools, and platforms. Designs

multi-leveled architecture or component interactions of a large scale

software system.

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.

30 month contract

Interview: Virtual Interview

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

--- Project Description ---

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

(Sybase, MS Access to Oracle), 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.

9. Monitor and optimize database performance through query tuning, indexing,

partitioning, and overall system optimization.

10. Implement and maintain database security, access controls, auditing, and

compliance with organizational and state data privacy requirements.

11. Evaluate implementation strategies, identify risks and issues, and support

resolution and mitigation planning.

12. Provide technical guidance, conduct design reviews, mentor team members,

and support release planning and post-implementation reviews.

13. Facilitate and document meetings, support reporting development discussions,

and ensure proper tracking of outcomes.

14. Administrative tasks: Perform administrative duties including attendance at meetings

and completion of NYS LATS timecard and monthly timesheets.

--- Required Qualifications ---

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.