Description
Valleysoft is a premier technology solutions provider dedicated to enabling organizations to harness the power of data for business growth and operational excellence. We specialize in delivering cutting-edge integration and analytics solutions that drive informed decision-making.
We are seeking a proficient SAS integration developer to join our talented team. In this role, you will be responsible for designing, developing, and implementing integration solutions that connect SAS platforms with various enterprise systems, ensuring seamless data flow and process automation.
The ideal candidate will have strong experience in SAS technologies and integration frameworks, coupled with excellent problem-solving skills and the ability to collaborate effectively with cross-functional teams. If you are passionate about driving data-centric integration initiatives and working with advanced analytics tools, Valleysoft invites you to apply!
Requirements
- Design, develop, and maintain SAS-based integration solutions that connect core banking systems, data warehouses, and analytical platforms across the enterprise.
- Build and optimize SAS Data Integration Studio jobs covering extraction, transformation, and loading (ETL) from heterogeneous source systems including Oracle, SQL Server, IBM Db2, and flat-file feeds.
- Develop and manage SAS stored processes, macros, and reusable code libraries to support downstream BI, reporting, and analytical consumers.
- Translate business and functional requirements into technical SAS integration specifications, mapping documents, and data flow designs.
- Implement and maintain data transformation logic for complex business rules, data cleansing, enrichment, and aggregation pipelines.
- Collaborate with data architects and data governance teams to ensure integration solutions comply with metadata standards, data lineage requirements, and classification policies.
- Integrate SAS pipelines with enterprise scheduling platforms (Control-M or equivalent) to ensure reliable, sequenced, and monitored job execution.
- Perform performance tuning of SAS jobs — optimizing I/O, reducing dataset passes, applying SAS options (COMPRESS, BUFSIZE, SASTRACE) and SQL passthrough where applicable.
- Participate in system integration testing (SIT), UAT, and production release cycles following change management procedures.
- Maintain comprehensive technical documentation for all integration flows, job dependencies, error handling procedures, and recovery runbooks.
SAS-Specific Requirements
- Strong proficiency in SAS Base programming — data steps, PROC SQL, macro language, and array processing.
- Hands-on experience with SAS Data Integration Studio — designing and deploying jobs, managing transformations, and configuring metadata connections.
- Solid knowledge of SAS metadata architecture: Metadata Server, libraries, SAS LIBNAME engines (Oracle, ODBC, DB2, HADOOP).
- Experience with SAS Management Console for user administration, metadata management, and server configuration.
- Proficiency in SAS/ACCESS interfaces for connecting to relational databases with implicit and explicit SQL passthrough.
- Experience with SAS Viya (CAS data loading, SAS Studio flows, REST API integration) is a strong plus.
- Familiarity with SAS Web Services or REST-based integration patterns for connecting SAS with external applications is a plus.
- Understanding of SAS stored process deployment on SAS 9.x mid-tier and Viya environments.
- Experience with SAS/CONNECT for remote job submission and parallel processing across SAS grid environments is advantageous.
Banking Sector Requirements (Preferred)
- Prior experience developing SAS integration solutions within a bank or financial institution, preferably in data warehousing, regulatory reporting, or risk analytics domains.
- Familiarity with banking source systems commonly integrated via SAS — core banking platforms, GL systems, loan origination systems, and card management systems.
- Experience building SAS pipelines for regulatory reporting datasets (CBE submissions, IFRS 9 staging, AML transaction feeds).
- Understanding of data reconciliation requirements in banking: balancing ETL outputs against source system totals and ledger figures.
- Experience operating within change control and ITIL-aligned release processes, including impact assessment documentation and rollback planning.
- Exposure to data security and masking requirements for sensitive banking data flowing through SAS integration layers is a strong plus.
Benefits
- Private health insurance
- Training & development