SAS Developer (with DataFlux, Informatica IDQ and Excel VBA) - Consultant

SAS Developer (with DataFlux, Informatica IDQ and Excel VBA) - Consultant

Jersey City, NJ
10857013
04-13-2018
or
Intermedia Group has an opening for the following Consultant:

TITLE: SAS Developer (with DataFlux, Informatica IDQ and Excel VBA)
LOCATION: Jersey City, NJ - 
Can possibly work remote, but that is dependent on the candidate strength
DURATION: 8 months +

TARGET RATE: $55 - $60 per hour w2 or $97,000 - $105,000 + benefits

NOTE:
  • We can only work w2.
  • We can not work on a corp to corp
     
JOB SUMMARY:
  • Support data governance and play a role in all necessary aspects of project initiatives within the Data Management Department.
  • This position requires technical, business, and analytical skills to assist in data quality monitoring & measuring, root cause analysis, logical design, testing, reporting, and requirement gathering.
  • For the build-out of the Data Governance Program, the incumbent will be required to help promote data accountability, write technical data quality rules, monitor data quality results through an executive Data Quality Scorecard, coordinate and perform data remediation across the Americas, and coordinate and define data definitions (Metadata) starting with Key Data Elements across Business Lines. 
     
MAJOR RESPONSIBILITIES INCLUDE: 
  • Support the Data Quality Program, including the creation and execution of DQ queries using SAS DataFlux, management of DQ exceptions, and support of a DQ Scorecard. 
  • Assist in expanding the monitoring and measurement activities across the Americas. 
  • Analyze and create new DQ rules using DataFlux, introducing new features, coordinating software upgrades, and migrating existing procedures. 
  • Assist in the expansion of the data quality scorecard to incorporate new items and improve efficiencies. 
  • Analyze gaps and deficiencies within business areas by studying current reporting and analytical practices 
  • Support data clean-up and reconciliation through root cause analysis (RCA) and coordination of production changes. RCA will require hands-on data analysis using SQL. 
  • Implement and update data governance procedures, standards, training documents, presentations, and Data Governance detail plans. 
  • Assist Data Stewards and Business Process Owners to achieve Data Quality & Monitoring goals. 
  • Participate in testing activities (test plans, test cases and test scripts). 
  • Build subject matter expertise.
  • Identify gaps between current capabilities and new requirements. 
  • Assist the Chief Data Office with various department related activities. 
     
QUALIFICATIONS: 
  • Strong technical proficiency in Informatica IDQ
  • Experience with SAS DataFlux, and Excel VBA 
  • Must know Informatica IDQ (heavier on the informatica versus DataFlux) and some DataFlux. Informatica skills are very important.
  • 5+ years of SAS programming experience 
  • 5+ years of experience in a financial services organization, Data Warehousing, Reporting, Data Governance, or Programming 
  • Advanced SQL skills required: querying, tuning, designing 
  • Experience with Informatica is a plus 
  • Hands-on support with semi-technical tools, i.e. Access, Advanced Excel 
  • Able to coordinate with both business and technology, ability to understand the details and suggest best practice solutions 
  • Knowledge of banking products 
  • Experience in Risk Management or understanding the concept 
  • Familiar with Data Governance and Data Quality control process 
  • Data analysis and Root Cause Analysis 
  • Familiarity with key regulatory requirements that affect how data is generated, manipulated, recorded and reported (SOX, BIS II etc.) is a plus 
  • Understanding of operations, technology, and SDLC 
  • Self-starter and independent learner 
  • Articulate, good verbal and written communication skills, experience preparing and leading presentations 
  • Detail-oriented with superior time management abilities 
  • Experience in project work, analysis, and planning 
  • BA/BS required
     
If you are interested in pursuing this opportunity, please respond back and include the following:
 
• Full MS WORD Resume
• Current and required compensation
• Current contact information
• Availability
 
Upon receipt, one of our managers will contact you to discuss the position in full detail.

Steve Fleischner
INTERMEDIA GROUP, INC.
212-248-0100
Email: steve@intermediagroup.com

Recruiter Contact


Steve Fleischner | Managing Partner
sfleischner@intermediagroup.com
Intermedia Group Inc. | New York, NY
Main: (212) 248-0100
this job portal is powered by CATS