NYS ITS Expert Software Architect

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.

• 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

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.