Int SAS Developer to manipulate, extract, transform, and load data from SAS and non-SAS (Sybase or Oracle or DB2 databases) data sources - 38178-1
S.i. Systems
Toronto
1d ago

Request ID : 38178-1

Start / End Dates : 1 / 11 / 2022 - 7 / 10 / 2022

Work Location : Toronto, Ontario

Position Title : SAS Programmer Analyst

Reason for the Opening :

  • Large work volumes within the group and some new projects in the pipeline within the fiscal year and will allocating resources where required with the help of contractors
  • Scope of Work (including but not limited to the following) :

    1. Responsible for supporting the development of data management and transformation solutions.

    2. Perform complex manipulation of large datasets in SAS to restructure data for analysis, create user tables and create output files to external vendors.

    3. Work with the existing development team to support development of rules-based processes including testing and QA based on documented requirements.

    4. Assist in writing and maintaining of technical documentation in support of the development process.

    Daily Responsibilities :

  • Data manipulations including the usage of basic standard SAS procedures and use of SAS Macros
  • Working with large data (i.e., millions of records) from SAS and non-SAS (Sybase or Oracle or DB2 databases) data sources into a SAS environment and performing SAS data manipulations against the resulting sets
  • Transform the resulting SAS datasets into specific output file formats and subsequently being able to manipulate the resulting text files with UNIX commands to include standard headers and trailers
  • Automate applications including incorporating appropriate checks and controls
  • Validate and test all code for accuracy and efficiency
  • Assist in the development of solutions by recommending alternative solutions to technical problems
  • Extracting, transforming and loading source data into the SAS environment from multiple sources including major DBMS and application transaction files
  • Interacting with the HM, the immediate team, and some stakeholders (to get what their needs are, not always working with BAs)
  • Must Have Skills :

  • 5+ years of SAS programming experience including SAS Macros
  • Experience in extracting, transforming, and loading data ( ETL ) into the SAS environment from multiple RDBMS sources (Sybase or Oracle or DB2 databases)
  • Experience in building data management processes using SAS, SAS Macros, SQL, and Sybase
  • Nice to Have Skills :

  • Knowledge of Unix
  • Large data (large enterprise) exposure
  • Financial Industry Experience
  • Exposure to production environment (producing reports and / or automation)
  • Modeling analytics environment exposure
  • SAS Certification
  • Educational Background :

  • University Degree
  • Interview Process :

    60 minutes which will be technical and behavioral virtual

    Expertise and Skills

  • Data Analytics, ETL Developer 5 - 7 years
  • Priority Requirements

    Work Environment

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form