Data Specialist - R01571487

Brillio 2; Bengaluru; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Brillio is seeking an experienced Data Specialist to design, develop, test, and maintain ETL processes using SAS and SQL. The role involves extracting data from multiple sources, transforming and validating data, and loading it into data warehouses and downstream applications.

You will develop SAS programs, macros, SQL queries, and batch ETL jobs, while ensuring data quality and performance. Collaboration with BAs, Data Analysts, Developers, QA, and stakeholders in an Agile/Scrum environment is

Qualifications

• Experience designing ETL workflows using SAS and SQL.
• Ability to extract data from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.
• Strong SAS knowledge: SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.
• Develop and maintain batch ETL jobs and data pipelines.
• Perform data cleansing, transformation, validation, and reconciliation.
• Create and optimize complex SQL queries and stored procedures.
• Collaborate with analysts, developers, QA, and business stakeholders in Agile/Scrum.
• Maintain comprehensive data mappings and ETL specifications.

Responsibilities

• Design, develop, test, and maintain ETL processes using SAS and SQL.
• Monitor and troubleshoot daily ETL jobs and data issues.
• Develop SAS programs, macros, and stored procedures for data integration.
• Ensure data quality and validation across data sources and warehouses.
• Collaborate with business analysts and data stakeholders to refine requirements.
• Maintain technical documentation and ETL specifications.

Skills

ETL workflows

SQL scripting

SAS programming

Data mapping

Data quality checks

Root-cause analysis

Agile/Scrum participation

Tools

SAS Base

SAS Macro

SAS SQL

SAS Enterprise Guide

Oracle

SQL Server

DB2

Job description

Data Specialist

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