Remote Jobs RockRemote Jobs Rock

Data Specialist - R01571487

📅 Sep 22
📍 🇮🇳 Bengaluru - Hybrid🎹 Mid-level🛢️ Data Engineer💼 Full-Time
SAS BaseSAS MacroSAS SQLSAS Enterprise Guide
Apply Now

📜 Description

  • Develop and maintain ETL workflows, data pipelines, batch processing, and scheduled jobs using SAS and SQL.
  • Build and optimize SAS programs, macros, procedures, stored processes, and complex SQL queries.
  • Extract, cleanse, transform, validate, aggregate, and reconcile data from databases, files, and APIs.
  • Perform data mapping, source-to-target analysis, and data quality checks; investigate discrepancies.
  • Test ETL processes, monitor daily jobs, troubleshoot failures, and conduct production incident root-cause analysis.
  • Maintain technical documentation and collaborate with analysts, developers, QA teams, stakeholders, and Agile teams.

🛠️ Requirements

  • Experienced ETL/SAS engineering background.
  • Experience designing, developing, testing, and maintaining data integration and ETL processes using SAS and SQL.
  • Knowledge of SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.
  • Ability to work with Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.
Full job description
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
    • Apply Now

    Similar jobs

    Search more Data Engineer jobs
    Thehartford

    Data Engineer - Google Cloud Platform

    🕒 4 days ago
    Thehartford👥 10,000+ employees🏢 Financial Services
    WebsiteLinkedInAll Job Openings

    Build scalable GCP data pipelines and governance integrations, embedding metadata, lineage, and automation into secure enterprise data solutions while collaborating across engineering and business teams.

    📍 🇺🇸 Charlotte - Hybrid💰 $101.0k - $151.4k / year💼 Full-Time🎹 Mid-level🛢️ Data Engineer
    Google Cloud PlatformBigqueryCloud StorageIAM
    View jobApply
    Sopra Steria

    Data Engineer Stockholm

    🕒 8 days ago
    Sopra Steria👥 10,000+ employees🏢 Information Technology And Services
    WebsiteLinkedInAll Job Openings

    Build, optimize, and future-proof modern data platforms, supporting cloud migrations and shaping the analytics pipeline from data collection and modeling through visualization and decision support.

    📍 🇸🇪 Stockholm - Hybrid💼 Full-Time🎹 Mid-level🛢️ Data Engineer📢 🇸🇪 Swedish Required📢 🇬🇧 English Required
    Data EngineeringMicrosoft FabricAzure SynapseAzure Databricks
    View jobApply
    View more Data Engineer jobs

    Trusted by Remote Workers