> Markdown version of [/jobs/ext/1916817-nys-its-expert-software-architect](https://www.wearedevelopers.com/jobs/ext/1916817-nys-its-expert-software-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # NYS ITS Expert Software Architect - **Company:** Diverse Agile Solutions - **Location:** Menands, NY, United States (Remote available) - **Experience:** Expert - **Salary:** $104,000.0 - $114,400.0 - **Contract:** Permanent contract - **Skills:** Microsoft Access, Agile Methodology, Application Integration Architecture, Oracle WebLogic Server, Software Bug Management, Information Systems, Data Architecture, Data Validation, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mart, Data Migration, Data Systems, Data Warehousing, Database Security, Software Design Documents, Dimensional Modeling, Oracle Business Intelligence Enterprise Edition, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Regression Testing, Standard Sql, SAS (Software), Software Deployment, SQL Stored Procedures, PL-SQL, System Integration Testing, Strategies of Testing, Enterprise Data Management, Enterprise Software Applications, Sql Optimization, Bi Publisher, Informatica Powercenter, Database Optimization, Sybase, Indexer, Oracle Service Cloud, Information Technology, Data Lineage, Star Schema, Patch Management - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=3578a6d785ac61e9 ## About the Role * 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., Candidates with experience in the following areas are highly encouraged to apply ## Description 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., * 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., * 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 Why Join Diverse Agile Solutions? At DAS, you'll work alongside highly skilled professionals delivering innovative technology solutions that directly support critical public service programs. We offer opportunities to solve complex technical challenges, collaborate with experienced teams, and contribute to projects that make a meaningful impact on communities. If you're passionate about enterprise architecture, business intelligence, data warehousing, and designing scalable technology solutions, we'd love to hear from you. ## Related Videos - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) - [We (don't) need a software architect!?!](https://www.wearedevelopers.com/videos/663-we-don-t-need-a-software-architect) - [Next Level Enterprise Architecture: Modular, Flexible, Scalable, Multichannel and AI-Ready?](https://www.wearedevelopers.com/videos/1017-next-level-enterprise-architecture-modular-flexible-scalable-multichannel-and-ai-ready) - [How Gatsby Cloud's real-time streaming architecture drives <5 second builds](https://www.wearedevelopers.com/videos/418-how-gatsby-cloud-s-real-time-streaming-architecture-drives-5-second-builds) ## Related Articles - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [What is Software Engineering?](https://www.wearedevelopers.com/magazine/289-what-is-software-engineering) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)