To post a job ad, Click here.

Tuesday, August 19, 2008

Junior SAS Consultant (New York, NY)


Detica is a business and technology consulting firm that specializes solving complex business problems by using our deep knowledge of information-intensive industries and by leveraging our world-class technology innovation capabilities. Our engagements range from strategy formulation, through to people and process change, to the delivery and support of technology solutions.

Detica is a fast growing business with over 1000 employees. Detica’s thirty-five year history is marked by a focus on a culture conducive to success for both clients and consultants.

Over the past few years, Detica Group PLC has created a leading Global Financial Services specialist business and technology consulting practice with offices in New York, Chicago, Washington, London, Amsterdam and Geneva.

The Global Financial Service Business Unit (GFS) provides innovative and focused consultancy services to clients within Financial Markets, Retail Banking and Insurance.

As a SAS Consultant, you will play a key part in the delivery of SAS based solutions ranging from MI reporting solutions right through to fully blown analytical data warehouses. This role is likely to include: design, build and test of small to medium end-to-end SAS processes, design and implementation of data marts/data warehouses, design, build and test of SAS BI Solutions, performing analytics using the SAS toolkit, leadership of small teams of developers and involvement in bid response. Depending on the size of a given opportunity this role may either be the Detica lead (fulfilling a number of roles), or working in conjunction with other specialists (e.g. technical architects / delivery managers).

This position is based in our NY office and reports to the Head of Data Management and Analytics.

Detica develops a diverse range of systems and we are able to offer consultants a wide variety of work with other highly-skilled Detica consultants.


  • A degree in a technical/ mathematical discipline from a four year college or university, but just as important is demonstrable expertise in a relevant consulting or technology area, strong client-facing skills and evidence of continued career progression.
  • 1-3 years of relevant experience in the financial services- gained either in a blue-chip company or major consultancy environment
  • 1-2 years of experience with employing various types of analytical techniques including statistical analysis, neural networks and optimization to describe behaviors, make predictions, measure performance and optimize actions.
  • A successful track record of delivering SAS based solutions within a cross-section of Financial Services disciplines. A successful candidate would be expected to demonstrate experience in a number of the following areas: pre-sales work, initial client engagement, requirements gathering, solution design, solution implementation, testing and performance optimisation.
  • Proven successful commercial experience in developing Data Warehouses, Business Intelligence, Data Quality and Management Information/Analytics solutions using SAS software, you will also have an exposure to and understanding of various business problems including Data Warehousing, Customer Relationship Management, Supplier Relationship Management, Management Information and general Business Intelligence.
  • Comfortable working on highly customized solutions as well as with commercial software packages and be able to differentiate between established/proven technology and pioneering/immature technology.
  • Ability to accurately and thoroughly gather and document business visions and detailed requirements, and have a firm understanding of the design/delivery implications associated with these requirements.
  • Have a familiarity with all of the major components within data warehouse architecture (such as enterprise warehouse, ETL, OLAP reporting, operational data stores, meta data management, data marts, analytical warehouse and reference data management).
  • Comfortable with working directly with the customer to understand their requirements and translate these into scalable, robust and maintainable designs and solutions.
Demonstrable knowledge of structured approaches to the full development lifecycle. You are able to identify and control both technical and project/commercial risks and facilitate issue resolution, liaising with the Project or Delivery Managers within Detica or client organisations as appropriate.


  • Use commercial/pragmatic abilities to understand and interpret client requirements.
  • Estimate low level design and development effort.
  • Evaluate and select SAS software tools and solution options
  • Involved in the Data Management and Analytics profession
  • Contribute to the SAS Special Interest Group (SiG)
  • Produce relational and/or dimensional data models.
  • Design and develop commercial analytical SAS based solutions.
  • Respond to client requests, anticipate problems and meet client needs using innovative approaches.
  • Deliver high quality work to meet expectations and deadlines.
  • Lead and work within a multi-disciplined team including client design / development teams and technology partners.
  • Involved in full development life cycle.
  • Share knowledge and assist team members.
  • Contribute to improve development approaches and quality of deliverables.
Maintain progress reports and highlight issues before they become a problem.

Personal Skills

  • Excellent communication skills, both written and verbal, in order to be able to communicate technical solutions in non-technical terms with senior client stakeholders, drive selection and agreement of options, align business and technical teams and motivate delivery teams.
  • Excellent analytical and problem solving skills.
  • Self motivated and motivates others keeping morale and performance high.
  • Ability to prioritise workload and work well under pressure to meet deadlines and manage business expectations. Strong progress and issue reporting skills.
  • The ability to establish and maintain relationships with client stakeholders and to work across different projects or clients.
Flexible approach to hours, dress (smart or casual to suit client environment), work location and tasks to meet client needs.


  • Ability to speak confidently on technical subjects with limited preparation commanding respect and authority and to liaise with clients on difficult or sensitive topics.
  • Experience of SAS programming with Base SAS
  • Commercial experience in the use of SAS DI Server (DI Studio) and/or SAS BI Server (Information Maps, Stored Processes, Web Report Studio, Enterprise Guide).
  • Familiar with the SAS9 Enterprise Intelligence Platform including SAS Enterprise Miner.
  • Familiar with one or more relational databases such as Oracle, IBM UDB, NCR Teradata, Netezza, DATAllegro, Informix, SQL Server and of analytical data stores such as SAS, Sand Technology and Alterian.
  • Familiar with other Extract, Transform and Load (ETL)/Data Management/Data Quality Management tools such as Informatica, PowerCenter, Ascential Data Stage, Ab Initio, Business Objects Data Integrator, Oracle Warehouse Builder, Trillium, DataFlux.
  • Familiar with other query / reporting tools, such as Business Objects / Crystal reports, Microsoft Reporting Services, SAS.
  • Experience of multi-dimensional analysis tools such as Hyperion Essbase, Microsoft Analysis Services, Oracle OLAP, SAS OLAP, Microstrategy and Cognos would be an advantage.
  • Experience with SAS Statistical Packages and Predictive Models development (decision trees, clustering, regression etc.) would be an advantage.
  • Experience of visualisation/specialist analytical tools & technologies would be an advantage.
  • Experience in data modeling and design/development of database stored procedures, triggers, SQL would be an advantage
  • Certification in SAS would be an advantage.
  • Understanding of data warehousing fundamentals such as change data capture, historical data stores, enterprise layers etc
Basic understanding of operational systems concerns, including performance, capacity management, backup and resilience, and the impact of design and coding on these.

To Apply For This Position

  • Go to the Detica website at www.detica.com
  • Click on “Career” from the top gray toolbar
  • “Search current vacancies” on the right side bar
  • “Conduct vacancy search”: Region: USA; Location: NY; Business Unit: Global Financial Services (GFS); Job Role: Data Analysis
  • Click “Search and Apply”
  • Click on “Junior SAS Consultant”
“Click here to apply for this job” and follow the prompts

URL: www.datashaping.com/jobs17346x.shtml
Please mention datashaping.com when applying. Thank you.

No comments: