NYS ITS Expert Software Architect

Diverse Agile Solutions•Menands, NY

16d•Remote

About The Position

Diverse Agile Solutions (DAS) is a certified Minority Business Enterprise (MBE) specializing in IT consulting, digital transformation, cloud technologies, data analytics, cybersecurity, and enterprise software solutions. We partner with government agencies and commercial organizations to deliver innovative, scalable, and mission-critical technology solutions that improve business outcomes. We are seeking an experienced Expert Software Architect to support the New York Women, Infants, and Children (NYWIC) Management Information System (MIS-EBT). This position plays a key role in supporting the enterprise DataMart environment by providing leadership in enterprise data architecture, data modeling, ETL development, and business intelligence solutions. The NYWIC Management Information System (MIS-EBT) is a statewide application that supports New York's Women, Infants, and Children (WIC) nutrition program by providing critical technology services that enable efficient program administration. The DataMart team designs, develops, and maintains the enterprise data warehouse and reporting environment supporting NYWIC. Working alongside Business Analysts, Data Modelers, Informatica Developers, and Oracle BI developers, the Expert Software Architect will help ensure the delivery of reliable, scalable, and high-performing data solutions. This individual will also serve as backup support for enterprise data modeling and ETL development while providing technical leadership across reporting, data integration, and enterprise architecture initiatives.

Requirements

84+ months (7+ years) of enterprise software architecture or equivalent experience.
Demonstrated ability to lead technical teams and provide architectural guidance on complex enterprise initiatives.
Extensive experience designing scalable enterprise software and data architecture solutions.
Bachelor's Degree in Information Technology, Computer Science, Information Systems, or a related technical discipline.

Nice To Haves

84 months supporting Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/12c and Oracle Analytics Server (OAS), including: Enterprise reporting Repository (RPD) development, Web Catalog management, BI Publisher, Environment migrations, Production deployments
72 months leading enterprise ETL development using Informatica, including: Enterprise data integration architecture, Data governance, Best practices, Team leadership, Data warehouse implementations
72 months of Oracle database development including: Advanced SQL, PL/SQL, Performance tuning, Query optimization, Stored procedures, Converting SAS logic into Informatica mappings
72 months administering OBIEE/OAS enterprise environments including: Installation, Configuration, Upgrades, Oracle WebLogic Administration, Security configuration, Patch management, Environment migrations, Production support
84 months optimizing OBIEE performance through: Query optimization, Cache management, Aggregate navigation, RPD tuning, Dashboard optimization
48 months of enterprise data modeling including: Dimensional modeling, Star schema design, Snowflake schema design, Source-to-target mapping, Technical design documentation
48 months of ETL and Business Intelligence testing including: Test strategy development, SIT, UAT, Regression testing, Data validation, Reconciliation, Defect management
48 months performing advanced SQL/PLSQL data validation and troubleshooting to ensure enterprise data integrity and consistency.
48 months delivering end-to-end Business Intelligence solutions including: Requirements gathering, ETL development, Semantic layer design, Dashboard development, Enterprise reporting, Data governance, Data lineage, Data quality frameworks
Desired Technical Skills: Oracle Database, Oracle Analytics Server (OAS), Oracle BI Enterprise Edition (OBIEE), Informatica PowerCenter, SQL, PL/SQL, Oracle WebLogic, ETL Development, Data Warehousing, Data Modeling, Star Schema, Snowflake Schema, Performance Tuning, Business Intelligence, BI Publisher, Data Governance, Enterprise Reporting, Data Architecture, Database Security

Responsibilities

Analyze existing and future NYWIC systems to support enterprise reporting and evolving business requirements.
Collaborate with business stakeholders, vendors, and technical teams to gather requirements, conduct gap analyses, and prioritize reporting initiatives.
Design and maintain conceptual, logical, and physical enterprise data models.
Establish and enforce enterprise data standards, governance policies, naming conventions, and data quality practices.
Develop and maintain documentation including business processes, workflows, technical specifications, and data flow diagrams.
Design, optimize, and maintain ETL processes supporting data migration from Sybase and Microsoft Access into Oracle environments.
Design enterprise reporting solutions, dashboards, and reporting prototypes that meet business needs.
Develop and execute comprehensive testing strategies including System Integration Testing (SIT), User Acceptance Testing (UAT), regression testing, and data validation.
Monitor and optimize Oracle database performance through query tuning, indexing, partitioning, and database optimization techniques.
Implement database security, auditing, access controls, and compliance with organizational and state data privacy standards.
Evaluate implementation approaches, identify project risks, and develop mitigation strategies.
Provide technical leadership, conduct architecture and design reviews, mentor development teams, and support production releases.
Facilitate technical meetings, document decisions, and ensure proper follow-up of project action items.
Complete required administrative activities including attendance at project meetings, NYS LATS time reporting, and monthly timesheet submissions.