WIC (Special Supplemental Nutrition Program for Women, Infants and Children)
This Software Analyst position is required to support continued analysis, development and maintenance efforts for the NYWIC Data Mart.
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. In addition to the MIS the program has a data warehouse to further support reporting 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 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 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 may include but are not limited to:
- Work as a liaison among stakeholders including business owners/subject matter experts to elicit, document, and communicate business and functional requirements for new reports/extracts or enhancements to existing reports/extracts.
- Conduct data analysis of business processes, existing systems, documentation and user needs to document user and functional requirements to ensure data is available in the datamart and OBIEE to meet requirements for new OBIEE reports.
- Create and maintain business documentation (Business Requirement documents, use cases, swim lanes, process documentation) that detail the Business Intelligence reporting requirements and deliverables for OBIEE reports, dashboards, and ad hoc tools.
- Create and maintain functional/technical documentation and other business/system documentation as required.
- Work closely with Data Warehouse and Business Intelligence technical team members to communicate the business requirements to the technical team for development of logical and physical dimensional data model reporting requirements and document functional requirements.
- Collaborate with data modelers, ETL developers, programmers, and the business owners to translate report requirements, provide clarification of business rules, prioritize development, obtain signoff, and ensure successful delivery of accurate end user reporting requirements.
- Provide level 2 support for existing datamart reports: review incoming incidents, analyze and troubleshoot reported issue, and triage tickets to other team members as needed. Update ticket based on progress, provide further instructions to users as needed for successful report generation and work with other team members to document the resolution and create resolution documents as needed.
- Review new Service Requests assigned to the team, preform preliminary analysis and work with the team to capture the high level requirements and prepare high level estimates.
- Work with business subject matter experts and the technical team to understand changes to the source data application and analyze and document the impact of each change on the Datamart and OBIEE and prepare the impact analysis document and work with the team to document and plan for updates to the Datamart and OBIEE and reports.
- Create and execute test scripts, scenarios, and test plans to validate initial business requirements and report output through the DEV, QA and PROD migrations testing for accuracy and sign off on deliverables.
- Facilitate and document meetings including requirements discussions, bi-weekly touchpoint with business and technical team.
- Assist in providing training & end user support for DOH/NYWIC staff utilizing the OBIEE Analytics tool.
- Provide backup support for other team members as needed.
- Follow enterprise, cluster level, department level, and division level directives, best practices, standards, and methodologies, as appropriate or requested.
Position Mandatory Qualification (Per Attachment 7, Section 1.2.4)
Position Job Title: (Per Attachment 4)
Software Analyst
Studies the software application domain, prepares software requirements, and specification documents. Liaises between the software users and the software developers. Conveys the demands of software users to the developers. Skills include: working knowledge of software technology; computer programming experience/expertise; general business knowledge; problem solving/reduction skills; interpersonal relation skills; flexibility and adaptability.
Position Skill Level: (Per Attachment 4)
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.
Position Requested Qualifications (Per Attachment 7, Section 1.2.5)
- 84 months of experience with analysis and documentation of complex business requirements, business rules, and functional requirements including creating business requirements documentations (BRDs), report mockups, process flows, and functional/technical specifications.
- 84 months of experience leading meetings with business staff/subject matter experts to elicit, document and validate business requirements.
- 60 months of experience providing production support for OBIEE/Oracle reports, addressing incoming incidents and working with business staff, end users or technical staff to analyze issues and document the resolution.
- 36 months of experience identifying testing scenarios, creating test cases, and performing testing to validate OBIEE reports, extracts or datamart ETL and documenting defects using Client Quality center or other similar tools.
- 36 months of experience leading team meetings and tracking discussion/status of team assignments using MS Teams, Planner or other similar tools.
- 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition) 11g (or higher) Business Intelligence Dashboards, or other business intelligence tools including end user experience.
- Bachelor's Degree in an Information Technology related field, from an accredited institution.
- 48 months of experience eliciting and documenting requirements for data import/export processes including business and functional requirements, data validations, file processing requirements and exception handling.
- 36 months of experience with MS Office, Visio, SharePoint and other tools for creating and maintaining project documentation including technical documentation and user guides/training presentations.
- 60 Months Experience using SQL for analysis, report development, and testing.
Required Documentation
- Re sume
- Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
- Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
What are the daily work hours? (Note if negotiable or list preferred start and end time):
Preferred hours 8:00am-4:30pm, includes 30 mins unpaid lunch. The basic workweek and workday is 40 hours per week; 8 hours per day; Monday to Friday. The consultant may occasionally be required to work beyond the hours of the established workday or workweek based on operational need; be on-call to support maintenance/deployment efforts
Is telecommuting allowed for this position? (As designated by the Authorized User)
Yes
If YES, note if negotiable or list the percentage allowed/number of days allowed
Up to 50 % after 3 months. Schedule and alternate worksite must be compliant with ITS telecommuting policies
What is the format of the Candidate interview?
Webcasting
If Webcasting, is Candidate required to be on camera?
Yes
What type of software is typically used by the Agency?
Oracle, Informatica, ERWIN, MS Office, Visio, SharePoint, Remedy Force, OBIEE, SQL Developer, Linux Operating System
What type of hardware is typically used by the Agency?
Client