Software Architect

Position Duration: 30 Months
Client: State of NY, Department of Health

Description

This resource will serve as backup support for both Data modeling and ETL. Responsibilities include:

• 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 (Sybase, MS Access to Oracle), 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 compliance 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.
• Perform administrative duties including attendance at meetings and completion of NYS LATS timecard and monthly timesheets.

Mandatory Qualifications

• 84 Months experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments.
• 72 Months experience leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring for data warehouse initiatives.
• 72 Months experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, optimization, and conversion of complex SQL, stored procedures, and SAS logic into Informatica mappings.
• 72 Months experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD.
• 84 Months experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
• 48 Months experience in data modeling and system analysis, including dimensional modeling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.
• 48 Months experience in ETL and BI testing, including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution across BI and data warehouse systems.
• 48 Months experience in advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.
• 48 Months experience in end-to-end BI implementation and data governance, including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, and enterprise data governance, lineage, and quality frameworks.
• Bachelor's Degree in IT field.

Required Documentation

• Résumé
• Copy of Candidate Identification (e.g., Driver's License, Green Card, Visa, and Passport if applicable)
• Any documents referenced in the qualifications (e.g., professional certifications, degrees)