Descripción
We are looking for an experienced SAS Data Integration Studio (DIS) Lead Developer, preferably with the capability and experience to also work in a Solution Architect role. The consultant will be responsible for the architecture and technical design of SAS 9.x data integration, data warehouse and data mart solutions. The role includes designing and developing ETL/ELT pipelines using SAS Data Integration Studio, Base SAS and SQL, translating business, reporting, regulatory and operational requirements into solution designs, and defining data models, transformation rules and reusable technical standards. Key Responsibilities Solution Architecture and Design: · Own the architecture and technical design of SAS 9.x data integration, data warehouse and data mart solutions. · Translate business, reporting, regulatory and operational requirements into logical and physical solution designs. · Design and develop robust ETL and ELT pipelines using SAS Data Integration Studio, Base SAS and SQL. · Define source-to-target mappings, transformation rules, data flows, dependencies, restart points and error-handling patterns. · Design and develop and guide conceptual, logical and physical data models, including dimensional, normalized or vault-style models where appropriate. · Establish reusable standards for job structures, naming, parameterization, logging, auditing, exception handling and documentation. · Evaluate architectural trade-offs involving data movement, database pushdown, SAS processing, storage, scheduling and downstream consumption. Required Experience: · SQL (mandatory) · ETL (mandatory) · Databricks · SAS, DI studio (mandatory) · SAS Base (mandatory) Background check needed will be informed if candidate is chosen. Answer these questions separately in a few sentences and attach them to your application! (Mandatory!) - Do you have hands-on experience designing and developing ETL/ELT pipelines using SAS Data Integration Studio (SAS 9.x)?* - Do you have strong practical