About the role
Data Specialist
Job requirements
Role Summary We are looking for an experienced ETL/SAS Engineer responsible for designing, developing, testing, and maintaining data integration and ETL processes using SAS and SQL. The role involves extracting data from multiple sources, transforming and validating the data, and loading it into data warehouses and downstream applications. Key Responsibilities
- Develop and maintain ETL workflows and data pipelines using SAS and SQL.
- Design, develop, and optimize SAS programs, SAS macros, SAS procedures, and stored processes.
- Extract data from various sources including Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.
- Perform data cleansing, transformation, validation, aggregation, and reconciliation.
- Develop complex SQL queries, joins, subqueries, views, and stored procedures.
- Work with SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.
- Build and maintain batch processing and scheduled ETL jobs.
- Perform data mapping and source-to-target analysis based on business requirements.
- Implement data quality checks and investigate data discrepancies.
- Optimize SAS programs and SQL queries for performance and scalability.
- Perform unit testing, integration testing, regression testing, and production validation.
- Monitor daily ETL jobs and troubleshoot job failures, data issues, and performance problems.
- Analyze production incidents and perform root-cause analysis (RCA).
- Maintain technical documentation, data mapping documents, ETL specifications, and operational procedures.
- Work closely with Business Analysts, Data Analysts, Developers, QA teams, and business stakeholders.
- Participate in Agile/Scrum ceremonies, sprint planning, backlog refinement, daily stand-ups, reviews, and retrospectives