> Markdown version of [/jobs/ext/3000063-expert-software-developer](https://www.wearedevelopers.com/jobs/ext/3000063-expert-software-developer). 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 Developer - **Company:** Mvp Consulting Plus, Inc. - **Location:** Albany, NY, United States (Remote available) - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** .NET Framework, Data Analysis, Software Documentation, Databases, Data Mart, Data Structures, Data Warehousing, Oracle Business Intelligence Enterprise Edition, Oracle (Applications), Oracle SQL Developer, Regression Testing, SQL Stored Procedures, SQL Databases, Test Scripts, Database Performance, Information Technology, Oracle Reports - **Published:** September 19, 2026 - **Apply:** https://www.dice.com/job-detail/cb5872ed-742f-4746-a8f6-a1e6adab0635 ## About the Role 84 months of experience creating software documentation including functional specifications and technical specifications 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts 36 months of experience creating user documentation such as user guides or training presentations 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience Bachelor's Degree in an Information Technology related field, from an accredited institution. 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL 84 months of experience meeting with business staff to elicit business requirements 84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports ## Description The NYWIC (New York Women, Infants, and Children) system is a statewide application that supports the administration of New York's WIC nutrition program, which provides nutritional assistance and health services to eligible women, infants, and children. The Division of Nutrition relies on custom applications to support the delivery of these programs. The NYWIC MIS-EBT project provides a .NET/Oracle-based platform that enables efficient program operations and ongoing enhancements to meet evolving business needs. 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 Software Analysts, Data Modelers, Informatica Developers, Software Developers, and OBIEE Developers who work collaboratively to deliver and sustain data solutions.The team continuously implements enhancements and updates to the DataMart as the core application evolves, ensuring accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders. --- Day-to-Day Tasks --- 1. Develop, test and execute Oracle SQL queries against the schema of the Production NYWIC database upon request, for program validation and data analysis 2. Develop and maintain a library of SQL queries that can be executed on a recurring basis with different parameters, for similar requests 3. Assist DOH program staff in understanding NYWIC data structures within the NYWIC modules, for developing new report requirements 4. Assist DOH program staff in developing new ad-hoc queries within the NYWIC Datamart OBIEE system, using defined user guidelines and additional guidance from the NYWIC Datamart team as needed 5. Work with NYWIC Datamart team members, program staff, and the NYWIC application vendor as needed to develop a knowledgebase of system data mappings between the NYWIC application and the Datamart, for program assistance 6. Participate in review and/or documentation of regression test scripts for user acceptance testing 7. Provide general support for user acceptance testing efforts 8. Work closely with ITS and Program managers to ensure adherence to standard policies and procedures ## Related Videos - [Are Classical Automation Frameworks Dead? How AI Agents Are Transforming QA](https://www.wearedevelopers.com/videos/100243-are-classical-automation-frameworks-dead-how-ai-agents-are-transforming-qa) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [The ABC of DX](https://www.wearedevelopers.com/videos/727-the-abc-of-dx) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Diving into Developer Experience](https://www.wearedevelopers.com/videos/1120-diving-into-developer-experience) - [Fighting test flakiness with time machines](https://www.wearedevelopers.com/videos/834-fighting-test-flakiness-with-time-machines) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Technical Documentation For Developers](https://www.wearedevelopers.com/magazine/128-technical-documentation-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [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) - [Data Science & more: The Lopez dilemma](https://www.wearedevelopers.com/magazine/10-data-science-more-the-lopez-dilemma)