Software Architect

Expert Software ArchitectDiverse 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 OverviewThe 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 ResponsibilitiesAnalyze 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 Qualifications84+ 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 Qualifications84 months supporting Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/12c and Oracle Analytics Server (OAS), including:Enterprise reportingRepository (RPD) developmentWeb Catalog managementBI PublisherEnvironment migrationsProduction deployments72 months leading enterprise ETL development using Informatica, including:Enterprise data integration architectureData governanceBest practicesTeam leadershipData warehouse implementations72 months of Oracle database development including:Advanced SQLPL/SQLPerformance tuningQuery optimizationStored proceduresConverting SAS logic into Informatica mappings72 months administering OBIEE/OAS enterprise environments including:InstallationConfigurationUpgradesOracle WebLogic AdministrationSecurity configurationPatch managementEnvironment migrationsProduction support84 months optimizing OBIEE performance through:Query optimizationCache managementAggregate navigationRPD tuningDashboard optimization48 months of enterprise data modeling including:Dimensional modelingStar schema designSnowflake schema designSource-to-target mappingTechnical design documentation48 months of ETL and Business Intelligence testing including:Test strategy developmentSITUATRegression testingData validationReconciliationDefect management48 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 gatheringETL developmentSemantic layer designDashboard developmentEnterprise reportingData governanceData lineageData quality frameworksDesired Technical SkillsOracle DatabaseOracle Analytics Server (OAS)Oracle BI Enterprise Edition (OBIEE)Informatica PowerCenterSQLPL/SQLOracle WebLogicETL DevelopmentData WarehousingData ModelingStar SchemaSnowflake SchemaPerformance TuningBusiness IntelligenceBI PublisherData GovernanceEnterprise ReportingData ArchitectureDatabase SecurityWhy 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.