Remote Jobs RockRemote Jobs Rock

Data Specialist - R01573377

๐Ÿ•’ 4 days ago
ETL DevelopmentSQLPL/SQLT-SQL
Apply Now

๐Ÿ“œ Description

  • Design and implement ETL workflows that load high-quality, consistent data into warehouses.
  • Develop and optimize SQL queries, stored procedures, and scripts for data processing and reporting.
  • Partner with data architects and business analysts to define requirements and deliver scalable ETL solutions.
  • Build and maintain data models and warehousing solutions for analytics and reporting.
  • Automate data pipelines with Python and ETL tools; monitor performance and troubleshoot failures.
  • Document data flows and ETL processes to support maintenance and knowledge transfer.

๐Ÿ› ๏ธ Requirements

  • 4 to 6 years of professional experience, including at least 3 years of hands-on ETL development and data integration.
  • Substantial experience with SQL-based solutions, including advanced SQL, query optimization, and stored procedures.
  • Experience with ETL tools such as Talend or Boomi.
  • PL/SQL, T-SQL, and Python scripting skills.
  • Knowledge of data warehousing and relational and dimensional data modeling.
  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline.
  • ETL, data integration, SQL, or database technology certification.
Full job description
Data Specialist

Primary Skills

  • ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
  • Specialization

  • ETL Specialization: Data Engineer
  • Job requirements

  • Experience Range: 4 to 6 years of professional experience, including at least 3 years of hands-on ETL development and data integration, with substantial experience in SQL-based solutions Key Responsibilities: 1. Design and implement robust ETL workflows to extract, transform, and load data from multiple sources into data warehouses, ensuring high data quality and consistency 2. Develop, optimize, and maintain advanced SQL queries, stored procedures, and scripts for efficient data processing and reporting 3. Collaborate with data architects and business analysts to define data requirements and deliver scalable ETL solutions aligned with business objectives 4. Build and maintain data models and warehousing solutions to support analytics and reporting initiatives 5. Troubleshoot and resolve ETL process issues to ensure data accuracy and reliability 6. Automate data pipelines using Python and ETL tools to improve operational efficiency 7. Monitor ETL job performance, conduct root cause analysis for failures, and implement improvements for optimal system performance 8. Document ETL processes and data flows to support ongoing maintenance and knowledge transfer Required Skills: 1. ETL development using tools such as Talend or Boomi 2. Advanced SQL for query optimization and complex data manipulation 3. PL/SQL programming for Oracle-based data integration 4. T-SQL scripting for Microsoft SQL Server environments 5. Python scripting for ETL automation and data processing 6. Data warehousing implementation and maintenance 7. Relational and dimensional data modeling 8. Stored procedure development for data transformation 9. Performance tuning of ETL workflows and SQL queries Preferred Skills: 1. Knowledge of cloud-based data integration solutions 2. Familiarity with big data technologies such as Hadoop or Spark 3. Exposure to real-time data streaming and ingestion frameworks Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline 2. Certification in ETL or data integration technologies such as Talend Data Integration, Informatica, or Microsoft Certified: Azure Data Engineer Associate 3. Certification in SQL or database technologies such as Microsoft SQL Server or Oracle PL/SQL Developer Certified Associate
  • PubMatic

    Data Engineer โ€“ Mobile Monetization โ€“ Big Data, GenAI & Mobile AdTech

    ๐Ÿ•’ 3 days ago
    PubMatic๐Ÿ‘ฅ 1001 - 5000 employees๐Ÿข Internet

    Build and operate high-scale real-time and batch data platforms for mobile advertising, powering bidding, attribution, campaign optimization, fraud detection, analytics, and GenAI-enabled automation.

    JavaGoRustApache Spark
    NucleusTeq

    Data Integration Developer (Informatica CDI)

    ๐Ÿ•’ 5 days ago
    NucleusTeq๐Ÿ‘ฅ 201 - 500 employees๐Ÿข Information Technology And Services

    Design, build, test, and maintain Informatica CDI data pipelines that integrate and transform data across cloud and on-premise platforms for enterprise analytics and reporting.

    Informatica Cloud Data Integration (cdi/idmc)SQLData Pipeline DevelopmentData Integration

    Lead part of the FCP Data Visualization and Reporting teamโ€™s migration from on-premises to GCP, refactoring data pipelines and coordinating technical solutions, requirements, estimates, and project updates.

    GCPBigqueryIAMDataproc

    Trusted by Remote Workers