> Markdown version of [/jobs/ext/1974226-expert-software-architect-hbits-08-14906-albany-ny-hybrid](https://www.wearedevelopers.com/jobs/ext/1974226-expert-software-architect-hbits-08-14906-albany-ny-hybrid). 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). --- # Expert Software Architect HBITS-08-14906 - Albany. NY - Hybrid - **Company:** GDR Defense - **Location:** Albany, NY, United States (Remote available) - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Microsoft Access, Amazon Web Services, Data Analysis, Application Integration Architecture, Oracle WebLogic Server, Program Optimization, Data Architecture, Data Validation, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Migration, Data Systems, Data Warehousing, Database Security, Software Design Documents, Dimensional Modeling, High-Level Architecture, Systems Analysis, Microsoft Software, Oracle Business Intelligence Enterprise Edition, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Regression Testing, Release Management, Salesforce.Com, SAS (Software), SQL Stored Procedures, PL-SQL, SQL Databases, Data Streaming, Tableau (Software), Strategies of Testing, Sql Optimization, Bi Publisher, Sybase, Database Performance, Indexer, Oracle Service Cloud, Information Technology, Physical Data Models, Software Coding - **Published:** August 7, 2026 - **Apply:** https://www.careerjet.com/jobad/us41532e3bdc8986168096700b1ec8a8a7 ## About the Role Software Architect- Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-level architecture or component interactions of a large-scale software system. Expert- 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. 84 Months Experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments. 72 Months Experience leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring data warehouse initiatives. 72 Months Experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, optimization, and conversion of complex SQL, stored procedures, and SAS logic into Informatica mappings. 72 Months Experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD 84 Months Experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements. 48 Months Experience in data modeling and system analysis, including dimensional modeling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses. 48 Months Experience in ETL and BI testing, including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution across BI and data warehouse systems. 48 Months Experience in advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems. 48 Months Experience in end-to-end BI implementation and data governance, including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, and enterprise data governance, lineage, and quality frameworks. Bachelor's Degree in IT field ## Description Within this environment, the DataMart team is responsible for the design, development, and ongoing maintenance of the enterprise data warehouse and reporting layer supporting the NYWIC application. The team includes Business Analysts, Data Modelers, Informatica Developers, and OBIEE Developers who work collaboratively to deliver and sustain data solutions. The team continuously implements enhancements and updates to DataMart as the core application evolves, ensuring accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders., Perform data analysis of current and future WIC systems, including system comparison, to support ongoing and future data needs. Collaborate with customers, vendors, and technical teams to gather requirements, perform gap analysis, and prioritize reporting needs. Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema design. Define and enforce data standards, naming conventions, governance practices, and ensure data quality, integrity, and consistency across all environments. Develop and maintain documentation of business processes, workflows, and data flows using modeling techniques and flowcharts. Develop, review, and optimize ETL processes and mappings for data migration (Sybase, MS Access to Oracle), improving performance and efficiency. Design and support reporting solutions, including dashboards and prototypes, aligned with end-user requirements. Develop and execute test plans, scripts, and validation scenarios to ensure data accuracy and compliance with business requirements. Monitor and optimize database performance through query tuning, indexing, partitioning, and overall system optimization. Implement and maintain database security, access controls, auditing, and compliance with organizational and state data privacy requirements. Evaluate implementation strategies, identify risks and issues, and support resolution and mitigation planning. Provide technical guidance, conduct design reviews, mentor team members, and support release planning and post-implementation reviews. Facilitate and document meetings, support reporting development discussions, and ensure proper tracking of outcomes. Administrative tasks: Perform administrative duties including attendance at meetings and completion of NYS LATS timecard and monthly timesheets. TVT is an Information Technology (IT) professional business leader providing IT services to the public sector. Our firm is founded on the values of high integrity, trust, honesty, and commitment. We take pride in providing exceptional value to our clients by supplying and delivering the best IT project-based and hourly talent across the nation. We are business partners with many technology solution providers such as IBM, AWS, Google, Microsoft, Oracle, Tableau, Salesforce, and others. Tech Valley Talent provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, Title : Software Architect - Expert Location : Albany, NY, 12227 Duration : 30 Months Client : Information Technology Services (ITS) Requirements : 84 months experience w… + 1 day ago + Apply easily + ## 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) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [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 - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [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) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)