SAS DI Studio and Advanced SAS/SQL

INENT INC; Charlotte (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

INENT INC is looking for a SAS DI Studio and Advanced SAS/SQL Programmer in Charlotte, NC. The successful candidate will design and develop ETL solutions, leveraging extensive experience with SAS Data Management Studio and strong SAS/SQL skills.

The role involves collaboration with developers, business analysts, and DBAs, alongside tasks like optimizing performance within Unix/Linux environments. Candidates should have 5–7 years of relevant experience and a bachelor's degree in a relevant field.

Qualifications

• 5–7 years of experience providing ETL solutions with SAS/ETL tools.
• 5–7 years of experience in a SAS EDI environment focused on SAS Data Integration Studio.
• Strong understanding of Data Warehouse/MDM concepts.

Responsibilities

• Design and develop ETL solutions, including data extraction and transformation.
• Implement solutions using the SAS Detail Data Store banking model.
• Collaborate with SAS developers, business analysts, and DBAs.

Skills

SAS Data Management Studio

SQL

SAS macros

ETL/Data design

Linux/Unix

Education

Bachelor's degree or relevant degree

Tools

SAS/ETL tools

Netezza

Job description

Job Description

Location: Charlotte, NC.

Rate: C2C/W2/1099.

Position: SAS DI Studio and Advanced SAS/SQL Programmer.

The successful candidate will have extensive experience with SAS Data Management Studio (DI Studio), strong SQL and SAS skills, and a solid understanding of the SDLC lifecycle processes. The role involves designing and developing ETL solutions, including data extraction from heterogeneous sources, data transformation (e.g., cleansing), database loading, and providing support to meet business needs. Experience with various database platforms, including Netezza, is required.

Duties and Responsibilities

• Demonstrate expertise in ETL/Data design and development concepts, practices, and procedures.
• Implement solutions using the SAS Detail Data Store (DDS) banking model.
• Develop and recommend strategies and specifications for technical data solutions based on business goals, objectives, needs, and existing data infrastructure.
• Design new logical, conceptual, and physical data models for data and system flows.
• Architect high‑performance, scalable, and complex enterprise‑grade systems.
• Collaborate with SAS developers, business analysts, DBAs, and system administrators to design and implement database solutions and write ETL programs.
• Work closely with the team responsible for maintaining the data model, including data dictionary and metadata registry.
• Document programming problems and resolutions for future reference.
• Perform ETL data extraction, transformation, and loading using SAS/ETL tools.
• Write and maintain SAS macros and SQL scripts.
• Optimize performance within a Unix/Linux environment, including shell scripting.
• Document and communicate solutions effectively, both written and verbal.
• Manage multiple concurrent tasks and projects, meeting deadlines with attention to detail and accuracy.
• Collaborate effectively within a team environment.

Qualifications

• At least 5–7 years of experience providing ETL solutions with SAS/ETL tools.
• 5–7 years of experience in a SAS EDI environment, focused on SAS Data Integration Studio, Base SAS, SAS macros, and SQL.
• 1 year of experience with the SAS DDS banking model.
• 2 years of experience in Linux/Unix environments.
• Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).
• Proficiency with relational databases, data warehouses, and business intelligence solutions.
• Excellent teamwork, collaboration, and communication skills.
• Bachelor’s degree or a relevant degree.