Find & Apply For Software Developer / Engineer Jobs in Menands, New York

NYS ITS Expert Software Architect Diverse Agile Solutions Menands, NY Job Details Full-time $50 - $55 an hour 19 hours ago Qualifications Team leadership Scalable systems Enterprise software systems development Bachelor's degree Scalability Project leadership Design (software development lifecycle) Full Job Description Expert Software Architect Diverse Agile Solutions (DAS)

Location:

Remote (New York State Preferred)

Employment Type:

Full-Time /

Contract Experience Level:

Expert (7+ Years)

Education:

Bachelor's Degree in Information Technology, Computer Science, or related field About Diverse Agile Solutions 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. Position Overview 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. Key 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. Minimum Qualifications 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. Preferred Qualifications Candidates with experience in the following areas are highly encouraged to apply: 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. Apply today and become part of a team dedicated to delivering technology excellence. Diverse Agile Solutions is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected characteristic under applicable law.