*SAS Developer w/DataFlux - In person interview - Direct Client **Immediate Interview and Start ASAP!!!*
*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Job Title: SAS Developer w/DataFluxLocation: NYCDuration: 6 MonthsDirect Client PositionIn person interviewSAS/DataFlux DeveloperThe Pre-K for All program seeks to provide every 4-year-old child living in New York City with high-quality, full-day pre-kindergarten either at a public school or community-based early childhood center (CBECC). Critical to the success of the program is Outreach to parents of eligible children. The goal of Outreach is to identify NYC households with 4-year-old children who have not yet applied to or enrolled in a NYC Pre-K program. Using a MS Dynamics CRM-based tool which tracks the outreach effort, a “call team” will contact those households with 4-year-olds who have not enrolled in a school The Outreach tool will identify schools with available space in close proximity to the student’s home and the outreach team will encourage enrollment at one of those schools. In order to conduct outreach, data is collected from numerous sources and consolidated into households with unique household IDs. This is done using SAS and DataFlux. Although child information is not uploaded to the CRM tool, individual children are identified and assigned a unique child ID. Household, contact and application data is uploaded to the CRM tool using Scribe. Call results are recorded in the CRM tool and the status of child enrollments is imported from Department of Education (DOE) systems. An Enrollment Scorecard report and several other standard reports are produced. There are also ad hoc reporting requests that must be addressed.New data sources for the new 2015-16 school year are being identified and secured. In addition, new data fields will be added to the CRM tool. This will require the current data matching workflow to be redesigned and redeveloped. In addition, some identified improvements to the current process will need to be addressed. The standard reports will also be impacted by these changes.Detailed Expectations & Qualifications of RoleThe candidate selected by TDC will be responsible for performing entity resolution and reporting tasks required by NYCTDC for the PKA Outreach effort. The core of the work will be to resolve entities across data sets based on information common to many or all sources and to address any reporting needs.The candidate will review the existing matching workflow process along with the final set of data sources and design/develop an improved matching workflow process. The candidate will also develop the Enrollment Scorecard, develop any additional identified standard reports, and address any ongoing ad hoc data requests. The candidate will provide documentation for all work. The candidate will be directed by TDC, and work with resources across Department of Information Technology and Telecommunications (DoITT), DOE, Mayor’s office of Data Analytics (MODA), and the Mayor’s Office. Mandatory Skill/Expertise8+ years of overall development experienceMust be able to see tasks through to completion without significant guidance.4+ years of SAS.Strong experience required with SAS V9.3 running on Unix and WindowsSAS Enterprise GuideBase SAS programming and Macro level codingSAS Access to Oracle and PC file interfacesStrong knowledge of relational database systems, data structures and data modeling conceptsObtain, scrub, explore, model and interpret data currently stored in Oracle databases – using SQL and SASExperience in data management, data quality, data automation and development of information standards Desirable Skill/Expertise Strong experience required with SAS/DataFlux suite V2.4 and V2.54+ years of DataFlux experience.DataFlux Data Management Studio 2.4 and 2 .5 and DataFlux Management Server:Experience with Data Flux for Data CleansingExperience with creating Jobs in DataFlux tool to analyze and find Data Discrepancies based on the user requirementsExperience with DataFlux tool to Formalize the data quality function within the organization by instituting a data dictionary for several data martsSubject Matter Expert on Data Flux technical requirements and processExperience in providing data quality solution using SAS Data FluxExperience with installation and Configuration of the Data Flux on Windows and LinuxSAS DataFlux Stored ProceduresUnix shell scriptingDESIREDKnowledge of SAS BI dashboards creationKnowledge of SAS Data Integration StudioBachelors or Masters degree in MIS, Computer Science, or equivalent experienceKnowledge of Java/J2EEExperienced with formal SDLCs and business analysis methodologies; Working knowledge of business analysis documentation standards; Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.